SQL*Plus: Release 9.2.0.1.0 - Production on Fri Jan 8 23:41:50 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> shutdown;
Database closed.
Database dismounted.
ORACLE instance shut down.
--------------------------------------------------------------------------------------------------------------------------
------startup and copy all datafile,control file and redolog file and paste new location and startup---(consistent backup)-----
------------------------------------------------------------------------------==========================================
SQL> startup;
ORACLE instance started.
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL>
====================================================================================================
----------startup and make a backup of online tablespace-----------------------------
===============================================================================================
SQL> alter tablespace users begin backup;
Tablespace altered.
SQL> alter tablespace users end backup;
Tablespace altered.
SQL>
SQL> alter tablespace system begin backup;
Tablespace altered.
SQL> alter tablespace system end backup;
Tablespace altered.
No comments:
Post a Comment