-
time t:
whole backup + controlfile backup ct1
time t+1
add a datafile
time t+2
drop a tablespace
time t+3
add a tablespace
time 4
crash
can i use controlfile backup ct1 to recover to time t+3?
-
Jurij Modic
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
CREATE TABLESPACE
ALTER TABLESPACE [ADD|RENAME] DATAFILE
ALTER TABLESPACE [READ WRITE|READ ONLY]
DROP TABLESPACE
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.
Cheers
Padmam
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|