Database Backup and Recovery (MOSC)

MOSC Banner

Do I need set until sequence when create new db from primary backup

edited Dec 29, 2011 2:37PM in Database Backup and Recovery (MOSC) 2 commentsAnswered
 Hi all,

   I posted article about Create new single database from standby backup and Shailesh help me solve problems at 2897214. Now, I want ask that: If I backup primary database use: 

   backup incremental level 0 format '...' database plus archivelog;

   And I use this backup to create new single db, Do I need set until sequence <seq_no> thread <thread_no> in RMAN script, just only (ofcourse, I restored controlfile success):

 
   run{
         set newname for datafile 1 to '...';
         ....
         restore database;
         switch datafile all;
         recover database;
   }

   rename redo logs success and open database resetlogs !

   Some links that I read about create new single db them also said about use set until seq... So, in my case, Do I need set until sequence when I restored controlfile succes, RMAN can know last sequence is backed up from this controlfile ?

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