Dbvisit Community Dbvisit home       

Go Back   Dbvisit Community > Dbvisit Standby - Technical > Dbvisit Standby - Archive Management log Module

Thread Tools Search this Thread Display Modes
Old 02-15-2009, 07:49 AM
Arjen Visser Arjen Visser is offline
Dbvisit Team
Join Date: Jan 2008
Location: Auckland, New Zealand
Posts: 383
Default Archiver error - Archive location full (ORA-16014)

If the following error is encountered:

ERROR: ORA-00257: archiver error. Connect internal only, until freed. Enter user-name: SP2-0306: Invalid option.Enter user-name: SP2-0306:
Invalid option.SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
Dbvisit terminated.
Return code = 433

Or 16014:
ORA-16014: log 1 sequence# 1725 not archived, no available destinations[/COLOR]

Or if the following message is found in the alert.log:
ARC0: Failed to archive thread

Connect to rman:
RMAN> connect target /

Synchronise the RMAN repository so that it knows about the deleted archive logs use command:
RMAN> crosscheck archivelog all;
You can schedule this command once a week.

This command is different in 8i (although it would probably still work in later versions of RMAN):
RMAN> change archivelog all crosscheck;

The crosscheck command does not delete the information about the logs that it could not find on disk, it just updates their status in the repository as 'EXPIRED'.
To obtain a list of logs marked as 'EXPIRED' use the following command:
RMAN> list expired archivelog all;

If it is not necessary to keep the information about these logs in the repository, delete them with command:
RMAN> delete expired archivelog all;

Another option to avoid the problem with RMAN complaining about logs that were manually deleted from disk is to modify the RMAN backup script and add
"skip inaccessible" to the command that backs up the archive logs.

backup archivelog all format '' skip inaccessible;

Last edited by Arjen Visser; 03-31-2012 at 07:43 AM.
Reply With Quote
Old 04-20-2012, 12:38 PM
Arjen Visser Arjen Visser is offline
Dbvisit Team
Join Date: Jan 2008
Location: Auckland, New Zealand
Posts: 383

To remove archive logs from RMAN directly, the following command can be used. Note that this does not check or verify if the archive log is still needed by Dbvisit Standby:


The above command removes all archive logs older than 14 days.

Last edited by Arjen Visser; 04-29-2012 at 06:07 PM.
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off

Forum Jump

All times are GMT +12. The time now is 12:15 AM.