Re: Point in time recovery

Just a quick thought - this is also a problem with 'standby databases' as the ddl in the redos will not create the datafiles - startup the database 'mount' and try to do an 'alter system add datafile '/dir/oradata/instance/file_name etc' size 999M;' . I really do not know (I haven't had a chance to try it) if this will work but is worth a try. Let me know ?? I will probably test your scenario tomorrow.

Good Luck

Chris Royce

ddorr.cs_at_clearstream.com wrote:

> I am trying to recover a database up to a certain point in time.
> Restored my disks from a backup (disk to disk copy with raw devices on
> disks), and the archived redo logs from tape,
> started a RECOVER database until time <timespec> using backup controlfile;
> and finally got :
>
> ORA-00283: Recovery session canceled due to errors
> ORA-01244: unnamed datafile(s) added to controlfile by media recovery
> ORA-01110: data file 66: '/dev/rdsk/RTS_BS2/CRE_DATA01_03'
> ORA-01110: data file 65: '/dev/rdsk/RTS_BS2/CRE_DATA01_02'
> ORA-01110: data file 64: '/dev/rdsk/RTS_BS2/CRE_DATA01_01'
>
> What happend is that we added datafiles after the backup, but I thought
> Oracle - during the roll forward process - could handle the add datafile
> process and update the controlfile, like in normal operation.
>
> Any thoughts ?
> --
> Author:
> INET: ddorr.cs_at_clearstream.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue May 30 2000 - 16:50:30 CDT