NBU reconfiguration leads to unsuccessful recovery-link, NBU-Oracle of oracle and nbu

NBU reconfiguration leads to unsuccessful recovery-link, NBU-Oracle of oracle and nbu
[Root @ SsevendbS01 rman] # su-oracle [oracle @ SsevendbS01 ~] $ Rman target/
Recovery Manager: Release 11.2.0.3.0-Production on Fri Sep 19 09:47:47 2014
Copyright (c) 1982,201 1, Oracle and/or its affiliates. All rights reserved.
Connected to target database: sevendb (not mounted)
RMAN> restore controlfile from '/usr/openv/rman/control. sevendb ';
Starting restore at 19-SEP-14using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID = 461 device type = DISK
Channel ORA_DISK_1: copied control file copyoutput file name =/oradata/sevendb/control01.ctloutput file name =/oradata/sevendb/control02.ctlFinished restore at 19-SEP-14
RMAN> alter database mount;
Database mountedreleased channel: ORA_DISK_1
RMAN> list incarnation of database;

List of Database IncarnationsDB Key Inc Key DB Name db id status Reset SCN Reset Time ------- -------- ---------------- --- ---------- 1 sevendb 1917838411 PARENT 1 25-OCT-122 2 sevendb 1917838411 CURRENT 7906931 17-JAN-13
RMAN> run {2> set until time "to_date ('2014/1/2 18:30:00 ', 'Mm/DD/YYYY HH24: MI: ss ')"; 3> allocate channel c1 type sbt; 4> send 'nb _ ORA_CLIENT = descrivendbs01 '; 5> restore database; 6> recover database; 7> release channel c1; 8>}
Executing command: SET until clause
RMAN-00571: ========================================================== ============================== RMAN-00569: ================ error message stack follows ============================ RMAN-00571: ========================================================== ============================== RMAN-03009: failure of allocate command on c1 channel at 09/19/2014 09: 48: 27ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27211: Failed to load Media Management LibraryAdditional information: 2
RMAN>


[Oracle @ SsevendbS01 trace] $ cat sevendb_ora_13171.trcTrace file/oracle/app/oracle/diag/rdbms/sevendb/trace/explain Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsORACLE_HOME =/oracle/app/oracle/product/11.2.0/dbhome_1System name: LinuxNode name: SsevendbS01Release: 2.6.18-194. el5Version: #1 SMP Tue Mar 16 21:52:39 EDT 2010 Machine: x86_64Instance name: sevendbRedo thread mounted by this instance: 1 Oracle process number: 23 Unix process pid: 13171, image: oracle @ SsevendbS01 (TNS V1-V3)

* ** 10:04:04. 632 *** session id: (461.19) 10:04:04. 632 *** client id :() 10:04:04. 632 *** service name :() 10:04:04. 632 *** module name :( rman @ SsevendbS01 (TNS V1-V3) 10:04:04. 632 *** action name :( 0000001 STARTED1) 10:04:04. 632 skgfq osd: Error in function sbtinit on line 2734 skgfq osd: Look for SBT Trace messages in file/oracle/app/oracle/diag/rdbms/sevendb/trace/sbtio. logSBT Initialize failed for oracle. static [oracle @ SsevendbS01 trace] $ which sbttest/oracle/app/oracle/product/11.2.0/dbhome_1/bin/sbttest [oracle @ SsevendbS01 lib] $ sbttest/etc/hostsThe sbt function pointers are loaded from oracle. static library. libobk. so cocould not be loaded. check that it is installed
I checked a lot of information and found that the cause of the above results is that Oracle does not have a link with NBU, cd $ ORACLE_HOME/libln/usr/openv/netbackup/bin/libobk. then test SBTTEST again: [oracle @ SsevendbS01 lib] $ sbttest/etc/hostsThe sbt function pointers are loaded from libobk. so library. -- sbtinit succeeded -- sbtinit (2nd time) succeededsbtinit: Media manager supports sbt api version 2.0 sbtinit: Media manager is version 5.0.0.0sbtinit: vendor description string = Veritas NetBa Ckup for Oracle-Release 7.5 (2013061020) sbtinit: allocated sbt context area of 8 bytessbtinit: proxy copy is supported -- sbtinit2 succeeded -- regular_backup_restore starts .............................. .. OK. The configuration is successful.


[Oracle @ SsevendbS01 lib] $ ls-lrt/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libobk. so64 ls:/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libobk. so64: no such file or directory [oracle @ SsevendbS01 lib] $ [oracle @ SsevendbS01 lib] $ [oracle @ SsevendbS01 lib] $ pwd/oracle/app/oracle/product/11.2.0/dbhome_1/ lib [oracle @ SsevendbS01 lib] $ cp/usr/openv/netbackup/bin/libobk. so64 libobk. so64 [oracle @ SsevendbS01 lib] $ pwd/oracle/app/oracle/product/11.2.0/dbhome_1/lib [oracle @ SsevendbS01 lib] $ ls-lrt/oracle/app/oracle/ product/11.2.0/dbhome_1/lib/libobk. so64-r-xr-x 1 oracle oinstall 1511982 Sep 19/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libobk. so64 [oracle @ SsevendbS01 lib] $ [oracle @ SsevendbS01 lib] $ [oracle @ SsevendbS01 lib] $ rman target/
Recovery Manager: Release 11.2.0.3.0-Production on Fri Sep 19 10:04:01 2014
Copyright (c) 1982,201 1, Oracle and/or its affiliates. All rights reserved.
Connected to target database: sevendb (DBID = 1917838411, not open)
RMAN> run {2> set until time "to_date ('2014/1/2 18:30:00 ', 'Mm/DD/YYYY HH24: MI: ss ')"; 3> allocate channel c1 type sbt; 4> send 'nb _ ORA_CLIENT = descrivendbs01 '; 5> restore database; 6> recover database; 7> release channel c1; 8>}
Executing command: SET until clause
Using target database control file instead of recovery catalogRMAN-00571: ========================================================== ============================== RMAN-00569: ================ error message stack follows ============================ RMAN-00571: ========================================================== ============================== RMAN-03009: failure of allocate command on c1 channel at 09/19/2014 10: 04: 04ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27211: Failed to load Media Management LibraryAdditional information: 2
RMAN> exit

Recovery Manager complete.
[Oracle @ SsevendbS01 lib] $ mv libobk. so64 libobk. so you need to change libobk. so64 to libobk. so. [Oracle @ SsevendbS01 lib] $ rman target/
Recovery Manager: Release 11.2.0.3.0-Production on Fri Sep 19 10:04:26 2014
Copyright (c) 1982,201 1, Oracle and/or its affiliates. All rights reserved.
Connected to target database: sevendb (DBID = 1917838411, not open)
RMAN> run {2> set until time "to_date ('2014/1/2 18:30:00 ', 'Mm/DD/YYYY HH24: MI: ss ')"; 3> allocate channel c1 type sbt; 4> send 'nb _ ORA_CLIENT = descrivendbs01 '; 5> restore database; 6> recover database; 7> release channel c1; 8>}
Executing command: SET until clause
Using target database control file instead of recovery catalogallocated channel: c1channel c1: SID = 461 device type = SBT_TAPEchannel c1: Veritas NetBackup for Oracle-Release 7.5 (2013061020)
Sent command to channel: c1
Starting restore at 19-SEP-14
Channel c1: starting datafile backup set restorechannel c1: specifying datafile (s) to restore from backup setchannel c1: restoring datafile 00002 to/oradata/sevendb/sysaux01.dbfchannel c1: restoring datafile 00004 to/oradata/sevendb/users01.dbfchannel c1: restoring datafile 00005 to/oradata/sevendb/descric1: restoring datafile 00006 to/oradata/sevendb/descric1: restoring datafile 00009 to/oradata/sevendb/TS_ETL_IND_01.dbfchannel c1: reading from backup piece fetch c1: ORA-19870: error while restoring backup piece bk_4975_1_858258002ORA-19507: failed to retrieve sequential file, handle = "handle ", parms = "" ORA-27029: skgfrtrv: sbtrestore returned errorORA-19511: Error received from media manager layer, error text: Backup file <bk_4975_0000858258002> not found in the NetBackup catalog
Channel c1: starting datafile backup set restorechannel c1: specifying datafile (s) to restore from backup setchannel c1: restoring data file 00001 to/oradata/sevendb/system01.dbfchannel c1: restoring datafile 00003 to/oradata/sevendb/undotbs01.dbfchannel c1: restoring datafile 00007 to/oradata/sevendb/descric1: restoring datafile 00008 to/oradata/sevendb/descric1: reading from backup piece fetch c1: ORA-19870: error while restoring backup piece bk_4976_1_858258148ORA-19507: failed to retrieve sequential file, handle = "handle", parms = "" ORA-27029: skgfrtrv: sbtrestore returned errorORA-19511: error received ed from media manager layer, error text: Backup file <bk_4976_425858258148> not found in the NetBackup catalog
Failover to previous backup
Channel c1: starting datafile backup set restorechannel c1: specifying datafile (s) to restore from backup setchannel c1: restoring datafile 00002 to/oradata/sevendb/sysaux01.dbfchannel c1: restoring datafile 00004 to/oradata/sevendb/users01.dbfchannel c1: restoring datafile 00005 to/oradata/sevendb/descric1: restoring datafile 00006 to/oradata/sevendb/descric1: restoring datafile 00009 to/oradata/sevendb/TS_ETL_IND_01.dbfchannel c1: reading from backup piece fetch c1: ORA-19870: error while restoring backup piece bk_4894_1_857653202ORA-19507: failed to retrieve sequential file, handle = "handle ", parms = "" ORA-27029: skgfrtrv: sbtrestore returned errorORA-19511: Error received from media manager layer, error text: Backup file <bk_4894_0000857653202> not found in the NetBackup catalog
Channel c1: starting datafile backup set restorechannel c1: specifying datafile (s) to restore from backup setchannel c1: restoring data file 00001 to/oradata/sevendb/system01.dbfchannel c1: restoring datafile 00003 to/oradata/sevendb/undotbs01.dbfchannel c1: restoring datafile 00007 to/oradata/sevendb/descric1: restoring datafile 00008 to/oradata/sevendb/descric1: reading from backup piece bk_4895_2017857653337
The preceding error message indicates that the backup file cannot be found. Generally, this error is related to the media server of NBU. You can view the/etc/hosts and bp. if no problem is found in conf, locate the problem to NB_ORA_CLIENT = PsevendbS01 and check the NBU backup script. The client is PsevendbS instead of PsevendbS01. After the restoration script is changed, the recovery is successful.


How does nbu restore oracle using backup files?

1. Create a PFILE
2. Start to MOUNT with pfile to restore the control file
3. Restore data files based on control files
4. resetlog open the database
The general process is like this!
 
NBU75 can run oracle_link without stopping the database?

Yes. Run the script directly.