This content has been marked as final. Show 9 replies
performed recovery with archived logs and the existing Redo logWhat command did you issue for the Recovery ? Was it from the RMAN command prompt or SQL command prompt ?
Hemant K Chitale
you used this command for recovery?
if you are restoring controlfile and recovering from it, you don't know last SCN. And if you are applying archive logs and redo logs, database can't verify that you have presented all redo/archive logs. In that case database need to do resetlogs.
recover database until cancel using backup controlfile;
Incomplete recovery in case of lost of redologs, archive logs or point in time recovery are clearly incomplete because you don't have all information from logs and you are going back to history in database.
When you restore the controlfile from backup you always have to open the database with resetlogs (even when you're not restoring any data files).
(edit: additional info)
On the other hand: If you had a trace of your controlfile (alter database backup controlfile to trace) you could have re-created the controlfile with NORESETLOG option (since your online redo logs were intact) and opened the database without the resetlogs option after complete recovery.
Edited by: AJ on 18.jan.2013 06:45
Edited by: AJ on 18.jan.2013 06:49
Hi AJ / Friends,
Thanks for the info and it clarified the question.
But consider this scenario , I am having Redo Logs so in that case can i perform control file restore from RMAN backup (not control Trace File) and perform complete recovery (which i can do if i have redo logs and i create control file using Trace) .
If so , then please let me know the steps.
If not then my question is how come RMAN Control file backup is inferior to the manually created control file (using Trace file)?
Technically, if you RESTORE a Controlfile, it is a BACKUP CONTROLFILE. You need to issue a RESETLOGS after the RECOVERy.
See Performing Recovery with a Backup Control File at http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmadvre.htm#i1008870
Hemant K Chitale
If you restore control file from backup, Oracle do not know how many logs you have even if they are not lost - you could add more redo log groups to thread or even add new thread. So you must use "resetlogs".
If you create new controlfile, then you specify exactly what redo logs you have, and if they are present, "resetlogs" is not needed.
Hi Mihael / Friends,
Thanks , assuming i haven't made any changes to Redo Log groups , in that case can use RMAN to restore control file and perform complete recovery (noresetlog)? Any option is available?
(or) irrespective of whether changes made (or) not to redologs if control file is restored from RMAN then it is mandataory to perform resetlog?
If option 2 is correct then i believe,
Though we use RMAN backup as best method in many ways compared to OS backup , for control file restoration alone it's not good to use RMAN restore as this will end up in new incarnation of database and will invalidate all my old backup's , so it's best to use the control file trace to recreate control file and perform complete recovery. Is this true?
what will happen to my RMAN old backup's if i recreate control file and perform noresetlog / restore control file from RMAN and perform resetlogs? will it be registered (or) not registered in control file in both cases.
Since 10g, Oracle allows Recovery through a RESETLOGS, even if the incarnation changes. One key feature of this is that ArchiveLogs have %r (which is the resetlogs ID) as part of the file name.
If you do a CREATE CONTROLFILE all information about backups that were present in the controlfile are "lost". If you are running without a Recovery Catalog, you lose information about backups. If you are running with a Recovery Catalog, you have the information in the Recovery Catalog but you cannot "synch" the data from the Recovery Catalog to the (newly created) controlfile.
Hemant K Chitale
If you create new controlfile, you can register all backups and archivelogs with rman "catalog" command. The command allows to register single backup or log and also to specify start directory for backups or even full FRA.