Home » Server Options » Data Guard » dba (oracle 10g RHEL4)
dba [message #363079] Fri, 05 December 2008 01:01 Go to next message
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
Senior Member
I am working in a oracle client machine and also i handle database server also. if i was working Suddenly following error comes

ORA-00257 archiever error.Connect internal only,until freed

I can rectify this error using following command

Rman>delete archievelog all;
Rman>crosscheck archievelog all;

Then database worked well,next day the same error come
and i cannot shutdown the database server also

so kindly Send the solution

regards

vishu

[Updated on: Fri, 05 December 2008 01:02]

Report message to a moderator

Re: dba [message #363096 is a reply to message #363079] Fri, 05 December 2008 01:42 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Add more disk ?
Re: dba [message #363110 is a reply to message #363096] Fri, 05 December 2008 02:32 Go to previous messageGo to next message
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
Senior Member
no sir
Re: dba [message #363119 is a reply to message #363079] Fri, 05 December 2008 02:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
backup and delete archived logs more often.
...or do less work.

Regards
Michel
Re: dba [message #363149 is a reply to message #363119] Fri, 05 December 2008 04:19 Go to previous messageGo to next message
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
Senior Member
kindly send the sql query
Re: dba [message #363152 is a reply to message #363149] Fri, 05 December 2008 04:25 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Question

SQL query? What SQL query?

Regards
Michel
Previous Topic: Standby database error: primary failed to connect to standby
Next Topic: Data guard availability
Goto Forum:
  


Current Time: Thu Mar 28 04:16:16 CDT 2024