Hi,
I have setup netbackup server to do RMAN Backup. I can trigger Backup From netbackup Tool without any issue, however i cant do restore. it will always prompt error.
Netbackup Server = Windows2008 R2 PC1
Media Server tight to Windows2008 R2 PC1
Netbackup client = ODA Linux6 Oak1 and Oak2
Bakcup script.
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
SEND 'NB_ORA_SERV=PC1.health.local,NB_ORA_CLIENT=Oak1.health.local,NB_ORA_POLICY=bdev2';
BACKUP
INCREMENTAL LEVEL=0
SKIP INACCESSIBLE
TAG hot_db_bk_inc_lvl0
FILESPERSET 5
# recommended format, must end with %t
FORMAT 'bk_%s_%p_%t'
DATABASE;
sql 'alter system archive log current';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
Restore Script
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
SEND 'NB_ORA_SERV=PC1.health.local,NB_ORA_CLIENT=Oak1.health.local';
RESTORE
DATABASE;
# There is no need to manually catalog any archivelogs before the recovery,
# as Recovery Manager does an implicit catalog resync from the current
# control file.
RECOVER
DATABASE;
sql 'alter database open resetlogs';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
}
Error
---------
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15>
allocated channel: ch00
channel ch00: SID=14 device type=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.7.3 (2016051915)
allocated channel: ch01
channel ch01: SID=169 device type=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 7.7.3 (2016051915)
sent command to channel: ch00
sent command to channel: ch01
Starting restore at 14-JUL-16
channel ch00: starting datafile backup set restore
channel ch00: specifying datafile(s) to restore from backup set
channel ch00: restoring datafile 00025 to /u02/app/oracle/oradata/datastore/.ACFS/snaps/BDEV/BDEV/datafile/o1_mf_tbl_stg__co9rtygy_.dbf
channel ch00: restoring datafile 00036 to /u02/app/oracle/oradata/datastore/.ACFS/snaps/BDEV/BDEV/datafile/o1_mf_tbl_stg__co9rv5q7_.dbf
channel ch00: restoring datafile 00038 to /u02/app/oracle/oradata/datastore/.ACFS/snaps/BDEV/BDEV/datafile/o1_mf_tbl_stg__co9rv71d_.dbf
channel ch00: restoring datafile 00039 to /u02/app/oracle/oradata/datastore/.ACFS/snaps/BDEV/BDEV/datafile/o1_mf_index_bi_co9rv7mc_.dbf
channel ch00: reading from backup piece bk_452_1_917192751
channel ch01: starting datafile backup set restore
channel ch01: specifying datafile(s) to restore from backup set
channel ch01: restoring datafile 00031 to /u02/app/oracle/oradata/datastore/.ACFS/snaps/BDEV/BDEV/datafile/o1_mf_tbl_dwh__co9rv2dy_.dbf
channel ch01: restoring datafile 00032 to /u02/app/oracle/oradata/datastore/.ACFS/snaps/BDEV/BDEV/datafile/o1_mf_tbl_dwh__co9rv33l_.dbf
channel ch01: restoring datafile 00033 to /u02/app/oracle/oradata/datastore/.ACFS/snaps/BDEV/BDEV/datafile/o1_mf_tbl_dwh__co9rv3qd_.dbf
channel ch01: restoring datafile 00034 to /u02/app/oracle/oradata/datastore/.ACFS/snaps/BDEV/BDEV/datafile/o1_mf_tbl_ods__co9rv4cc_.dbf
channel ch01: restoring datafile 00035 to /u02/app/oracle/oradata/datastore/.ACFS/snaps/BDEV/BDEV/datafile/o1_mf_tbl_ods__co9rv51w_.dbf
channel ch01: reading from backup piece bk_453_1_917192752
released channel: ch00
released channel: ch01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/14/2016 15:55:59
ORA-19870: error while restoring backup piece bk_452_1_917192751
ORA-19573: cannot obtain exclusive enqueue for datafile 25
Anyone can advice?
Thanks
Yip