Unable to view backup history, missing

[Msoro]

Hi Netbackup Guru's

I'm running Netbackup 6.5  on Solaris 10. I have created policies for both online & offline SAP database backups. The policy type  in bothe cases is SAP & execution of backups using these policies is OK.

However I'm experiencing problems when I attempt to view the backup history when trying to do  a restore.

When I go to the  Specify Netbackup Machines & Policy Type window the Policy Type for Restore the option for SAP is missing . Since my backup policies are for SAP nothing is displayed in the backup history.

NB: when creating policies the option for SAP is available in the policy type dropdown

Kindly assist

regards

[Anonymous]

When you post its helpful to give as much detail of versions in use.

from the master server can you post the output of

cat /usr/openv/netbackup/version

Which "backup archive restore" gui are you running version : Java or Windows

And is it on the master server or remotely you are running this.

Are you seeing any other policy types from the drop down list.

If you are only on 6.5 and not 6.5.[1-6] its advisable to update your master server as there may be bugs that have been ironed out since.

[Msoro]

Hi Stuart

Thanks for your response. Below is the additiional  info that  you've requested

root@DEV # cat /usr/openv/netbackup/version
HARDWARE SOLARIS
VERSION NetBackup 6.5
RELEASEDATE Mon Jul 23 16:30:00 CDT 2007
BUILDNUMBER 20070723
root@DEV #

Which "backup archive restore" gui are you running version : Java or Windows ?

java

And is it on the master server or remotely you are running this ?

I'm running this from the master server

Are you seeing any other policy types from the drop down list ?

Yes , When I attempt the restore all the other policy types are available in the dropdown  except SAP

Thanks

[Anonymous]

I rarely use the java gui but can confirm that the SAP type, and several other "Policy types for restore" are 'missing'.

I am using NBU 6.5.5

There was a similar discussion here:

https://www-secure.symantec.com/connect/forums/netbackup-restore-sap-jnbsa

Likewise our SAP DBA using the command line tools to perform the restores.

However, using the Windows BAR GUI you can see the SAP policy type backups listed.

[Marianne]

You cannot use the GUI to browse or restore SAP backups.

To browse, you can use bplist from the master or the client. From master:

bplist -C <client> -t 17 -R /

To restore, you will use brrestore or brrecover.

Detailed info in NBU for SAP Admin Guide: http://www.symantec.com/docs/TECH52817

[Mouse]

just my $0.02, according to the SAP support policy, backups and restores carried out ouside of brbackup/brrestore tools provided by SAP are not support by SAP. So, just use the SAP tools. Alternatively, you still can browse backupsets via bplist, but you can't recover with bprestore.

[Msoro]

Hi how do I use the -s & -e switches to list start & end date of backups . Whenever I try it results in the error Invalid start date:

below is what I get when I execute bplist with/without -s option

root@DEV # /usr/openv/netbackup/bin/bplist -C QAS -k SAP-SMN-offline-backup -t 17 -R
/oracle/SMN/102_64/dbs/initSMN.ora
/oracle/SMN/102_64/dbs/spfileSMN.ora
/oracle/SMN/102_64/dbs/initSMN.sap
/oracle/SMN/102_64/dbs/initSMN.utl
/oracle/SMN/sapreorg/spaceSMN.log
/oracle/SMN/sapreorg/paramSMN.log
/oracle/SMN/sapbackup/beetvlzh.aff
/oracle/SMN/sapbackup/backSMN.log
/oracle/SMN/sapdata1/sr3_1/sr3.data1
/oracle/SMN/sapdata2/sr3_3/sr3.data3
/oracle/SMN/sapdata3/sr3_7/sr3.data7
/oracle/SMN/sapdata4/sr3_8/sr3.data8
/oracle/SMN/sapdata4/sr3_9/sr3.data9
/oracle/SMN/sapdata1/sr3700_1/sr3700.data1
/oracle/SMN/sapdata2/sr3700_2/sr3700.data2
/oracle/SMN/sapdata4/sr3700_5/sr3700.data5
/oracle/SMN/sapdata1/sr3usr_1/sr3usr.data1
/oracle/SMN/sapdata1/temp_1/temp.data1
/oracle/SMN/origlogA/log_g15m1.dbf
/oracle/SMN/sapdata1/sr3_2/sr3.data2
/oracle/SMN/sapdata2/sr3_4/sr3.data4
/oracle/SMN/sapdata2/sr3_5/sr3.data5
/oracle/SMN/sapdata3/sr3_6/sr3.data6
/oracle/SMN/sapdata3/sr3700_3/sr3700.data3
/oracle/SMN/sapdata4/sr3700_4/sr3700.data4
/oracle/SMN/sapdata4/sr3db_1/sr3db.data1
/oracle/SMN/sapdata1/undo_1/undo.data1
/oracle/SMN/sapdata1/sysaux_1/sysaux.data1
/oracle/SMN/sapdata1/system_1/system.data1
/oracle/SMN/origlogA/log_g11m1.dbf
/oracle/SMN/origlogB/log_g12m1.dbf
/oracle/SMN/origlogA/log_g13m1.dbf
/oracle/SMN/origlogB/log_g14m1.dbf
/oracle/SMN/origlogB/log_g16m1.dbf
/oracle/SMN/origlogA/log_g17m1.dbf
/oracle/SMN/origlogB/log_g18m1.dbf
/oracle/SMN/origlogA/cntrl/cntrlSMN.dbf
root@DEV #

