Home » RDBMS Server » Backup & Recovery » Controlfile piece handle lost from Tape
Controlfile piece handle lost from Tape [message #506552] Mon, 09 May 2011 19:02 Go to next message
hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI
Member
We are trying to restore a database to a cold backup DBID.However while our datafiles were backuped up for 6 months retention we found out subsequent delete obsolete command wiped out the Control file related to this backup piece..Now what is left with this backup piece is just datafiles..

Can we still recover the database with a subsequent controlfile autobackup for the same DBID.?
Re: Controlfile piece handle lost from Tape [message #506554 is a reply to message #506552] Mon, 09 May 2011 19:21 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Can we still recover the database with a subsequent controlfile autobackup for the same DBID.?
or do similar to below
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "V112" NORESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 '/u01/app/oracle/oradata/v112/redo01.log'  SIZE 50M BLOCKSIZE 512,
  GROUP 2 '/u01/app/oracle/oradata/v112/redo02.log'  SIZE 50M BLOCKSIZE 512,
  GROUP 3 '/u01/app/oracle/oradata/v112/redo03.log'  SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
  '/u01/app/oracle/oradata/v112/system01.dbf',
  '/u01/app/oracle/oradata/v112/sysaux01.dbf',
  '/u01/app/oracle/oradata/v112/undotbs01.dbf',
  '/u01/app/oracle/oradata/v112/users01.dbf',
  '/u01/app/oracle/oradata/v112/example01.dbf'
CHARACTER SET AL32UTF8
;
-- Commands to re-create incarnation table
-- Below log names MUST be changed to existing filenames on
-- disk. Any one log file from each branch can be used to
-- re-create incarnation records.
-- ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/flash_recovery_area/V112/archivelog/2010_12_17/o1_mf_1_1_%u_.arc';
-- ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/flash_recovery_area/V112/archivelog/2010_12_17/o1_mf_1_1_%u_.arc';
-- Recovery is required if any of the datafiles are restored backups,
-- or if the last shutdown was not normal or immediate.
RECOVER DATABASE
-- Database can now be opened normally.
ALTER DATABASE OPEN;
-- Commands to add tempfiles to temporary tablespaces.
-- Online tempfiles have complete space information.
-- Other tempfiles may require adjustment.
ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/v112/temp01.dbf'
     SIZE 39845888  REUSE AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M;
-- End of tempfile additions.
Re: Controlfile piece handle lost from Tape [message #506579 is a reply to message #506552] Tue, 10 May 2011 01:30 Go to previous message
John Watson
Messages: 8702
Registered: January 2010
Location: Global Village
Senior Member
I think you can restore OK. You used the phrase "controlfile autobackup", which sounds like RMAN. That makes it harder than the way Black Swan is suggesting, which assumes a user managed backup. You will have to extract the datafiles from backup sets.
The technique will be to create a controlfile (as Black Swan says), and mount it. Then you will have catalog the backup pieces that contain the datafiles. You should then be able to issue the RESTORE command.
Previous Topic: NID- utility giving ora-01103 error
Next Topic: hot backup in noarchivelog mode
Goto Forum:
  


Current Time: Tue May 17 05:20:31 CDT 2022