Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle recovery problem ???????????????????????????????????????????????????????????????????
Your actual problem is that you restored the old *.ctl files !
Oracle uses the *.ctl files to know wat SCN is current. The recovery (roll forward from the logs) ends when it reaches current.
If you used the current *.ctl files, you would get what you wanted.
The other method available uses the old *.ctl files, but you must inform Oracle that the *.ctl files are old:
RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE; You cancel the recovery when the last log has been applied. Then you: ALTER DATABASE RESETLOGS; In general, you only want to restore the *.ctl files if you are recovering to a point-in-time prior to structural changes in the database (add, drop tablespaces and/or files).
A Ustby wrote:
>
> What am I doing wrong ??????
>
> Oracle v7.3.3, archive mode.
>
> 0) create new table A.
> 1) insert rows into table A.
> 2) alter database switch logfile;
> 3) shutdown
> 4) copy all *.ctl and *.dbf files from normal areas off to backup area.
> 5) startup
> 6) insert rows into table A.
> 7) alter database switch logfile;
> 8) shutdown
> 9) copy all *.ctl and *.dbf from backup area to normal areas.
> 10) startup mount
> 11) recover database
> 12) alter database open noresetlogs;
> 13) select * from table A
>
> What I see is that table A contains only rows done in step 1 NOT step 6.
>
> What am I doing wrong ?????????????
>
> Thanks for any suggestions or help.
>
> Art
Received on Fri Mar 06 1998 - 00:00:00 CST