DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Switch Redo Logs Halt

  1. #1
    Join Date
    Sep 2002
    Posts
    411

    Switch Redo Logs Halt

    Hi all,

    this is a brand new database with no connection to this databse yet and I am doing some testing with the databse. Any way, I have 6 redo log groups and 2 memebers for each group and 10M for each members.


    SQL> connect internal/bla
    Connected.
    SQL> archive log list
    Database log mode Archive Mode
    Automatic archival Enabled
    Archive destination C:\archivedlogs\test
    Oldest online log sequence 500
    Next log sequence to archive 500
    Current log sequence 505
    SQL> alter system switch logfile
    2 ;

    The log never switch, what is it waiting for ??? why it take so long to switch the log????

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Does the alert.log say anything?
    Jeff Hunter

  3. #3
    Join Date
    Sep 2002
    Posts
    411
    Jeff,

    thanks for your great hint

    wrong format!!!!!
    thanks again.

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