root@DEV # /usr/openv/netbackup/bin/bplist -help                               
USAGE: bplist [-A | -B] [-C client] [-S master_server]
      [-t policy_type] [-k policy] [-keyword "keyword phrase"]
      [-F] [-R [n]] [-b | -c | -u] [-l] [-Listpolicy] [-Listseconds]
      [-r] [-T] [-I] [-PI] [-unix_files | -nt_files] [-flops file_options]
      [-s mm/dd/yyyy  [HH:MM:SS]] [-e mm/dd/yyyy  [HH:MM:SS]] [filename]

root@DEV # /usr/openv/netbackup/bin/bplist -C QAS -k SAP-QAS-online-backup -s mm/dd/yyyy HH:MM:SS -t 17 -R
Invalid start date: mm/dd/yyyy
EXIT STATUS 144: invalid command usage
root@DEV #

Thanks

[Marianne]

You need to replace mm/dd/yyyy with actual date:

mm = month
dd = day
yyyy = year

So, if you want to list backups done since Saturday 11 December, you will use:

-s 12/11/2010

If you want to list backups done between Saturday and Monday, you will use:

-s 12/11/2010 -e 12/13/2010

[chaypon]

Hi

I have a question about list history backup.

I use command ### bplist -C slfdb1 -S slfbkup -t 18 -R /

/DB2/SLFDB/node0000/20110131010846/SLFDB.0.db2slf.node0000.51622.20110131010846.1
/DB2/SLFDB/node0000/20110131003834/SLFDB.0.db2slf.node0000.51621.20110131003834.1
/DB2/SLFDB/node0000/20110131001111/SLFDB.0.db2slf.node0000.51620.20110131001111.1
/DB2/SLFDB/node0000/20110130012421/SLFDB.0.db2slf.node0000.51605.20110130012421.1
/DB2/SLFDB/node0000/20110130004507/SLFDB.0.db2slf.node0000.51603.20110130004507.1
/DB2/SLFDB/node0000/20110129010855/SLFDB.0.db2slf.node0000.51592.20110129010855.1
/DB2/SLFDB/node0000/20110129003814/SLFDB.0.db2slf.node0000.51591.20110129003814.1
/DB2/SLFDB/node0000/20110128010738/SLFDB.0.db2slf.node0000.51567.20110128010738.1
/DB2/SLFDB/node0000/20110128003817/SLFDB.0.db2slf.node0000.51566.20110128003817.1
/DB2/SLFDB/node0000/20110127010836/SLFDB.0.db2slf.node0000.51545.20110127010836.1
/DB2/SLFDB/node0000/20110127003813/SLFDB.0.db2slf.node0000.51544.20110127003813.1
/DB2/SLFDB/node0000/20110126010819/SLFDB.0.db2slf.node0000.51517.20110126010819.1
/DB2/SLFDB/node0000/20110126003717/SLFDB.0.db2slf.node0000.51516.20110126003717.1
/DB2/SLFDB/node0000/20110125010829/SLFDB.0.db2slf.node0000.51496.20110125010829.1
/DB2/SLFDB/node0000/20110125003725/SLFDB.0.db2slf.node0000.51495.20110125003725.1
/DB2/SLFDB/node0000/20110116010629/SLFDB.0.db2slf.node0000.51222.20110116010629.1
/DB2/SLFDB/node0000/20110109010715/SLFDB.0.db2slf.node0000.51001.20110109010715.1
/DB2/SLFDB/node0000/20110102010757/SLFDB.0.db2slf.node0000.50290.20110102010757.1
/DB2/SLFDB/node0000/20101201052133/SLFDB.0.db2slf.node0000.48771.20101201052133.1
/DB2/SLFDB/node0000/20101101050325/SLFDB.0.db2slf.node0000.46479.20101101050325.1
/DB2/SLFDB/node0000/20101001052554/SLFDB.0.db2slf.node0000.41788.20101001052554.1
/DB2/SLFDB/node0000/20100901055954/SLFDB.0.db2slf.node0000.40006.20100901055954.1
root@slfbkup #

..................................................

root@slfbkup #
root@slfbkup # bplist -C slfdb1 -S slfbkup -t 18 -R -s 12/15/2010 -e 01/15/2011 /
/DB2/SLFDB/node0000/20110109010715/SLFDB.0.db2slf.node0000.51001.20110109010715.1
/DB2/SLFDB/node0000/20110102010757/SLFDB.0.db2slf.node0000.50290.20110102010757.1
root@slfbkup #

......................................................

Am sure backup db2 every day. why history backup data 20110101 is lost ?

I want to restore database 20110101 but I don't have timestamp .

thank you.