[[email protected] rman]# su-oracle[[email protected] ~]$ Rman target/
Recovery manager:release 11.2.0.3.0-production on Fri Sep 19 09:47:47 2014
Copyright (c) 1982, 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_1ch Annel 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 1 sevendb 1917838411 PARENT 1 25-oct-122 2 sevendb 1917838411 Current 7906931 17-jan-13
Rman> run {2> set until Time "to_date (' 09/18/2014 18:30:00 ', ' mm/dd/yyyy HH24:MI:SS ')";3> allocate channel C1 t ype sbt;4> send ' nb_ora_client=psevendbs01 ';5> restore database;6> recover database;7> release channel c1;8& Gt }
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>
[email protected] trace]$ cat Sevendb_ora_13171.trctrace file/oracle/app/oracle/diag/rdbms/sevendb/sevendb/trace/ Sevendb_ora_13171.trcoracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit productionwith the partitioning, OL AP, 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 21:52:39 EDT 2010Machin E:x86_64instance Name:sevendbredo thread mounted by this instance:1oracle process Number:23unix process pid:13 171, Image: [email protected] (TNS v1-v3)
2014-09-19 10:04:04.632*** SESSION ID: (461.19) 2014-09-19 10:04:04.632*** CLIENT ID: () 2014-09-19 10:04:04.632*** SER VICE Name: () 2014-09-19 10:04:04.632*** MODULE name: ([email protected] (TNS v1-v3) 2014-09-19 10:04:04.632*** ACTION Name :(0000001 STARTED1) 2014-09-19 10:04:04.632 skgfq osd:error in function sbtinit on line 2734SKGFQ osd:look for SBT Trace Messages in FILE/ORACLE/APP/ORACLE/DIAG/RDBMS/SEVENDB/SEVENDB/TRACE/SBTIO.LOGSBT Initialize failed for oracle.static [email protected] trace]$ which Sbttest/oracle/app/oracle/product/11.2.0/dbhome_1/bin/sbttest[[email protected] Lib ]$ sbttest/etc/hoststhe SBT function pointers is loaded from oracle.static library.libobk.so could isn't be loaded. Check that it is installed
looked up a lot of information found:the reason for this result is that Oracle does not link with Nbu,CD $ORACLE _home/libln/usr/openv/netbackup/bin/libobk.sore-Test sbttest after operation:[email protected] lib]$ sbttest/etc/hostsThe SBT function pointers is loaded from the Libobk.so library.--Sbtinit succeeded--Sbtinit (2nd time) succeededSbtinit:media Manager supports SBT API version 2.0Sbtinit:media Manager is version 5.0.0.0Sbtinit:vendor Description String=veritas NetBackup 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.
[[email protected] 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[[email protected] lib]$ [[email protected] lib]$ [[EMA Il protected] lib]$ pwd/oracle/app/oracle/product/11.2.0/dbhome_1/lib[[email protected] lib]$ cp/usr/openv/netbackup /bin/libobk.so64 Libobk.so64[[email protected] lib]$ Pwd/oracle/app/oracle/product/11.2.0/dbhome_1/lib[[email Protected] lib]$ls-lrt/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libobk.so64-r-xr-xr-x 1 Oracle oinstall 1511982 SEP 10:03/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libobk.so64[Email protected] lib]$ [[email protected] lib]$ [[email protected] lib]$ Rman target/
Recovery manager:release 11.2.0.3.0-production on Fri Sep 19 10:04:01 2014
Copyright (c) 1982, 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 (' 09/18/2014 18:30:00 ', ' mm/dd/yyyy HH24:MI:SS ')";3> allocate channel C1 t ype sbt;4> send ' nb_ora_client=psevendbs01 ';5> restore database;6> recover database;7> release channel c1;8& Gt }
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.
[Email protected] lib]$MV Libobk.so64 libobk.soneed to belibobk.so64 changed to libobk.so. [[email protected] lib]$ Rman target/
Recovery manager:release 11.2.0.3.0-production on Fri Sep 19 10:04:26 2014
Copyright (c) 1982, 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 (' 09/18/2014 18:30:00 ', ' mm/dd/yyyy HH24:MI:SS ')";3> allocate channel C1 t ype sbt;4> send ' nb_ora_client=psevendbs01 ';5> restore database;6> recover database;7> release channel c1;8& Gt }
Executing command:set until clause
Using target database control file instead of recovery catalogallocated channel:c1channel c1:sid=461 device Type=sbt_tap Echannel 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:r estoring datafile 00002 to/oradata/sevendb/sysaux01.dbfchannel c1:restoring datafile 00004 to/oradata/sevendb/users01 . Dbfchannel c1:restoring datafile 00005 to/oradata/sevendb/tivoliorts01.dbfchannel c1:restoring datafile 00006 To/orad Ata/sevendb/ts_cim_data_01.dbfchannel c1:restoring datafile 00009 to/oradata/sevendb/ts_etl_ind_01.dbfchannel C1: Reading from backup piece Bk_4975_1_858258002channel c1:ora-19870:error while restoring backup piece bk_4975_1_858258002 ora-19507:failed to retrieve sequential file, handle= "bk_4975_1_858258002", parms= "" Ora-27029:skgfrtrv:sbtrestore Returned Errorora-19511:error received from Media Manager layer, Error text:backup file <bk_4975_1_858258002> No T found in NetBackup catalog
Channel c1:starting datafile backup set Restorechannel c1:specifying datafile (s) to restore from backup Setchannel c1:r estoring datafile 00001 to/oradata/sevendb/system01.dbfchannel c1:restoring datafile 00003 to/oradata/sevendb/ Undotbs01.dbfchannel c1:restoring datafile 00007 to/oradata/sevendb/ts_cim_ind_01.dbfchannel c1:restoring datafile 00008 To/oradata/sevendb/ts_etl_data_01.dbfchannel c1:reading from backup piece Bk_4976_1_858258148channel C1: Ora-19870:error while restoring backup piece bk_4976_1_858258148ora-19507:failed to retrieve sequential file, handle= "BK _4976_1_858258148 ", parms=" "Ora-27029:skgfrtrv:sbtrestore returned Errorora-19511:error received from Media manager la Yer, error text:backup file <bk_4976_1_858258148> not found in NetBackup catalog
Failover to previous backup
Channel c1:starting datafile backup set Restorechannel c1:specifying datafile (s) to restore from backup Setchannel c1:r estoring datafile 00002 to/oradata/sevendb/sysaux01.dbfchannel c1:restoring datafile 00004 to/oradata/sevendb/users01 . Dbfchannel c1:restoring datafile 00005 to/oradata/sevendb/tivoliorts01.dbfchannel c1:restoring datafile 00006 To/orad Ata/sevendb/ts_cim_data_01.dbfchannel c1:restoring datafile 00009 to/oradata/sevendb/ts_etl_ind_01.dbfchannel C1: Reading from backup piece Bk_4894_1_857653202channel c1:ora-19870:error while restoring backup piece bk_4894_1_857653202 ora-19507:failed to retrieve sequential file, handle= "bk_4894_1_857653202", parms= "" Ora-27029:skgfrtrv:sbtrestore Returned Errorora-19511:error received from Media Manager layer, Error text:backup file <bk_4894_1_857653202> No T found in NetBackup catalog
Channel c1:starting datafile backup set Restorechannel c1:specifying datafile (s) to restore from backup Setchannel c1:r estoring datafile 00001 to/oradata/sevendb/system01.dbfchannel c1:restoring datafile 00003 to/oradata/sevendb/ Undotbs01.dbfchannel c1:restoring datafile 00007 to/oradata/sevendb/ts_cim_ind_01.dbfchannel c1:restoring datafile 00008 To/oradata/sevendb/ts_etl_data_01.dbfchannel c1:reading from backup piece bk_4895_1_857653337
to report the error to find a backup slice, usually these errors are related to NBU Media server, by looking at/etc/hosts and bp.conf found no problem, eventually the problem to the NB_ORA_CLIENT=PSEVENDBS01, Review the NBU backup script, where client is Psevendbs instead of PsevendbS01, and after the recovery script is changed, the recovery is successful.
Nbu reconfiguration leads to recovery unsuccessful--oracle and NBU link
