DataProtector Backup List

on July 2, 2014 at 11:50 am

Posted In: Unix notes (Cat)

/opt/omni/lbin/devbra -dev Â |grep HU

# ./omnidb -session -datalist “Oracle8

./omnidb -session -type backup -last 1

./omnidb -session 2011/11/09-228 â€“report

./omnidb -session 2011/11/08-388 -report

./omnidb -session -datalist “Oracle8 DOC_CENTRICA_doclorap005_ORA_XE1_ON_Weekly” -last 7

/var/opt/omni/log

When encountering rman backup errors, it is worth taking a look in directory /var/opt/omni/log at files debug.log Â inet.log Â oracle8.log.

/opt/omni/bin/omnidb -oracle8 “nodename-b:NODENAME_ORA_DBNAME_ON_ARCHIVEDBNAME_A_16583:804933109:1>.dbf” -detail

omnidb is part of the Data Protector GUI and command line interface package.

List all backups from all servers, all users:

/opt/omni/bin/omnidb -session â€“detail

Because channel for archivelog backup had ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=DB_A,=OB2BARLIST=NODENAME_ORA_DBNAME_ON_ARCHIVE)

Same as before, but limit to just user orabackup user:

/opt/omni/bin/omnidb -user orabackup -session â€“detail

One sample paragraph of output:

SessionID : 2012/05/09-213

Backup Specification: Oracle8 NODENAME_ORA_DBNAME_ON_ARCHIVE

Session typeÂ Â Â Â Â Â Â : Backup (full)

StartedÂ Â Â Â Â Â Â Â Â Â Â Â : Wed 09 May 2012 03:01:00 PM BST

FinishedÂ Â Â Â Â Â Â Â Â Â Â : Wed 09 May 2012 03:09:56 PM BST

StatusÂ Â Â Â Â Â Â Â Â Â Â Â Â : Completed

Number of warningsÂ : 0

Number of errorsÂ Â Â : 0

UserÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â : orabackup

GroupÂ Â Â Â Â Â Â Â Â Â Â Â Â Â : dba

HostÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â : hpnodename.hpecs.net

List details of all objects in a particular backup sessionid:

/opt/omni/bin/omnidb -session “2012/05/09-213” â€“detail

(Sample paragraph of output)

Object name : nodename-b.hpecs.net:NODENAME_ORA_DBNAME_ON_ARCHIVEdbname_A_8011:782838060:1>.dbf

Object typeÂ Â Â Â Â Â Â : Oracle8

Object statusÂ Â Â Â Â : Completed

StartedÂ Â Â Â Â Â Â Â Â Â Â : Wed 09 May 2012 03:01:59 PM BST

FinishedÂ Â Â Â Â Â Â Â Â Â : Wed 09 May 2012 03:02:16 PM BST

Object sizeÂ Â Â Â Â Â Â : 154368 KB

Backup typeÂ Â Â Â Â Â Â : Full

ProtectionÂ Â Â Â Â Â Â Â : Protected for 30 days

Catalog retentionÂ : Same as data protection.

Version typeÂ Â Â Â Â Â : Normal

AccessÂ Â Â Â Â Â Â Â Â Â Â Â : Public

Number of warnings : 0

Number of errorsÂ Â : 0

Device nameÂ Â Â Â Â Â Â : VLS01_06.D02

Backup IDÂ Â Â Â Â Â Â Â Â : 2012/05/09-213

Copy IDÂ Â Â Â Â Â Â Â Â Â Â : 62653 (Orig)

EncryptedÂ Â Â Â Â Â Â Â Â : No

DiskAgent IDÂ Â Â Â Â Â : 1336572061

Search by RMAN handle:

/opt/omni/bin/omnidb -oracle8 “hpnodename.hpecs.net:NODENAME_ORA_DBNAME_ON_ARCHIVEDBNAME_A_8011:782838060:1>.dbf” â€“detail

(handle is NODENAME_ORA_PSTGC1_ON_ARCHIVEDBNAME_A_8011:782838060:1>.dbf)

SessionIDÂ Â Â Â : 2012/05/09-213