OraFAQ Forum: Backup & Recovery » How to restore backup from a patricular set directly from TAPE using RMAN

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 )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to restore backup from a patricular set directly from TAPE using RMAN [message #379389]

Tue, 06 January 2009 05:26

kesavansundaram
Messages: 183
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.

Report message to a moderator

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

Frank Naude
Messages: 4579
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')";

Report message to a moderator

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

kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI

Senior Member

sir,

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

kesavan sundaram.

Report message to a moderator

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

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.

Report message to a moderator

Previous Topic:	How to change the path for db_recovery_file_dest?
Next Topic:	ORA-00368,00353,00312.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 03 07:51:59 CDT 2024