Wednesday, December 7, 2011

ORA-00257: archiver error. Connect internal only, until freed

Below are the steps that can be followed if above mentioned error is reported

[oracle@lab ~]$ sqlplus  username/password
ORA-00257: archiver error. Connect internal only, until freed

SQL> conn / as sysdba
SQL> show parameter archive


log_archive_dest_1                  LOCATION=/u02/oradata/wh2/archive
log_archive_format                   %t_%s_%r.dbf
---
Provide a new location for you have any mount available to accommodate load the archive size and frequency.

SQLalter system set log_archive_dest_1='location=/tmp' ;
System altered.
SQLalter system switch logfile;
System altered.


SQL> host;

[oracle@lab dbs]$ df -h

Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/u02       197G  187G   26M 100% /u02
/dev/mapper/u03       296G  249G   35G  88% /u03
/dev/mapper/u04       345G  275G   56G  84% /u04
/dev/mapper/u05       5.0G  1.6G  3.1G  34% /u05

also you can backup the archive logs with delete input or do some thing like that mentioned below. 
[oracle@lab dbs]$ rman target /

RMAN> delete archivelog all;
RMAN> host;

[oracle@lab ~]$ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/u02       197G  167G   21G  90% /u02
/dev/mapper/u03       296G  249G   35G  88% /u03
/dev/mapper/u04       345G  275G   56G  84% /u04
/dev/mapper/u05       5.0G  1.6G  3.1G  34% /u05

[oracle@lab ~]$ sqlplus  username/password
Connected.

Now backup the database

No comments:

Post a Comment