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

  ---