OraFAQ Forum: Server Administration » How to know redo log member file has already damage in oracle 10g?

Home » RDBMS Server » Server Administration » How to know redo log member file has already damage in oracle 10g?

Tue, 10 April 2007 05:35

wxfjordan
Messages: 92
Registered: December 2006

Member

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

(Give me some direction. Thanks!!!)

Tue, 10 April 2007 05:54

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

Tue, 10 April 2007 06:38

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

v$logfile
Regards
Michel

Tue, 10 April 2007 23:23

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?

Tue, 10 April 2007 23:35

Michel Cadot
Messages: 68686
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: Thu Sep 19 23:38:46 CDT 2024