The best place to ask programming/development questions, imo. UPDATE: stackoverflow is the *worst* place to *ask* questions (if your first question/comment doesn't get any up-rating/response, then u can't ask anymore questions--ridiculously unrealistic), but a great reference for finding answers.

My Music (Nickleus)

20120216

how to delete oracle 10 archive log redo files

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 (external link)

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 (external link)

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