Netbackup unable to take archive logs.

[mrinal_sarkar62]

Hi,

Our client have a stange problem.

They have NBU 6.5 on unix system.

We were taking backup of Oracle databse with Rman.

We have 2 policy one for Monday nad Other is for Tuesday with the same Templet for both the policy.

But, the proble, is the Monday policy is unable to take "Archive log" backup , where as the tuesday policy can take the "Archive Log" backup.

I have copied the tuesday policy and used as monday policy, still the same.

Here is the error for the Monday policy's backup:-

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

***

finished piece 1 at 14-FEB-11
piece handle=bk_21294_1_743109586 tag=HOT_DB_BK_LEVEL0 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:54:08
Finished backup at 14-FEB-11

sql statement: alter system archive log current

released channel: ch00

allocated channel: ch00
channel ch00: sid=634 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 6.5 (2007072323)

Starting backup at 14-FEB-11
current log archived
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 02/14/2011 20:13:59
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /oracle/mlloradb/app/archive/mlloradb/mlloradb_1_623691662_438022.arc
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3

RMAN> RMAN>

Recovery Manager complete.
logout root

Script /BACKUP/RMANSCRIPT/hot_database_backup.sh
==== ended in error on Mon Feb 14 20:13:59 IST 2011 ====

*************************************************************************************************************

Where as the tuesday backup is working fine.

I have checked some of the KB articles, where it says there might be some problem with the NBU media server.

But how could it is successful with tuesday backup.

Is there any changes made by the DB at the Oracle side or any pronle with the Database.

I am attaching both the files.

Please, help.

Thanks.

[Marianne]

You actually mean RMAN is unable to backup archive logs:

RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /oracle/mlloradb/app/archive/mlloradb/mlloradb_1_623691662_438022.arc
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory

Maybe someone deleted archive logs manually over the weekend??

[Mouse]

You need to do a log cross-check.

If you're not DBA, ask your DBA to do that. The problem has nothing to do with NBU, sorry

[mrinal_sarkar62]

Hi,

You all were right.

The DBA of the client have moved to Archive logs to some other location.

This changes were not updated to the RMAN.

Then they(Oracle DBA) have updated the RMAN and the backup were running fine.

Can you you help me to know that how is that  possible to identify using RMAN command to check the logs details that were retained by the RMAN database.

OR

Any Netbackup command to identify that the RMAN is not update with the deleted logs.

Thanks.

[Will_Restore]

RMAN commands should be left to the DBA.  Unless you are already comfortable with Oracle database I would just inform your DBA if/when you see another RMAN-06059 error.