Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2003
    Posts
    23

    Arrow Unanswered: archiving problems

    Dear Readers,

    Thanks for the queries responded.

    My Database is running under 24 X 7 and is running under NonArchiving mode currently .How will you bring my system from NoArchiving mode to Archiving mode WITHOUT shuting down the Database.

    Please consider this urgent and mail me at manips15@hotmail.com


    with regards
    MANI

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    which version; as with 9i there is an option to alter database cmd available to do it on the fly

  3. #3
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    200
    Hi,

    I also have heard that Oracle 9i has an option to convert from No Archive to Archive mode by setting Automatic Archival,but not sure of the steps.

    It would be great if anyone has some idea and culd share it.

    thanks

    mickykt

  4. #4
    Join Date
    Nov 2002
    Posts
    833
    Originally posted by mickykt
    Hi,

    I also have heard that Oracle 9i has an option to convert from No Archive to Archive mode by setting Automatic Archival,but not sure of the steps.

    It would be great if anyone has some idea and culd share it.

    thanks

    mickykt
    alter system archive log start;

    make additionally sure that the init.ora file is ajusted to archive_log_start = true for further usage

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •