when trying to connect to my database i got this error:
oracle: ORA-00257: archiver error. Connect internal only, until freed.
source: http://www.dba-oracle.com/sf_ora_00257_archiver_error_connect_internal_only_until_freed.htm
to double check the archivelog redo space:
cd ~/path/to/oracle/product/10.2.0/db_1/bin
./sqlplus "sys/any as sysdba"
SQL> archive log list;
SQL> show parameter db_recovery_file_dest;
SQL> SELECT * FROM V$RECOVERY_FILE_DEST;
source: https://forums.oracle.com/forums/thread.jspa?threadID=519282
in another terminal:
cd ~/path/to/oracle/product/10.2.0/db_1/bin
./rman target / nocatalog
RMAN > delete archivelog all;
source: http://oracle-abc.wikidot.com/cold-backup-with-rman
it seemed as if things werent quite deleted so i ran this:
RMAN > run {
allocate channel t1 type disk;
backup archivelog all delete input format '/home/oracle/arch_NaVu_%s';
release channel t1;
}
source: http://www.shutdownabort.com/errors/ORA-19809.php
No comments:
Post a Comment