ORA-00257: archiver error. [message #524052] |
Wed, 21 September 2011 09:43  |
varunvir
Messages: 389 Registered: November 2007
|
Senior Member |
|
|
Hi Experts,
While connecting to one of the dev database I am getting
following error:-
ORA-00257: archiver error. Connect internal only, until freed.
But when i am checking as sys user there is no archive desination
defined in the db.I mean log_archive_dest locations have not
been given any value.Where can I check Archive destination in
this scenario.Is there any default place where oracle stores
archive logs incase log_archive_dest is not given any value.
Thanks,
Varun
|
|
|
|
|
Re: ORA-00257: archiver error. [message #524058 is a reply to message #524055] |
Wed, 21 September 2011 10:11   |
varunvir
Messages: 389 Registered: November 2007
|
Senior Member |
|
|
Hi Mahesh,
I am getting this:-
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 7368
Next log sequence to archive 7368
Current log sequence 7370
I have deleted archive logs at this destination but
still getting the same error.
Thanks,
Varun
|
|
|
|
|
|
|