rman recovery if the missing archive logs are required for recovery

1- ———Restore the database —————–

RMAN> restore database;

Starting restore at 25-AUG-13
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF
channel ORA_DISK_1: restoring datafile 00002 to C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF
channel ORA_DISK_1: restoring datafile 00003 to C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF
channel ORA_DISK_1: restoring datafile 00004 to C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF
channel ORA_DISK_1: restoring datafile 00005 to C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS01.DBF
channel ORA_DISK_1: restoring datafile 00006 to C:\USERS.DBF02.DBF
channel ORA_DISK_1: reading from backup piece C:\ORACLEXE\RMAN\RMAN03OI68FH_1_1
channel ORA_DISK_1: piece handle=C:\ORACLEXE\RMAN\RMAN03OI68FH_1_1 tag=FULL_DATABASE_OPEN
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:25
Finished restore at 25-AUG-13

RMAN>

2- ——-If archive logs are needed during recovery, how to open the DB——

RMAN> recover database;

Starting recover at 25-AUG-13
using channel ORA_DISK_1

starting media recovery

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/25/2013 14:41:03
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 1 with sequence 4 and starting SCN of 10399828871

RMAN> exit
Recovery Manager complete.

3- —Do manual recovery until cancel—-

C:\Users\sherkhan>sqlplus /nolog

SQL*Plus: Release 11.2.0.2.0 Production on Sun Aug 25 14:43:41 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

SQL> conn /as sysdba
Connected.

SQL> recover database until cancel using backup controlfile;
ORA-00279: change 10399829954 generated at 08/25/2013 12:07:13 needed for
thread 1
ORA-00289: suggestion :
C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ARCHIVELOG\2013_08_25\BKP\O1_MF_1_4
_91MJ00OW_.ARC
ORA-00280: change 10399829954 for thread 1 is in sequence #4

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs;
Database altered.
SQL>

--------------Completed -------------
Advertisements

About Sher khan

Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in rman. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s