Re: Oracle recovery problem ???????????????????????????????????????????????????????????????????

You should use the last control files or tell oracle that you are using the backup control files.

Refer to Rama Velpuri's Book about Backup and Recovery. I think it covers a scenario in detail.

uday

A Ustby wrote in message <34ff0765.0_at_news7.centuryinter.net>...
>
>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