Oracle recovery problem ???????????????????????????????????????????????????????????????????

From: A Ustby <austby_at_centuryinter.net>
Date: 1998/03/05
Message-ID: <34ff0765.0@news7.centuryinter.net>#1/1

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 Thu Mar 05 1998 - 00:00:00 CST