1 set of redo logs empty

Printable View

02-14-2011, 01:16 PM
sio

1 set of redo logs empty

Hi

New to Oracle DBA so please help.

My database has 2 sets of redo-logs. One entire set of logs is now empty. I am getting the following in my alert log :

Errors in file /siotest/oracle/app/oracle/admin/SID/bdump/rfl_arc0_2126.trc:
ORA-00313: Message 313 not found; No message file for product=RDBMS, facility=ORA; arguments:
[2] [1]
Mon Feb 14 15:29:53 GMT 2011
Errors in file /siotest/oracle/app/oracle/admin/SID/bdump/rfl_arc0_2126.trc:
ORA-00313: Message 313 not found; No message file for product=RDBMS, facility=ORA; arguments:
[2] [1]
Mon Feb 14 15:41:21 GMT 2011
Errors in file /siotest/oracle/app/oracle/admin/SID/bdump/rfl_lgwr_1909.trc:
ORA-00321: Message 321 not found; No message file for product=RDBMS, facility=ORA; arguments:
[1] [1]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments:
[1] [1] [/siotest/redo_live/oradata/SID/redo01a.log]
ORA-27091: Message 27091 not found; No message file for product=RDBMS, facility=ORA
ORA-27069: Message 27069 not found; No message file for product=RDBMS, facility=ORA
Additional information: 1
Additional information: 1

The database is up-and-running fine.

Can someone please help me with getting my 2 sets of redo-logs working correctly. As I said I'm new to this so please be specific !!!!

Thanks
Sio
02-14-2011, 02:32 PM
PAVB

Check trace file for details a.k.a. *.trc
Make sure physical redo files are there.
Make sure oracle account has right privileges on redo files.
02-14-2011, 07:40 PM
sio

Hi

Thanks for your response. One set of the redo-log files are physically there but empty. Both sets of redo-logs have the same permissions and one set are getting written to and one are not. Not sure why. Can anyone help me get both sets of redo-logs used.

Thanks
Sio
02-15-2011, 04:23 AM
vnktummala

Quote:

Originally Posted by sio

Hi

One set of the redo-log files are physically there but empty. Both sets of redo-logs have the same permissions and one set are getting written to and one are not. Not sure why. Can anyone help me get both sets of redo-logs used.

how do you know one set of redo logs are empty? I am sure you haven't open them in editor to see what is there in side.

There might be less or no activity going on in your DB.

Follow the below steps.

1. select group#,members,status from v$log; - post the output of this command
2. alter system switch logfile;
3. select group#,members,status from v$log; - post the output of this command

Thanks,