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

On 5 Mar 98 20:13:25 GMT, austby_at_centuryinter.net (A Ustby) wrote: Hi,

in addtion to what Julio posted:

-You've got to switch logfile's (number_of_log_files + 1) times to ensure that all your onlines whre archived. -Don't backup onlines and therefor don't restore onlines. This might be a reason for the trouble you've now: you copied old online into your new location.

>
>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
>

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de