-
Hi,
I restored cold backup datafiles to a new database and then recreated controlfiles. However, I got a little bit of problem during the process. Then I shutdown db and tried to recreate the control files again, but Oracle generated more errors on system datafile needed recovery.
SVRMGR> startup;
ORACLE instance started.
Total System Global Area 73374740 bytes
Fixed Size 76820 bytes
Variable Size 56348672 bytes
Database Buffers 16777216 bytes
Redo Buffers 172032 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/backup2/oradata/PS8DEV/system01.dbf'
SVRMGR> recover database until cancel;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SVRMGR> recover database until cancel using BACKUP CONTROLFILE;
ORA-00279: change 1008370 generated at 05/18/2001 10:20:54 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/product/8.1.7/dbs/arch/1_1.dbf
ORA-00280: change 1008370 for thread 1 is in sequence #1
Specify log: {=suggested | filename | AUTO | CANCEL}
CANCEL
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/backup2/oradata/PS8DEV/system01.dbf'
goodhealth
-
What kind of problem did you get after you created control file? It looks like you have inconsistent database backup.
Sergey.
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
|