Restore backup from Netbackup using RMAN
819348Dec 21 2011 — edited Dec 21 2011Hi experts. please, I need help.
My company boutht the tool Netbackup. I can't restore the backup after backup.
I started the instance with startup force option, after that I want to restore the spfile.
My spfile is on BKP_RMAN_MENSAL0_DBNETB_20_12_2011_46_1_770375741 backupset. This backupset is AVAILABLE status after crosscheck backup, but, I can't restore the spfile,
My strategy is:
Backup from ASM to TAPE is very slow, because this, I backup the database from ASM to Netbackup Staging Area (group of disks , is faster than TAPE). After that, the TAPE process take the backup from Netbackup Staging Area and write on TAPES.
RMAN> list backup of spfile;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
2140446 Full 256.00K SBT_TAPE 00:00:46 20/12/2011 09:16:27
BP Key: 2140452 Status: AVAILABLE Compressed: YES Tag: TAG20111220T091349
Handle: BKP_RMAN_MENSAL0_DBNETB_20_12_2011_46_1_770375741 Media: F:\RMAN-2-semanas\srv15075_1324379731_C1_F1
Keep: BACKUP_LOGS Until: 19/12/2012 09:15:40
SPFILE Included: Modification time: 14/12/2011 14:53:11
SPFILE db_unique_name: DBNETB
RMAN> list backupset 2140446;
Hi experts. please, I need help.
My company boutht the tool Netbackup. I can't restore the backup after backup.
I started the instance with startup force option, after that I want to restore the spfile.
My spfile is on BKP_RMAN_MENSAL0_DBNETB_20_12_2011_46_1_770375741 backupset. This backupset is AVAILABLE status after crosscheck backup, but, I can't restore the spfile,
My strategy is:
Backup from ASM to TAPE is very slow, because this, I backup the database from ASM to Netbackup Staging Area (group of disks , is faster than TAPE). After that, the TAPE process take the backup from Netbackup Staging Area and write on TAPES.
RMAN> list backup of spfile;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
2140446 Full 256.00K SBT_TAPE 00:00:46 20/12/2011 09:16:27
BP Key: 2140452 Status: AVAILABLE Compressed: YES Tag: TAG20111220T091349
Handle: BKP_RMAN_MENSAL0_DBNETB_20_12_2011_46_1_770375741 Media: F:\RMAN-2-semanas\srv15075_1324379731_C1_F1
Keep: BACKUP_LOGS Until: 19/12/2012 09:15:40
SPFILE Included: Modification time: 14/12/2011 14:53:11
SPFILE db_unique_name: DBNETB
RMAN> list backupset 2140446;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
2140446 Full 256.00K SBT_TAPE 00:00:46 20/12/2011 09:16:27
BP Key: 2140452 Status: AVAILABLE Compressed: YES Tag: TAG20111220T091349
Handle: BKP_RMAN_MENSAL0_DBNETB_20_12_2011_46_1_770375741 Media: F:\RMAN-2-semanas\srv15075_1324379731_C1_F1
Keep: BACKUP_LOGS Until: 19/12/2012 09:15:40
SPFILE Included: Modification time: 14/12/2011 14:53:11
RMAN> run
{
allocate channel t1 type 'SBT_TAPE' send 'NB_ORA_POLICY=DB-H-Oracle-Test_Staging, NB_ORA_SERV=bkpserver01';
restore spfile from 'BKP_RMAN_LEVEL0_DBNETB_20_12_2011_43_1_770375395';
release channel t1;
}
2> 3> 4> 5> 6>
allocated channel: t1
channel t1: SID=48 device type=SBT_TAPE
channel t1: Veritas NetBackup for Oracle - Release 7.0 (2010070801)
Starting restore at 21/12/2011 08:41:39
channel t1: restoring spfile from AUTOBACKUP BKP_RMAN_LEVEL0_DBNETB_20_12_2011_43_1_770375395
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/21/2011 08:42:06
ORA-19870: error while restoring backup piece BKP_RMAN_LEVEL0_DBNETB_20_12_2011_43_1_770375395
ORA-19507: failed to retrieve sequential file, handle="BKP_RMAN_LEVEL0_DBNETB_20_12_2011_43_1_770375395", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Failed to open backup file for restore.