Netbackup Questions for level 1 and level 2
Hi All, Kindly share the netbackup administrator interview questions for L1 and L2 engineer. If any one have link kindly share. Netbackup 6.5 and 7.0 And also, share the all documetns link for netbackup7.0 Thanks and Regds, SagarSolved22KViews3likes7CommentsORACLE RMAN BACKUP Configuration
Hi I am trying to configure RMAN backup. Followed below mentioned steps: 1. Created Backup policy on master server for RMAN backup--- Shell script path is mentioned in Backup selection. And selected traget unit as LTO3 tape drive. 2. Shell script is prepared on client for RMAN backup But still I am getting Error (6). Sharing the script fyi: ORACLE_HOME=/oracle/product/10.2.0/db_1 PATH=$ORACLE_HOME/bin:$PATH ORACLE_SID=crm export ORACLE_HOME PATH ORACLE_SID rman << EOF connect target sys/sys run { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'; configure controlfile autobackup on; configure controlfile autobackup format for device type 'SBT_TAPE' ; backup database plus archivelog; BACKUP CURRENT CONTROLFILE ; release channel ch00; } EOF The problem here is this script run with oracle login perfectly and failed when trying to tun through backup policy. Also sharing logs i found in /usr/openv/netbackup/logs/bphdb cat obk_stdout.090610 Recovery Manager: Release 10.2.0.4.0 - Production on Mon Sep 6 14:31:07 2010 Copyright (c) 1982, 2007, Oracle. All rights reserved. RMAN> RMAN> RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== ORA-01031: insufficient privileges RMAN> 2> 3> 4> 5> RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found ";": expecting one of: "clear, to" RMAN-01007: at line 5 column 68 file: standard input RMAN> Starting backup at 06-SEP-10 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of backup plus archivelog command at 09/06/2010 14:31:08 RMAN-06171: not connected to target database RMAN> Starting backup at 06-SEP-10 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of backup command at 09/06/2010 14:31:08 RMAN-03014: implicit resync of recovery catalog failed RMAN-06171: not connected to target database RMAN> RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found "identifier": expecting one of: ";" RMAN-01008: the bad identifier was: ch00 RMAN-01007: at line 1 column 17 file: standard input RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate" RMAN-01007: at line 1 column 21 file: standard input RMAN> RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found "}": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate" RMAN-01007: at line 1 column 1 file: standard input RMAN> RMAN> Recovery Manager complete. and cat log.090610 14:31:07.247 [22299] <2> logparams: -sb -rdbms oracle -S backupmaster -to 1500 -c ORACLE-RMAN -s Full -clnt backupmedia01 -FULL -kl 28 -b backupmedia01_1283763604 -jobid 21671 14:31:07.251 [22299] <4> bphdb main: INF - setenv NB_ORA_POLICY=ORACLE-RMAN 14:31:07.251 [22299] <4> bphdb main: INF - setenv NB_ORA_CLIENT=backupmedia01 14:31:07.251 [22299] <4> bphdb main: INF - setenv NB_ORA_MODE=B 14:31:07.251 [22299] <4> bphdb main: INF - NB_ORA_POLICY=ORACLE-RMAN 14:31:07.251 [22299] <4> bphdb main: INF - NB_ORA_SCHED not defined. 14:31:07.251 [22299] <4> bphdb main: INF - NB_ORA_PC_SCHED=Full 14:31:07.251 [22299] <4> bphdb main: INF - NB_ORA_SERV=backupmaster 14:31:07.251 [22299] <4> bphdb main: INF - NB_ORA_PC_BTYPE not set 14:31:07.251 [22299] <4> bphdb main: INF - setenv NB_ORA_FULL=1 14:31:07.251 [22299] <4> bphdb main: INF - setenv NB_ORA_INCR=0 14:31:07.251 [22299] <4> bphdb main: INF - setenv NB_ORA_CINC=0 14:31:07.251 [22299] <4> bphdb main: INF - setenv NB_ORA_SCHEDULED=1 14:31:07.252 [22299] <4> bphdb sync_server: INF - BACKUP START 14:31:07.319 [22299] <4> bphdb sync_server: INF - CONTINUE BACKUP message received. 14:31:07.319 [22299] <2> bphdb get_filelist: INF - Read filename: </oracle/script/FULLBKP-CRM.sh> 14:31:07.319 [22299] <2> bphdb get_filelist: INF - Read filename: <CONTINUE> 14:31:07.319 [22299] <4> bphdb do_backup: INF - Processing /oracle/script/FULLBKP-CRM.sh 14:31:07.322 [22299] <4> bphdb keepalive_timeout: INF - bphdb still working. 14:31:07.322 [22299] <2> bphdb keepalive_timeout: INF - bphdb- Sending a keepalive. 14:31:07.323 [22299] <4> bphdb do_backup: INF - Keepalives will be sent every 750 seconds. 14:31:07.323 [22299] <4> bphdb do_backup: INF - Waiting for the child status. 14:31:07.325 [22301] <4> bphdb do_backup: INF - Child executing /oracle/script/FULLBKP-CRM.sh 14:31:08.753 [22299] <16> bphdb do_backup: ERR - Script exited with status = 1 <the requested operation was partially successful> 14:31:08.765 [22299] <16> bphdb Exit: ERR - bphdb exit status = 6: the backup failed to back up the requested files 14:31:08.765 [22299] <4> bphdb Exit: INF - EXIT STATUS 6: the backup failed to back up the requested files Pls post your valuable input. Thanks & Regards,Solved11KViews1like15CommentsNetbackup does not clean expired images
Hello everyone. We have Netbackup7.0 installed on Redhat 5.5. For this moment we are only using NB to perform Oracle database backups. The everyday backup works good but we have problem with removing expired images. I have retention set to 1 week but I have images older than 2 week. At first the image cleanup did not start itself than I tried thishttp://www.symantec.com/business/support/index?page=content&id=TECH125429and now I can see cleanup job running automatically in activity monitor, but it doesn't delete the expired ones I guess for some reasons cleanup job thinks it's not expired. 02/10/2012 15:50:36 - Info bpdbm (pid=4078) image catalog cleanup 02/10/2012 15:50:36 - Info bpdbm (pid=4078) Cleaning up tables in the relational database 02/10/2012 15:50:36 - Info bpdbm (pid=4078) deleting images which expire before Fri Feb 10 15:50:36 2012 (1328874636) 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test1 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test2 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test3 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test4 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test5 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test6 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test7 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test8 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test9 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test10 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test11 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test12 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test13 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test14 02/10/2012 15:50:36 - Info bpdbm (pid=4078) deleted 0 expired records, compressed 0, tir removed 0, deleted 0 expired copies the requested operation was successfully completed (0) This particular log created when I manually initiate image cleanup job (/usr/openv/netbackup/bin/admincmd/bpimage -cleanup -allclients) I just did it and I have 8 days of backup for now. Can someone tell me how can I see the list of backups that netbackup considers that It's expired ? Thanks for you'r time P.s I will provide additional information IfnecessarySolved8.9KViews1like11CommentsRman - bphdb exit status = 29: failed trying to exec a command
Hello, i have a problem with Oracle Rman (Oracle 11G R2) backup with Netbackup 7.1.0.3. I created a template with the wizard (Backup , archive, restore) on the client. When i launch a Manual Backup from my master server i have this : 20/09/2012 17:13:38 - Info nbjm(pid=9652) started backup job for client ora11g-rman.*****.com, policy Oracle, schedule SCH_FULL on storage unit ****** 20/09/2012 17:13:41 - started process bpbrm (4948) 20/09/2012 17:13:54 - Info bpbrm(pid=4948)ora11g-rman.*****.comis the host to backup data from 20/09/2012 17:13:54 - Info bpbrm(pid=4948) reading file list from client 20/09/2012 17:13:54 - connecting 20/09/2012 17:13:57 - connected; connect time: 00:00:03 20/09/2012 17:13:58 - Info bpbrm(pid=4948) starting bphdb on client 20/09/2012 17:13:59 - Info bphdb(pid=1580) Backup started 20/09/2012 17:13:59 - Info bphdb(pid=1580) Database validation buffer = :DBNAME:ORACLE:DBHOME:d:\oracle\product\11.2.0\dbhome_1:DBNETNAME:oracle 20/09/2012 17:13:59 - Info bphdb(pid=1580) DBNAME=ORACLE DBHOME=d:\oracle\product\11.2.0\dbhome_1 DBNETNAME=oracle DBTEMPLATENAME=fullbackuptest1.tpl 20/09/2012 17:15:34 - Error bpbrm(pid=4948) from clientora11g-rman.*****.com: ERR - failed executing command <"C:\Program Files\Veritas\NetBackup\bin\bpdbsbora.exe" -backup -rw -t "fullbackuptest1.tpl"> 20/09/2012 17:15:34 - Error bpbrm(pid=4948) from clientora11g-rman.*****.com: ERR - exit status: <1> 20/09/2012 17:15:34 - Error bpbrm(pid=4948) from clientora11g-rman.*****.com: ERR - bphdb exit status = 29: failed trying to exec a command 20/09/2012 17:15:36 - end writing failed trying to exec a command(29) This is my scriptfullbackuptest1.tpl : #^oracle template configuration file <<MUST BE FIRST IN FILE, DO NOT REMOVE>> # ----------------------------------------------------------------- # Veritas NetBackup for oracle: Backup Configuration Template # $VRTScprght: Copyright 1993 - 2011 Symantec Corporation, All Rights Reserved $ # # Description: test # Template level: 1.9.0 # Generated on: 09/19/12 15:29:07 # ----------------------------------------------------------------- TEMPLATE_ID1=16973 TEMPLATE_ID2=1605 TEMPLATE_OWNER=aasif # ----------------------------------------------------------------- # BACKUP_TYPE is derived from the schedule type when this script # is used in a NetBackup scheduled backup. For example, when: # schedule type is BACKUP_TYPE is # ---------------- -------------- # Automatic Full INCREMENTAL LEVEL=0 # Automatic Differential Incremental INCREMENTAL LEVEL=1 # Automatic Cumulative Incremental INCREMENTAL LEVEL=1 CUMULATIVE # # For a non-proxy user initiated backup, BACKUP_TYPE is defined as shown. # ----------------------------------------------------------------- BACKUP_TYPE=INCREMENTAL LEVEL=0 ORACLE_HOME=d:\oracle\product\11.2.0\dbhome_1 ORACLE_SID=ORACLE TARGETDB_LOGIN=SYS as sysdba TARGETDB_PASSWD=000a333eb56d86*****************64cadc37449028c9f61234a28b91592ab35b42155e3e40a********ed3366874ab TARGETDB_TNSNAME=oracle CATALOG_LOGIN=rman CATALOG_PASSWD=3d151364860bd4d8dfe741035b33****************2e48969a32ce1f1e142e11176fec5*********09e82d09159 CATALOG_TNSNAME=oracle # ----------------------------------------------------------------- # RMAN command section # ----------------------------------------------------------------- RUN { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'; SEND 'NB_ORA_CLIENT=ora11g-rman.*****.com,NB_ORA_SID=ORACLE,NB_ORA_POLICY=Oracle,NB_ORA_SERV=mymasterserver.*****.com,NB_ORA_SCHED=Oracle'; BACKUP INCREMENTAL LEVEL=0 FORMAT 'BACKUP_%T-%s-%U' DATABASE; RELEASE CHANNEL ch00; } Mybphdb log is attached on this topic Please can you help me? Thank you7.4KViews0likes13CommentsCan't restore from RMAN backup
Hi Everyone! I can't restore from my RMAN backups. RMAN> run 2> { 3> host "date"; 4> allocate channel t1 DEVICE TYPE 'SBT_TAPE' PARMS="ENV=(NB_ORA_CLIENT=vs-oa00-01b.hosting.local,NB_ORA_POLICY=Oracle_Prod_Policy,NB_ORA_SERV=ps-bcp00-01a.hosting.local,NB_ORA_SCHED=Default-Application-Backup)"; 5> restore controlfile to '/u01/app/control01.ctl' from tag 'TAG20120926T053022'; 6> release channel t1 ; host "date"; 7> 8> } Wed Sep 26 17:32:27 MSK 2012 host command complete allocated channel: t1 channel t1: SID=551 instance=skdbse2 device type=SBT_TAPE channel t1: Veritas NetBackup for Oracle - Release 7.5 (2012020807) Starting restore at 26-SEP-12 channel t1: starting datafile backup set restore channel t1: restoring control file output file name=/u01/app/control01.ctl channel t1: reading from backup piece c-1341750022-20120926-02 channel t1: ORA-19870: error while restoring backup piece c-1341750022-20120926-02 ORA-19507: failed to retrieve sequential file, handle="c-1341750022-20120926-02", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text: Backup file <c-1341750022-20120926-02> not found in NetBackup catalog failover to previous backup released channel: t1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 09/26/2012 17:32:41 RMAN-06026: some targets not found - aborting restore RMAN-06024: no backup or copy of the control file found to restore RMAN>Solved6.9KViews1like7Commentsbplist shows control file backup but rman "restore controlfile" fails with file not found
OK, I am trying to restore an Oracle database froma TOTALLY complicated setup and really need some help. Overview: My production Oracle database server is actually a pair of Solaris servers running Symantec HA with one node active and one node in standby. My backups are scheduled through NetBackup which calls an OracleRMAN script to backup the databases. Full database backups are generated every night and archive log backups are run at noon and 6:00 PM. Backups go to a pair of DataDomain devices, one in my primary datacenter and one at my disaster recovery site. At my disaster recovery site, I have a single Solaris server as a database server. Finally, I have an Oracle RMAN catalog that runs on a Windows server. This catalog is shut down twice a day and a Windows backup of just the RMAN directory is made, again to the DataDomain devices. Now, I am testing my disaster recovery. We have stopped the replication between the local and remote DataDomain devices. I connect to the Unix server at the DR site and am attempting to recover the databases from backup. We have added entries to the hosts files and created a No.Restrictions file so that the server at the DR site has access to the NetBackup backups. When I run "bplist -C st31bora01 -t 4 -l -R /" at the DR database server, I see several backup files including the catalog backup I want (database files removed from the list for brevity). /u01/app/oraprod> /usr/openv/netbackup/bin/bplist -C st31bora01 -t 4 -l -R / -rw-rw---- oraprod dbaprod 24379392 Oct 14 12:55 /PASPROD_c-1968089396-20121014-02 -rw-rw---- oraprod dbaprod 24379392 Oct 14 02:01 /PASPROD_c-1968089396-20121014-01 -rw-rw---- oraprod dbaprod 24379392 Oct 14 01:56 /PASPROD_c-1968089396-20121014-00 -rw-rw---- oraprod dbaprod 24379392 Oct 13 12:04 /PASPROD_c-1968089396-20121013-00 -rw-rw---- oraprod dbaprod 22544384 Oct 12 17:05 /PASPROD_c-1968089396-20121012-03 -rw-rw---- oraprod dbaprod 22544384 Oct 12 12:05 /PASPROD_c-1968089396-20121012-02 I then try and use the following commands to recover the controlfile: rman set dbid = 1968089396 connect catalog rman10@RMANdb connect target backup_dba list backup of controlfile; RUN { ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE'; SEND 'NB_ORA_CLIENT=st31bbl01,NB_ORA_POLICY=ORA_PASPROD'; restore controlfile; } Unfortunately, this does not work and I get the following failure: Starting restore at 17-Oct-12 15:27:36 channel CH1: starting datafile backupset restore channel CH1: restoring control file channel CH1: reading from backup piece PASPROD_c-1968089396-20121014-01 ORA-19870: error reading backup piece PASPROD_c-1968089396-20121014-01 ORA-19507: failed to retrieve sequential file, handle="PASPROD_c-1968089396-20121014-01", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text: Backup file <PASPROD_c-1968089396-20121014-01> not found in NetBackup catalog failover to previous backup I don't understand why it's not working. The only thing I can see is that when I "list backup ofcontrolfile", I see media ID's that are at the primary site as indicated by "Media: @aaaac". RMAN> list backup of controlfile; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------ 5327585 Full 23.25M SBT_TAPE 00:01:03 14-Oct-12 02:02:28 BP Key: 5327593 Status: AVAILABLE Compressed: NO Tag: TAG20121014T020125 Handle: PASPROD_c-1968089396-20121014-01 Media: @aaaac Control File Included: Ckp SCN: 10909224447 Ckp time: 14-Oct-12 02:01:25 But when I go into the NetBackup Administration Console (at the DR site) and select NetBackup Management --> Catalog in the treeview on the left, I see all the Media ID's are "@aaaae". Any help you can offer would be greatly appreciated. KenSolved6.1KViews1like3Comments