Tuesday, 31 December 2013

Cancel based recovery


SQL*Plus: Release 9.2.0.1.0 - Production on Fri Jan 8 23:58:24 2010

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> conn /as sysdba;
Connected.
SQL> shutdown;
Database closed.
Database dismounted.
ORACLE instance shut down.
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> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> recover database until cancle using backup controlfile
ORA-01034: ORACLE not available


SQL> recover database until cancle using backup controlfile;
ORA-01034: ORACLE not available


SQL> startup mount;
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.
SQL> recover database until cancle using backup controlfile;
ORA-00277: illegal option to the UNTIL recovery flag CANCLE


SQL> recover database until cancle using backup controlfile
ORA-00277: illegal option to the UNTIL recovery flag CANCLE


SQL> cancle
SP2-0042: unknown command "cancle" - rest of line ignored.
SQL> cancle;
SP2-0042: unknown command "cancle" - rest of line ignored.
SQL>

No comments:

Post a Comment