RMAN Restore (Netbackup)

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F';
configuration for SBT_TAPE channel 2 is ignored
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';
CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' CONNECT '*';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SNCFHOME2.ORA'; # default


RMAN> SQL 'alter tablespace testt_netbkup offline';

RMAN> RUN{
2> ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
3> SEND 'NB_ORA_CLIENT=HOME-03-DB11, NB_ORA_SERV=p-hq-sp-mg-20';
4> restore tablespace testt_netbkup;
5> recover tablespace testt_netbkup;
6> RELEASE CHANNEL ch00;
7> }

using target database control file instead of recovery catalog
allocated channel: ch00
channel ch00: sid=1924 instance=home2 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.0 (20100707)

sent command to channel: ch00

Starting restore at 12-MAR-11

channel ch00: starting datafile backupset restore
channel ch00: specifying datafile(s) to restore from backup set
restoring datafile 00018 to +ORADATA/home/datafile/test_netbkup.dbf
channel ch00: reading from backup piece kvm71stv_1_1
channel ch00: restored backup piece 1
piece handle=kvm71stv_1_1 tag=TAG20110312T150535
channel ch00: restore complete, elapsed time: 00:14:36
Finished restore at 12-MAR-11

Starting recover at 12-MAR-11

starting media recovery
media recovery complete, elapsed time: 00:00:05

Finished recover at 12-MAR-11

released channel: ch00

RMAN>

RMAN> SQL 'alter tablespace testt_netbkup online';

sql statement: alter tablespace testt_netbkup online

RMAN> exit


Recovery Manager complete.

C:\Documents and Settings\inam>