Home » RDBMS Server » Server Administration » How to know redo log member file has already damage in oracle 10g?
How to know redo log member file has already damage in oracle 10g? [message #229916] Tue, 10 April 2007 05:35 Go to next message
wxfjordan
Messages: 92
Registered: December 2006
Member




How to know redo log member file damaged in oracle 10g?


(Give me some direction. Thanks!!!)

Re: How to know redo log member file has already damage in oracle 10g? [message #229923 is a reply to message #229916] Tue, 10 April 2007 05:54 Go to previous messageGo to next message
aboodlardy
Messages: 80
Registered: November 2006
Location: India
Member
Hi

If u mean to say when u try to connect, it will give an error message.
regards
Abood
Re: How to know redo log member file has already damage in oracle 10g? [message #229945 is a reply to message #229916] Tue, 10 April 2007 06:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

v$logfile
Regards
Michel
Re: How to know redo log member file has already damage in oracle 10g? [message #230118 is a reply to message #229916] Tue, 10 April 2007 23:23 Go to previous messageGo to next message
wxfjordan
Messages: 92
Registered: December 2006
Member



My mean is:

There are 2 members in one log group. If one of log members is damaged, How to check this log file?

Re: How to know redo log member file has already damage in oracle 10g? [message #230121 is a reply to message #230118] Tue, 10 April 2007 23:35 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't check it, Oracle checks it for you.
Just query the view and check alert.log.

Regards
Michel
Previous Topic: 10g and the multi-schema database option meaning
Next Topic: Setting SGA size
Goto Forum:
  


Current Time: Sat Dec 10 12:44:12 CST 2016

Total time taken to generate the page: 0.10067 seconds