Home » RDBMS Server » Backup & Recovery » How to restore backup from a patricular set directly from TAPE using RMAN (oracle: 10.2.0.1.0 o/s: windows-2003 )
How to restore backup from a patricular set directly from TAPE using RMAN [message #379389] Tue, 06 January 2009 05:26 Go to next message
kesavansundaram
Messages: 181
Registered: October 2007
Location: MUMBAI
Senior Member

dear sir,

Just for testing purpose, we have taken full backup 3 times ( with small changes in database ) directly into TAPE.
using 3rd party tool ( HP omni-pack data protector )

backup script:
--------------
run {
allocate channel 'dev_0' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=sbiwill1,OB2BARLIST=LcalDB,OB2BARHOSTNAME=128.0.30.227)';
allocate channel 'dev_1' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=sbiwill1,OB2BARLIST=LcalDB,OB2BARHOSTNAME=128.0.30.227)';
allocate channel 'dev_2' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=sbiwill1,OB2BARLIST=LcalDB,OB2BARHOSTNAME=128.0.30.227)';
allocate channel 'dev_3' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=sbiwill1,OB2BARLIST=LcalDB,OB2BARHOSTNAME=128.0.30.227)';
backup incremental level 0
format 'LcalDB<sbiwill1_%s:%t:%p>.dbf'
database;
backup
format 'LcalDB<sbiwill1_%s:%t:%p>.dbf'
current controlfile;
}




for e.g. first backup set is containing table A ( BACKUP1 )
second backup set is containing table A , B. ( BACKUP2 )
third backup set is containing table A,B,C. ( BACKUP3 )

for testing purpose, already we restored one tablespace (SYSTEM ) from tape (BACKUP1 ) and recovered the database,but

by that time, the tape was containing only one backup set.and we used below script to recover


SCRIPT:
------
run {
allocate channel 'dev_0' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=sbiwill1,OB2BARLIST=LcalDB,OB2BARHOSTNAME=128.0.30.227)';
restore tablespace 'SYSTEM';
release channel 'dev_0';
}


Now assume that our system tablespace is corrupted/dropped from o/s..and our database is in mount stage.
we need to restore system tablespace from backupset from TAPE.
Now we have 3 backup sets in the tape......we need to restore and recover database..which is containing the table A.

How to restore the system tablespace specifically from a patricular backup set from the TAPE ?

how to change the above script in order to do the above task ?

pls adv us.

thank you,
kesavan.
Re: How to restore backup from a patricular set directly from TAPE using RMAN [message #379408 is a reply to message #379389] Tue, 06 January 2009 06:23 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
RMAN will pick the correct backup to restore based on your UNTIL TIME setting:

set until time "to_date('06-Jan-2009 04:30:09','DD-Mon-YYYY HH24:MI:SS')";

Re: How to restore backup from a patricular set directly from TAPE using RMAN [message #379409 is a reply to message #379408] Tue, 06 January 2009 06:26 Go to previous messageGo to next message
kesavansundaram
Messages: 181
Registered: October 2007
Location: MUMBAI
Senior Member

sir,

thank you for your prompt reply.
we will check the same and confirm you.

kesavan sundaram.
Re: How to restore backup from a patricular set directly from TAPE using RMAN [message #379495 is a reply to message #379409] Tue, 06 January 2009 15:39 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If your SYSTEM tablespace is dropped you'll need to do more than just restore the SYSTEM tablespace.

In addition to what Frank mentioned, some other options are you can also restore based on SCN, SEQUENCE, RESTORE POINT, and FROM TAG.
Previous Topic: How to change the path for db_recovery_file_dest?
Next Topic: ORA-00368,00353,00312.
Goto Forum:
  


Current Time: Sat Dec 03 03:45:19 CST 2016

Total time taken to generate the page: 0.05855 seconds