Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

a urgent current problem regarding to archiver error, please help?

s9225Feb 25 2008 — edited Feb 25 2008
Hi, all:
In my staing RAC database, in node1, we have an error when user try to connect to database like:

'ORA-00257 archiver error, connect internal only, until freed.'

the problem is DB_RECOVERY_FILE_DEST_SIZE is small--we don't have enough disk space.

so what I try to do is
to delete all backups in flash recovery area, then go to rman
rman> delete backup;
then
rman>sql 'alter system archive log current';
to free arive space

I can fix this problem in all other enviroments, but today, when I try to use
rman target /
to connect database, it always hangs there, so I can do nothing like above,

all the developers are waiting for this db, is there any friend can help me?

thanks a lot lot
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 24 2008
Added on Feb 25 2008
10 comments
777 views