Tuesday, 31 December 2013

consistent and inconsistent backup


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