Weird recovery, need help please
- From: "Oracle" <all_about_oracle@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 25 May 2005 01:13:00 +0800
Hi,
I practice backup and recovery and experience weird result, oh may Oracle
bug or may be my method is incorrect.
Here is what I have
Fact:
Time 1 -> Cold backup
Time 2 -> Create table
Time 2.1 -> insert few records
Time 2.2 -> alter system switch logfile; (5 times)
Recovery:
I try to recover database with Time 1 cold backup (including the control
file) and Time 2 archive redolog.
Step:
1. Restore Cold Backup
2. Startup mount (started)
3. recover database until cancel using backup control file;
step 3 give me error
SYS@[Canada] SQL+> recover database until cancel using backup controlfile;
ORA-00279: change 3880315 generated at 05/25/2005 00:16:29 needed for thread
1
ORA-00289: suggestion : C:\ORACLE\ORADATA\CANADA\ARCHIVE\ARC01654.001
ORA-00280: change 3880315 for thread 1 is in sequence #1654
I don't understand why I can't roll forward using cold backup, Oracle said
"USING BACKUP CONTROLFILE" will ignore the SCN.
Please help.
Regards,
Sin
--
//www.freelists.org/webpage/oracle-l
Other related posts:
