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)
How to recover the fullbackup sets and incremental bkp sets ? [message #376933] Fri, 19 December 2008 03:52 Go to next message
kesavansundaram
Messages: 181
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.
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 Go to previous messageGo to next message
Frank Naude
Messages: 4502
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.
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 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
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?"

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 Go to previous message
Frank Naude
Messages: 4502
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.
Previous Topic: Disaster recovery test
Next Topic: recovery from oraclexe directory
Goto Forum:
  


Current Time: Sat Dec 10 18:47:49 CST 2016

Total time taken to generate the page: 0.04485 seconds