Home » RDBMS Server » Backup & Recovery » TSPITR Recovery (Oracle 10g)
TSPITR Recovery [message #493429] Mon, 07 February 2011 20:47 Go to next message
subbu_tce
Messages: 98
Registered: July 2007
Location: pune
Member
Hi,
How many times i can do recover (TSPITR) a tablespace ?
While trying to recover tspitr tablespace on 2nd time i got error message ORA-01178 file 13 created before last create controlfile,but first time it was success.Please suggests me.
Re: TSPITR Recovery [message #493430 is a reply to message #493429] Mon, 07 February 2011 20:50 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
01178, 00000, "file %s created before last CREATE CONTROLFILE, cannot recreate"
// *Cause:  Attempted to use ALTER DATABASE CREATE DATAFILE to recreate a
//          datafile that existed at the last CREATE CONTROLFILE command.
//          The information needed to recreate the file was lost with the
//          control file that existed when the file was added to the database.
// *Action: Find a backup of the file, and recover it. Do incomplete recovery
//          to time before file was originally created.
Previous Topic: RMAN duplicate
Next Topic: Seeking info on rman restore and recovery process
Goto Forum:
  


Current Time: Thu Apr 18 04:29:06 CDT 2024