Friday, February 22, 2008

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

In order to start archiver after having no space do the following :

Remove all archives;

SQL> alter system archive log stop;

System altered.

SQL> alter system archive log start;

System altered.

SQL> alter system switch logfile;

System altered.


then resync rman catalog

RMAN> crosscheck archivelog all;

RMAN> delete expired archivelog all;

AND TAKE FULL BACKUP !!!!!!

No comments:

Post a Comment