RMAN

8 Topics

Oracle redirected restore: bug from Netbackup version 8.3 still affecting version 10?
Hi folks. I'm not a Netbackup admin/engineer but a member of the database team trying to understand the issue. Platform and setup: Netbackup ver. 10 Oracle 19c, RAC with Dataguard. Netbackup-managed backup. Multiple databases in RAC Background: We are attempting a redirected restore via RMAN. The source client is the production RAC database, referred to in the RMAN command using the appropriate Netbackup host catalog name (NB_ORA_CLIENT=<DBNAME>_<DBID>). We are aware of the redirected restore procedure and are following it correctly, as far as we know. We would get errors in the restore where RMAN would abort with this message: ORA-19507: failed to retrieve sequential file, handle="bk_dBLAHPROD_u9g217066_s6448_p1_t1142128838", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: non RMAN, but media manager or vendor specific failure, error text: Failed to open backup file for restore. We've enabled debugging information in Netbackup and we saw these messages in the dbclient logs: 00:47:07.541 [765266] <4> sendRequest: sending buf = 1689256954 1689256954 /bk_dBLAHPROD_u9g217066_s6448_p1_t1142128838 00:47:07.541 [765266] <4> sendRequest: Date range: <-s 07/14/23 2:02:34>, <-e 07/14/23 02:02:34> 00:47:07.541 [765266] <4> serverResponse: entering serverResponse. 00:47:07.541 [765266] <4> serverResponse: initial client_read_timeout = <900> 00:47:07.541 [765266] <4> readCommMessages: Entering readCommMessages 00:47:09.541 [765266] <4> serverResponse: read comm file:<00:47:08 INF - Server status = 227> 00:47:09.541 [765266] <16> serverResponse: ERR - server exited with status 227: no entity was found 00:47:09.541 [765266] <16> RestoreFileObjects: ERR - serverResponse() failed 00:47:09.541 [765266] <4> closeApi: entering closeApi. 00:47:09.541 [765266] <4> closeApi: INF - EXIT STATUS 5: the restore failed to recover the requested files 00:47:09.541 [765266] <8> VxBSAGetObject: WRN - RestoreFileObject was not able to find the object. Status: 26 00:47:09.541 [765266] <2> xbsa_ProcessError: INF - entering 00:47:09.541 [765266] <2> xbsa_ProcessError: INF - leaving 00:47:09.541 [765266] <16> xbsa_GetObject: ERR - VxBSAGetObject: Failed with error: There is no copy of the requested object. 00:47:09.541 [765266] <2> xbsa_GetObject: INF - leaving (26) 00:47:09.541 [765266] <16> int_StartJob: ERR - Failed to open backup file for restore. 00:47:09.541 [765266] <2> int_StartJob: INF - leaving 00:47:09.541 [765266] <2> sbtrestore: INF - leaving 00:47:09.541 [765266] <2> sbterror: INF - entering 00:47:09.541 [765266] <2> sbterror: INF - Error=7501: Failed to open backup file for restore. . 00:47:09.541 [765266] <2> sbterror: INF – leaving In researching this, we came across this Veritas KB article (100049320)which describes the same situation that we are experiencing along with similar debug messages, but for a lower version (excerpt below): When attempting an Oracle RAC restore with NetBackup 8.3, the restore fails with an an error 227, stating that the image needed for the restore cannot be found. A bplist of the oracle images will show that the image is actually present. This can occur on RAC clusters that have more than one database. In verifying the conditions relating to this bug, we indeed see the required backup piece via bplist: -rw-rw---- oracle asmadmin 700448768 Jul 14 02:00 /bk_dBLAHPROD_u9g217066_s6448_p1_t1142128838 But, as mentioned in the KB document: NetBackup will look for all possible images needed for the restore across all possible RAC catalog names associated with the client.The failure occurs when the last catalog name does not have any backup images in the requested time range and an error is returned. If you notice in the bplist output above, the timestamp for the backup piece is 02:00, but the time range it's being searched from the Netbackup catalog when doing the restore attempt is (as shown in the debug log): 00:47:07.541 [765266] <4> sendRequest: sending buf = 1689256954 1689256954 /bk_dBLAHPROD_u9g217066_s6448_p1_t1142128838 00:47:07.541 [765266] <4> sendRequest: Date range: <-s 07/14/23 2:02:34>, <-e 07/14/23 02:02:34> ... which obviously would preclude the backup piece it is interested in. Questions: is it possible that we are hitting this bug despite being in a different version than what is mentioned in the KB article? I'm aware that the KB document mentions:This issue has been seen in all present versions - just wanted to confirm it as the KB article doesn't clearly indicate that the bug has been resolved in versions post 8.3. the KB article refers to resorting to an EEB to workaround this issue - do we have any other options? Thank you all in advance.
Solved
rme2023
10 months ago Place NetBackup
1.5KViews
0likes
4Comments
Oracle RMAN job starts another job (copied)
Hi, We have an Oracle job (Archive log, Full) set with an RMAN script which works fine and now we'd like to have another copy of this job in another storage. So I simply created a job from the original one and changed the storage destination to the new place. So, the Original job is : policy name: job1, RMAN script : mysc.sh, storage: site1_stg I create a copy : Second job : policy name : job2, RMAN script : mysc.sh, storage: site2_stg What happens is strange! When I run Job1, Job1 is also automatically launched and run. I looked into the script and there is nothing related to the job policy name which may cause this. I also used a different script (with the same content of course) but the result was the same. As this is not the case in other jobs I doubt the script or Oracle Linux OS or Netbackup settings on the OS should be the cause. Any help would be appreciated. Thanks
Solved
mhdganji
4 years ago Place NetBackup
3.2KViews
0likes
12Comments
Oracle Restore to Another Machine
Hi, I'm try to Restore Controlfile using RMAN , and give the error below : RMAN> run { 2> set controlfile autobackup format for device type 'sbt_tape' to '%F'; 3> allocate channel ch00 device type 'sbt_tape'; 4> send 'NB_ORA_SERV=bhpnbsrv, NB_ORA_CLIENT=psftdbsrv'; 5> restore controlfile from '/ctrl_dHRPROD_uq8ts0gds_s21320_p1_t1002455484 6> } executing command: SET CONTROLFILE AUTOBACKUP FORMAT allocated channel: ch00 channel ch00: SID=63 device type=SBT_TAPE channel ch00: Veritas NetBackup for Oracle - Release 7.6 (20131113) sent command to channel: ch00 Starting restore at 11-MAR-19 released channel: ch00 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 03/11/2019 17:03:40 ORA-27191: sbtinfo2 returned error Please any sugestion would be very helpful. Thanks, Adam
abiand
6 years ago Place NetBackup
1.9KViews
0likes
4Comments
Nebackup and Rac one node
We use netbackup version 8 to backup Oracle Rac Onde Node (include 3 nodes) version 12.2.0 Cluster database on linux, we have configured the netbackup policies to backup We use vip adress not scan adress. The database is relocated at the moment on node1. When we excute rman command netbackup we get failed on node2 and nod3 RUN { ALLOCATE CHANNEL A01 TYPE 'SBT_TAPE' PARMS 'ENV=(NB_ORA_CLIENT=nod1-vip.xx.se)' CONNECT 'yz/yz@PVIP1 as sysbackup'; ALLOCATE CHANNEL A02 TYPE 'SBT_TAPE' PARMS 'ENV=(NB_ORA_CLIENT=node1-vip.xx.se)' CONNECT 'yz/yz@PVIP1 as sysbackup'; ALLOCATE CHANNEL A03 TYPE 'SBT_TAPE' PARMS 'ENV=(NB_ORA_CLIENT=nod2-vip.xx.se)' CONNECT 'yz/yz@PVIP1 as sysbackup'; ALLOCATE CHANNEL A04 TYPE 'SBT_TAPE' PARMS 'ENV=(NB_ORA_CLIENT=nod2-vip.xx.se)' CONNECT 'yz/yz@PVIP1 as sysbackup'; ALLOCATE CHANNEL A05 TYPE 'SBT_TAPE' PARMS 'ENV=(NB_ORA_CLIENT=nod3-vip.xx.se)' CONNECT 'yz/yz@PVIP1 as sysbackup'; ALLOCATE CHANNEL A06 TYPE 'SBT_TAPE' PARMS 'ENV=(NB_ORA_CLIENT=nod3-vip.xx.se)' CONNECT 'yz/yz@PVIP1 as sysbackup'; SEND 'NB_ORA_SERV=netbackup-master1,NB_ORA_POLICY=hot_policy'; log -------- Recovery Manager: Release 12.2.0.1.0 - Production on Fri Feb 8 08:35:58 2019 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. RMAN> 2> RMAN> 2> connected to target database: test (DBID=9999999) RMAN> RMAN> connected to recovery catalog database RMAN> RMAN> RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> allocated channel: A01 channel A01: SID=1197 instance=test_2 device type=SBT_TAPE channel A01: Veritas NetBackup for Oracle - Release 8.0 (2016110921) allocated channel: A02 channel A02: SID=32 instance=test_2 device type=SBT_TAPE channel A02: Veritas NetBackup for Oracle - Release 8.0 (2016110921) allocated channel: A03 channel A03: SID=211 instance=test_2 device type=SBT_TAPE channel A03: Veritas NetBackup for Oracle - Release 8.0 (2016110921) allocated channel: A04 channel A04: SID=26 instance=test_2 device type=SBT_TAPE channel A04: Veritas NetBackup for Oracle - Release 8.0 (2016110921) allocated channel: A05 channel A05: SID=234 instance=test_2 device type=SBT_TAPE channel A05: Veritas NetBackup for Oracle - Release 8.0 (2016110921) allocated channel: A06 channel A06: SID=436 instance=test_2 device type=SBT_TAPE channel A06: Veritas NetBackup for Oracle - Release 8.0 (2016110921) sent command to channel: A01 sent command to channel: A02 sent command to channel: A03 sent command to channel: A04 sent command to channel: A05 sent command to channel: A06 sql statement: alter system archive log current Starting backup at 08-FEB-19 current log archived channel A01: starting archived log backup set channel A01: specifying archived log(s) in backup set input archived log thread=2 sequence=2125 RECID=2188 STAMP=999660213 .............................. channel A01: starting piece 1 at 08-FEB-19 RMAN-03009: failure of backup command on A04 channel at 02/08/2019 08:51:14 ORA-19506: failed to create sequential file, name="bk_113214_1_999678968", parms="" ORA-27028: skgfqcre: sbtbackup returned error ORA-19511: non RMAN, but media manager or vendor specific failure, error text: VxBSACreateObject: Failed with error: Server Status: Communication with the server has not been initiated or the server status has not been retrieved from the serve channel A04 disabled, job failed on it will be run on another channel channel A02: starting archived log backup set channel A02: specifying archived log(s) in backup set input archived log thread=2 sequence=2128 RECID=2191 STAMP=999673235 input archived log thread=2 sequence=2129 RECID=2192 STAMP=999677823 input archived log thread=2 sequence=2130 RECID=2193 STAMP=999678948 Please advise how we can resolve it. I've reviewed the documentation but still confused about how to prcoeed. Best Regards, Remi
remsma
6 years ago Place NetBackup
2.7KViews
0likes
8Comments
Oracle Backup: large files parallel backup into many tape drives
Hello, community. Is there any way to backup Oracle DB in parallel in many tape drives (balanced well and independent of datafile sizes)? The only one i found is script-based backupwithRMAN parameter SECTION SIZE included in script. Which is not as convenient as Oracle Intelligent Policies unfortunately.
terpigoryev
7 years ago Place NetBackup
975Views
0likes
2Comments
How can I do redirected RMAN restore to client with backup IP/hostname
Hello, In trying to do a redirected restore of an RMAN backup using NetBackup, I am getting the following error: 05/02/2017 11:32:47 - Error bpbrm (pid=14098) bpcd on fooz exited with status 48: client hostname could not be found 05/02/2017 11:32:48 - restored from image db-backup-source_1493623320; restore time: 0:00:08 05/02/2017 11:32:48 - Info tar (pid=0) done. status: 48: client hostname could not be found 05/02/2017 11:32:48 - Error bpbrm (pid=14098) client restore EXIT STATUS 48: client hostname could not be found 05/02/2017 11:32:52 - end Restore; elapsed time 0:00:15 Oracle policy restore error (2801) My guess is the the "hostname" in question is the destination client, which is known to Netbackup as: fooz-bkp (since we back it up using a backup network). Normally not an issue on a normal redirected restore, but I'm not sure how to specify the destination client within the RMAN commands, which are being run from fooz. This is a 7.6.0.4 NB env. restore source Client is linux, and restore destination is a linux media server . Thanks
Solved
zmlat
8 years ago Place NetBackup
4KViews
0likes
11Comments
Can we limit Oracle backup retries in Netbackup 7.7.3?
Hi, Good day! Just wondering if we can limit or forego with automatic oracle backup retries? As experienced, everytime an oracle backup encounters errors, as long as it is still within the backup window, it will continue to rerun the job. Netbackup version: 7.7.3 Master server OS: AIX 6.1 Oracle version: 11G Thanks in advance! - alain
Solved
alainken3
8 years ago Place NetBackup
1.6KViews
0likes
4Comments
RMAN Backup ERROR 239 after Server Migration
Dears, Kindly note we've migrated a database server zone to another host with the same storage, os, users, disk groups, ..., and installed the NB agent again on the server and when we run the RMAN backup we get the below error, in the attachment you can find dbclient log and bpcd RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on t4 channel at 03/30/2017 06:04:48 ORA-19506: failed to create sequential file, name="al_14614_1_939967482", parms="" ORA-27028: skgfqcre: sbtbackup returned error ORA-19511: non RMAN, but media manager or vendor specific failure, error text: VxBSACreateObject: Failed with error: Server Status: the specified client does not exist in the specified policy RMAN> Recovery Manager complete. Thu Mar 30 06:04:48 EET 2017 ----------------End of Script------------------
Solved
mohammad_yaseen
8 years ago Place NetBackup
1.8KViews
0likes
3Comments