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

First, apologize for my bad English.

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
.

I think the problem may be that that changes in step 6 are not commited and , if you don't shutdown in normal mode, so the uncomitted data remain in rollback segments and online redos.

Another suggest, after a recover database make a full backup and open it with resetlogs option.  

> Thanks for any suggestions or help.
>
 

> Art

regards.

-- 

Julio Negueruela
Telf: 941-299179    Fax: 941- 299180
Servicio Inform tico
Universidad de La Rioja - Spain
mailto:julio.negueruela_at_si.unirioja.es