Restoration of L0 and L1 backup

Hi Experts,

Goal:

Restoring/Testing L0 and L1 backup to a new server

ENV:

Source 2 node RAC

Destination single node

We have restored the L0 backup taken on 24NOV and we have done point in time recovery and opened the database with resetlogs. Now admin want to test the incremental level 1 backup taken on 25th NOV.

Using Data protector,admin restored the datafiles from 24th NOV. He didnt use any until scn/time. After restoration is done,we have set until scn and recovered the database and opened with resetlogs.

Command used in restore in Data Protector tool:

RMAN> CONNECT TARGET *
2> HOST 'exit';
3> run {
4> allocate channel 'dev_0' type 'sbt_tape'
5> parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so';
6>
7> send channel 'dev_0' 'OB2BARTYPE=Oracle8';
8> send channel 'dev_0' 'OB2APPNAME=prodcdb2';
9> send channel 'dev_0' 'OB2BARLIST=1700996098';
10> send channel 'dev_0' 'OB2BARHOSTNAME=erpprod-scan.ttd.com';
11> restore database;
12> recover database;
13> release channel 'dev_0';
14> }

Recovery failed as expected,because they didnt set until scn/sequence.

We then did manual recovery using:

run{
allocate channel 'dev_0' type 'sbt_tape' parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so';
send device type 'sbt_tape' 'OB2BARHOSTNAME=erpprod-scan.ttd.com';
send channel 'dev_0' 'OB2BARTYPE=Oracle8';
send channel 'dev_0' 'OB2APPNAME=prodcdb2';
send channel 'dev_0' 'OB2BARLIST=ERP_PROD_19C';
set until scn 6008627441946;
recover database;
}
alter database open resetlogs->Done.