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

Thread: How To Change Database log mode Urgent

  1. 03-06-2003, 07:39 AM #1
    samx18's Avatar
    samx18
    samx18 is offline Junior Member
    Join Date
    May 2002
    Posts
    36

    Question How To Change Database log mode Urgent

    Hi
    I had a database previously running on archive log mode.I have set the log_archive_start parameter to false and restarted the database.but when i connect as internal and issue the command ARCHIVE LOG LIST the database log mode still shows Archive Mode.How do i change this?

    Thanks

    Sam
    Reply With Quote Reply With Quote
  2. 03-06-2003, 07:43 AM #2
    ggnanaraj
    ggnanaraj is offline Senior Advisor
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    1. shutdown immediate
    2. startup mount
    3. alter database noarchivelog;
    4. alter database open

    HTH.

    P.S.: You could avoid the 'urgent' in your post to get a quick answer.
    Reply With Quote Reply With Quote
  3. 03-06-2003, 07:55 AM #3
    samx18's Avatar
    samx18
    samx18 is offline Junior Member
    Join Date
    May 2002
    Posts
    36
    Hi
    Thanks it worked.My problem is solved now.
    Another query is that some of my inactive log members have the status as STALE.Metalink suggests that the state will get normal as soon as these groups become active. Is it true?
    P.S.: You could avoid the 'urgent' in your post to get a quick answer.
    ill take of this in my future posting

    Thanks ggnanaraj once again.

    Sam
    Reply With Quote Reply With Quote
  4. 03-06-2003, 07:56 AM #4
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by ggnanaraj
    P.S.: You could avoid the 'urgent' in your post to get a quick answer.
    LOL
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
    Reply With Quote Reply With Quote
  5. 03-06-2003, 08:19 AM #5
    ggnanaraj
    ggnanaraj is offline Senior Advisor
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by DaPi
    LOL
    LOL means what ??
    Reply With Quote Reply With Quote
  6. 03-06-2003, 08:21 AM #6
    ggnanaraj
    ggnanaraj is offline Senior Advisor
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by samx18
    Metalink suggests that the state will get normal as soon as these groups become active. Is it true?
    I don't know what to say if you question what docs/metalink state!

    Reply With Quote Reply With Quote
  7. 03-06-2003, 08:29 AM #7
    samx18's Avatar
    samx18
    samx18 is offline Junior Member
    Join Date
    May 2002
    Posts
    36
    Ok thanks guys for the help.
    i guess my query has been solved.

    Sam
    Reply With Quote Reply With Quote
  8. 03-06-2003, 08:31 AM #8
    samx18's Avatar
    samx18
    samx18 is offline Junior Member
    Join Date
    May 2002
    Posts
    36
    LOL means what ??
    BTW LOL means Laugh Out Loudly

    Sam
    Reply With Quote Reply With Quote
  9. 03-06-2003, 08:32 AM #9
    ggnanaraj
    ggnanaraj is offline Senior Advisor
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by samx18
    BTW LOL means Laugh Out Loudly

    Sam
    It also means Lots of Luck
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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