Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Point in time recovery

RE: Point in time recovery

From: <ddorr.cs_at_clearstream.com>
Date: Wed, 31 May 2000 11:13:00 +0200
Message-Id: <10514.107226@fatcity.com>


Thanks to all for your responses.
I've also found a note ( Note:29430.1 ) on Metalink about : ' How to recover a database having added a datafile since the last backup ' which says that one have to create the datafile and resume the recovery. So this seems to be the 'normal' behaviour of the Oracle recovery process.

> ----------
> From: A. Bardeen[SMTP:abardeen1_at_yahoo.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Wednesday, May 31, 2000 06:24
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Point in time recovery
>
> The correct command is:
>
> ALTER DATABASE CREATE DATAFILE '<filename>';
>
> This will create the file at the OS level, after which
> the recovery command can be executed again.
>
> Note: This requires using a controlfile that contains
> the info from when these datafiles were created (i.e.
> the controlfile has to be from AFTER the datafiles
> were added).
>
> HTH,
>
> -- Anita
> --- Chris Royce <Chris_at_Royce.net> wrote:
> >
> >
> > 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).
> >
> > --
> > Author: Chris Royce
> > INET: Chris_at_Royce.net
> >
> > 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).
>
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/
> --
> Author: A. Bardeen
> INET: abardeen1_at_yahoo.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
Received on Wed May 31 2000 - 04:13:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US