Re: RMAN-06089: archived log out of sync with catalog (10247 Views)
Reply
Frequent Advisor
Sharvil Desai
Posts: 53
Registered: ‎01-30-2002
Message 1 of 5 (10,247 Views)
Accepted Solution

RMAN-06089: archived log out of sync with catalog

Hi!
I am very new at using HP Openview OmniBackII software. My manager, who was in charge of taking the backups successfully has left the company and our Oracle 8i database' backup is failing.
What had happened was, the backup of Oracle database and Archive logs failed for 2 days in a row and so .ARC files were not deleted! This caused the production database to stop because the mount point was used 100%. Then what we did is manually moved the .ARC files to another location where we had free space, took the back up of it, and then deleted the .ARC files. But I think this manually moving of the .ARC files caused the archived log to be out of sync with catalog and so now the next backup keeps failing while giving us this error:

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: backup
RMAN-06089: archived log /emc_8_1/oradata/alloc/alcp/alcp_111902_1.ARC not found or out of sync with catalog
RMAN>

So can you guys please tell me how I can sync the catalog? This is very urgent! Thank you very much!
"help!"
Please use plain text.
Honored Contributor
Kurt Beyers.
Posts: 6,563
Registered: ‎10-04-2000
Message 2 of 5 (10,247 Views)

Re: RMAN-06089: archived log out of sync with catalog

Sharvil,

You need to do the following in RMAN:

Example for Oracle 8 use:
RMAN> Change Archivelog All Validate;

Example for Oracle 8i use:
RMAN> Change Archivelog All Crosscheck;

Example for Oracle 9i:

RMAN> crosscheck archivelog all;

Solution Explanation: =====================

These 2 commands check for the physical presence of the archived redo log on disk, and if it is present the file header is then checked. Files not found or files with incorrect file headers will be marked as deleted in the Recovery Catalog. Where files are stored on a tape device, the Media Manager catalog is queried for the presence of the file (no checking of headers is done in this case).

Kurt
Please use plain text.
Frequent Advisor
Sharvil Desai
Posts: 53
Registered: ‎01-30-2002
Message 3 of 5 (10,247 Views)

Re: RMAN-06089: archived log out of sync with catalog

Hi Kurt,
This was the perfect answer! Thank you!
"help!"
Please use plain text.
Valued Contributor
Jesus Fdez.
Posts: 219
Registered: ‎09-22-2003
Message 4 of 5 (10,247 Views)

Re: RMAN-06089: archived log out of sync with catalog

Hi, I have this problem and I execute this sentence but I obtain:

RMAN> Change Archivelog All Crosscheck;

RMAN-03022: compiling command: change
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: change
RMAN-06172: not connected to recovery catalog database


I have integrated Oracle8i but I don´t create recovery catalog, how I create it?

Thank
Please use plain text.
Occasional Visitor
Pradeep Khandatray
Posts: 1
Registered: ‎06-03-2007
Message 5 of 5 (10,247 Views)

Re: RMAN-06089: archived log out of sync with catalog

Usually this problem occurs when one or more of your archive log is not found during backup. If u are using Catalog then connect to the sql prompt by supplying catalog username/ password and select the al_key from AL table for the following missing file and delete that entry from AL table. i.e.

SQL> SELECT AL_KEY FROM AL WHERE FNAME ='alcp_111902_1.ARC';

then delete respective al_key entry from al table & then run the backup.
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation