1 set of redo logs empty
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: 1 set of redo logs empty

  1. #1
    Join Date
    Feb 2011
    Posts
    2

    Question 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

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  3. #3
    Join Date
    Feb 2011
    Posts
    2
    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

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Quote Originally Posted by sio View Post
    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
  •  


Click Here to Expand Forum to Full Width