online redolog files

[Former Member]

HI

i have installed ECC 6.0 on Dell Power Edge Server with RAID configuration(RAID 1 for OS(Linux),RAID 5 for oracle)

After installation i have mounted OriglogB and MirrorlogA on RAID 1 harddisk.

the problem is that redo log files are not getting updated in OriglogB and MirrorlogA .the other two (OriglogA & MirrorlogA ) files are getting updated.Control file in OriglogB is fine ,there is no problem in starting/stopping central instance also.

What could be the problem? How to resolve this issue?

regards

ganesh

[Former Member]

Hello Ganesh,

Login to Oracle database through SQLPLUS & execute the following command.

SQL> alter database backup controlfile to trace.

Now open the newly generated trace file & check the location & size of the Origlog* & Mirrlog* files. This will give you a fair idea about how the control file is with respect to the online redolog files.

[Cross check by executing the following commands]

SQL> select member from v$logfile;

SQL> select status from v$log

If required try switching the logfiles.

SQL> Alter system switch logfile;

Regards,

Ammey Kesarkar

'Award points for useful info'

[Former Member]

Ganesh,

By what means u came to know "redo log files are not getting updated in OriglogB and MirrorlogA ".

"Control file in OriglogB is fine " what exactly u want to say by this.

Bounce Databse instance.Let me know if you face any problems.

Have a look on alert<sid>.log file for any errors.

Regards

Vinod

[Former Member]

Hi,

Check the following syntax in sqlplus

select member from v$logfile;

Does it shows the name of all the destinations?

Regards