Veritas-bu

[Veritas-bu] Interesting Error with NBU 5.1MP5 and Oracle

2006-09-29 19:33:41
Subject: [Veritas-bu] Interesting Error with NBU 5.1MP5 and Oracle
From: jkstill at gmail.com (Jared Still)
Date: Fri, 29 Sep 2006 16:33:41 -0700
Though no errors were raised, there is definitely an error condition.

The server is 5.1 MP5 on Windows 2003 Enterprise Server.

The client is RH Linux ES 4, Oracle 9.2.0.6 with the NBU 5.1 MP5 client.

While investigating some backup issues, I found the following interesting
condition in a log file.  Though the template seen in the log clearly shows
that
database DB01 is to be backed up, database DB02 was the one that was
actually backed up.

This has been verified with bplist, and the fact that the controlfile
autoback
filename inludes the DBID from DB01.   Both databases are on the same
server, but the passwords for the NBU account is different on each. It
appears
as if the NBU software is picking up the wrong database and password from
it's own data.  Losing track of pointers.

Also, both databases have backups scheduled at the same time.

Interesting, no?

I've opened a support case for this, but just wondered if anyone else
has ever seen anything like this.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist


Log File - abbreviated for space.

INF - Begin progress logging for process: (19550)
INF - Using policy ORA_ordb02_full to perform a server directed Standard
backup.
INF - Starting Oracle Recovery Manager.
INF - Using: /u01/app/oracle/product/9.2.0/apps9i/bin/rman
INF - Connection info: target 'nbu/*****@DB01' nocatalog
INF - Start of Recovery Manager input.
INF - # -----------------------------------------------------------------
INF - # RMAN command section
INF - # -----------------------------------------------------------------
INF - RUN {
INF - ALLOCATE CHANNEL ch00
INF -     TYPE 'SBT_TAPE';
INF - SEND
'NB_ORA_CLIENT=ordb02,NB_ORA_SERV=rsysnbu,NB_ORA_POLICY=ORA_ordb02_agile_full,NB_ORA_PC_SCHED=Full';
INF - BACKUP
INF -     INCREMENTAL LEVEL=0
INF -     FORMAT 'bk_%d_u%u_s%s_p%p_t%t'
INF -     DATABASE;
INF - RELEASE CHANNEL ch00;
INF - # Backup Archived Logs
INF - sql 'alter system archive log current';
...
INF - }
INF - End of Recovery Manager input.
INF - Start of Recovery Manager output.
INF - Recovery Manager: Release 9.2.0.6.0 - 64bit Production
INF - connected to target database: DB02 (DBID=2182868868)
INF - using target database controlfile instead of recovery catalog
INF - allocated channel: ch00
INF - channel ch00: starting incremental level 0 datafile backupset
INF - input datafile fno=00018 name=/u01/oradata/DB02/perfstat01.dbf
INF - input datafile fno=00002 name=/u01/oradata/DB02/undotbs01.dbf
INF - input datafile fno=00001 name=/u01/oradata/DB02/system01.dbf
INF - input datafile fno=00007 name=/u01/oradata/DB02/xdb01.dbf
INF - input datafile fno=00003 name=/u01/oradata/DB02/drsys01.dbf
INF - input datafile fno=00006 name=/u01/oradata/DB02/users01.dbf
INF - input datafile fno=00004 name=/u01/oradata/DB02/indx01.dbf
INF - input datafile fno=00005 name=/u01/oradata/DB02/tools01.dbf
INF - piece handle=bk_DB02_ulvhu9u3c_s703_p1_t602208364 comment=API Version
2.0,MMS Version 5.0.0.0
INF - channel ch00: backup set complete, elapsed time: 00:10:06
INF - Starting Control File and SPFILE Autobackup at 27-SEP-06
INF - piece handle=c-2182868868-20060927-00 comment=API Version 2.0,MMS
Version 5.0.0.0
INF - Finished Control File and SPFILE Autobackup at 27-SEP-06
INF - released channel: ch00
...
INF - archive log
filename=/u01/oradata/DB02/archive/DB02_0001_0000001867.arc recid=1860
stamp=602146512
INF - archive log
filename=/u01/oradata/DB02/archive/DB02_0001_0000001875.arc recid=1868
stamp=602209040
INF - archive log
filename=/u01/oradata/DB02/archive/DB02_0001_0000001876.arc recid=1869
stamp=602209041
INF - Starting Control File and SPFILE Autobackup at 27-SEP-06
INF - piece handle=c-2182868868-20060927-01 comment=API Version 2.0,MMS
Version 5.0.0.0
INF - Finished Control File and SPFILE Autobackup at 27-SEP-06
INF - piece handle=bk_DB02_um5hu9utm_s709_p1_t602209206 comment=API Version
2.0,MMS Version 5.0.0.0
INF - End of Recovery Manager output.
INF - End Oracle Recovery Manager.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: 
http://mailman.eng.auburn.edu/pipermail/veritas-bu/attachments/20060929/19b0ff32/attachment-0001.html

<Prev in Thread] Current Thread [Next in Thread>
  • [Veritas-bu] Interesting Error with NBU 5.1MP5 and Oracle, Jared Still <=