-
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
-
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.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
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
-
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,
Last edited by vnktummala; 02-15-2011 at 04:26 AM.
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|