OraFAQ Forum: Backup & Recovery » How to recover the fullbackup sets and incremental bkp sets ?

Home » RDBMS Server » Backup & Recovery » How to recover the fullbackup sets and incremental bkp sets ? (oracle - 9.2.0.8.0 o/s: HP-UX:11.23)

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

How to recover the fullbackup sets and incremental bkp sets ? [message #376933]

Fri, 19 December 2008 03:52

kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI

Senior Member

Dear sir,

We are taking full backup and incremental level bkp thro RMAN using below script
now we need to test the recovery part.....

script1:(full backup)
----------------------
RMAN> CONNECT TARGET *
2> run {
3> allocate channel 'dev_0' type 'sbt_tape'
4> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=SBIWILL1,OB2BARLIST=SBIWILL1_THU_Incr1,OB2BARHOSTNAME=cmpdb1)';
5> allocate channel 'dev_1' type 'sbt_tape'
6> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=SBIWILL1,OB2BARLIST=SBIWILL1_THU_Incr1,OB2BARHOSTNAME=cmpdb1)';
7> allocate channel 'dev_2' type 'sbt_tape'
8> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=SBIWILL1,OB2BARLIST=SBIWILL1_THU_Incr1,OB2BARHOSTNAME=cmpdb1)';
9> allocate channel 'dev_3' type 'sbt_tape'
10> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=SBIWILL1,OB2BARLIST=SBIWILL1_THU_Incr1,OB2BARHOSTNAME=cmpdb1)';
11> backup incremental level 0
12> format 'SBIWILL1_THU_Incr1<SBIWILL1_%s:%t:%p>.dbf'
13> database;
14> backup
15> format 'SBIWILL1_THU_Incr1<SBIWILL1_%s:%t:%p>.dbf'
16> current controlfile;
17> }
18> EXIT

script2( for incremental level 1 )
----------------------------------

RMAN> CONNECT TARGET *
2> run {
3> allocate channel 'dev_0' type 'sbt_tape'
4> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=SBIWILL1,OB2BARLIST=SBIWILL1_THU_Incr1,OB2BARHOSTNAME=cmpdb1)';
5> allocate channel 'dev_1' type 'sbt_tape'
6> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=SBIWILL1,OB2BARLIST=SBIWILL1_THU_Incr1,OB2BARHOSTNAME=cmpdb1)';
7> allocate channel 'dev_2' type 'sbt_tape'
8> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=SBIWILL1,OB2BARLIST=SBIWILL1_THU_Incr1,OB2BARHOSTNAME=cmpdb1)';
9> allocate channel 'dev_3' type 'sbt_tape'
10> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=SBIWILL1,OB2BARLIST=SBIWILL1_THU_Incr1,OB2BARHOSTNAME=cmpdb1)';
11> backup incremental level 1
12> format 'SBIWILL1_THU_Incr1<SBIWILL1_%s:%t:%p>.dbf'
13> database;
14> backup
15> format 'SBIWILL1_THU_Incr1<SBIWILL1_%s:%t:%p>.dbf'
16> current controlfile;
17> }
18> EXIT

Now we need to test the recovery, i.e. we need to recover both this full bkp and incr.bkp.
how to recover ?

shall we write this below script ?

RMAN> STARTUP MOUNT;
RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE;
RMAN> ALTER DATABASE OPEN;

and adv us how to recover this incremental backup ..

thank you,
kesavan.

Report message to a moderator

Re: How to recover the fullbackup sets and incremental bkp sets ? [message #377242 is a reply to message #376933]

Mon, 22 December 2008 01:47

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

You don't need to do anything special. RMAN keeps track of all the backups (full and incremental) and will know what to restore. Just code your RESTORE and RECOVER statements as you would normally do.

Report message to a moderator

Re: How to recover the fullbackup sets and incremental bkp sets ? [message #377282 is a reply to message #377242]

Mon, 22 December 2008 04:01

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

I thinkg kesavansundaram meant that "How do I know about exactly what incremental level when I run restore/recovery command?"

Report message to a moderator

Re: How to recover the fullbackup sets and incremental bkp sets ? [message #377285 is a reply to message #377282]

Mon, 22 December 2008 04:09

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

No! His question was "how to recover?". Please re-read his original post. If that is what he meant, he can tell us himself.

Report message to a moderator

Previous Topic:	Disaster recovery test
Next Topic:	recovery from oraclexe directory

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 29 23:44:59 CDT 2024