Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Problems with brarchive, PLEASE HELP!!!

Erik Rios
Occasional Contributor

Problems with brarchive, PLEASE HELP!!!

My Archive are full(100%),so I run the command brarchive "brarchive -sd -c", but appear the follow:

BR002I BRARCHIVE 4.6C (4)
BR006I Start of offline redo log processing: adgcscfu.svd 2001-08-31 09.16.46
BR301W SQL error -257 at location BrDbConnect-1
ORA-00257: archiver error. Connect internal only, until freed.
BR310W Connect to database instance RY2 failed
BR301W SQL error -257 at location BrDbConnect-1
ORA-00257: archiver error. Connect internal only, until freed.
BR310W Connect to database instance RY2 failed

BR280I Time stamp 2001-08-31 09.16.53
BR008I Offline redo log processing for database instance: RY2
BR009I BRARCHIVE action ID: adgcscfu
BR010I BRARCHIVE function ID: svd
BR011I 70 offline redo log files found for processing, total size 1374.948 MB
BR113I Files will be compressed by hardware
BR130I Backup device type: tape
BR102I Following backup device will be used: /dev/rmt/0mn
BR103I Following backup volume will be used: RY2A01
BR126I Unattended mode active - no operator confirmation required

BR208I Volume with name RY2A01 required in device /dev/rmt/0mn

BR280I Time stamp 2001-08-31 09.16.53
BR226I Rewinding tape volume in device /dev/rmt/0m ...
BR278E Command output of 'LANG=C mt -t /dev/rmt/0m rew':
/dev/rmt/0m: I/O error
BR280I Time stamp 2001-08-31 09.16.53
BR279E Return code from 'LANG=C mt -t /dev/rmt/0m rew': 1
BR213E Winding tape volume in device /dev/rmt/0mn failed

BR016I 0 offline redo log files processed, total size 0.000 MB
BR301W SQL error -257 at location BrDbConnect-1
ORA-00257: archiver error. Connect internal only, until freed.
BR310W Connect to database instance RY2 failed

BR007I End of offline redo log processing: adgcscfu.svd 2001-08-31 09.16.53
BR280I Time stamp 2001-08-31 09.16.54
BR005I BRARCHIVE terminated with errors


Some know what I can do!!


thanks, Erik.
Always to Help U
1 REPLY
Rita C Workman
Honored Contributor

Re: Problems with brarchive, PLEASE HELP!!!

The error reported is ORA-000257 and here is Oracle's explanation:
ORA-00257: archiver is stuck. CONNECT INTERNAL only, until freed

Cause: The ARCH process received an error while trying to archive a redo log file. If the problem is not resolved
soon, the database will stop executing transactions. The most likely cause of this message is that the destination device
is out of space to store the redo log file.

Action: Check the archiver trace file for a detailed description of the problem. Also, verify that the device specified in
the initialization parameter ARCHIVE_LOG_DEST is set up properly for archiving.
*************
From looking at your excerpt, I noted that your trying to put them to a tape device and you got an i/o error. It shows that 0 got written. So first you might check the device....then ask yourself "can this tape device hold all that info???"..and then as the resolution above std, make sure the device in specified in the initialization paramater ARCHIVE_LOG_DEST.

Hope this helps,
Rita