whole backup + controlfile backup ct1
add a datafile
drop a tablespace
add a tablespace
can i use controlfile backup ct1 to recover to time t+3?
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
if that's the case, what's different if i use ct1 or the one i backup at time t+3?
oracle always suggest to use control file that can reflect the
database structure, but i think any control file older than
the time we want to recover to will do , am i right?
In your case, your control file is changed (details see the following). I don't think you can use the control file backup ct1 to recover to time t+3.
Control Files will be changed and advisable to backup after any following commands is issued:
ALTER DATABASE [ADD|DROP] LOGFILE
ALTER DATABASE [ADD|DROP] LOGFILE MEMBER
ALTER DATABASE [ADD|DROP] LOGFILE GROUP
ALTER DATABASE [NOARCHIVELOG|ARCHIVELOG]
ALTER DATABASE RENAME FILE
ALTER TABLESPACE [ADD|RENAME] DATAFILE
ALTER TABLESPACE [READ WRITE|READ ONLY]
Hope this can help.
Controlfile - SCN - Logfile
Hi, 20th April 2001 16:06 hrs chennai
I want to make you onething clear.
If you are using the contolfile from the backup then
You cannot recover DB to time t+3 with old controlfile of ct1.
If you have the existing controlfile mirrored or back up in trace or the existing contolfile is not damaged there is no need of using old backup controlfile to recover.The copy of the control file with the restored datafiles from backup will help you to move ahead and recover till the last SCN by applying the logfiles.
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
Click Here to Expand Forum to Full Width