Database Backup and Recovery (MOSC)

MOSC Banner

there is a strange when Restore db !

edited Dec 31, 2011 4:34AM in Database Backup and Recovery (MOSC) 3 commentsAnswered
 Hi all,   
   There is a strange problem when restore and recover database (the goal is create new database). The backing up database is complete and it's valid. Script to perform this work is:

   run{
         restore database;
         recover database;
         alter database open resetlogs;
   }

   Actually, the restore and recover is success ! But here, I have two cases:

   1. I backup standby db, with total of archive logs is 100 archive log files. --> When RMAN restore database files success, continue to media recover database, it restore 100 archive files !
   
   2. I backup primary db, with total of archive logs is 100 archive log files --> When RMAN restore database files success, continue to media recover database, it restore not enough 100 archive files !

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center