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

Thread: Backup Problem In NT and Linux

  1. #1
    Join Date
    Dec 2000
    Posts
    255
    Hello

    I have made the following setup in my NT init.ora file
    however the last log archive format is commented.

    Do I have to uncomment It ?

    Initially log_archive_start was false and no destination directories. These are added by me.
    I have to ask after setting database into archivemode
    and enabling the automatic archival.

    log_archive_start = true
    log_archive_dest_1 = "location=D:\Oracle\oradata\mdb\archive"
    log_archive_dest_2 = "location=G:\oradata\marchive"
    log_archive_dest_3 = "location=H:\oradata\marchive"
    # log_archive_format = %%ORACLE_SID%%T%TS%S.ARC

    I my Linux machine with 8.1.5 in init file there is nothing mentioned about 'log archive start ' parameter.
    Do I have to write code above in the similar manner in linux oracle parameter as well

    Amol

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    yes you need to add log_archive_start in NT as well because by default it is set to false.
    There is a default format so log_archive_format is not essential to specify a value.

  3. #3
    Join Date
    Dec 2000
    Posts
    1
    [QUOTE][i]Originally posted by amolik [/i]
    [B]Hello

    I have made the following setup in my NT init.ora file
    however the last log archive format is commented.

    Do I have to uncomment It ?

    Initially log_archive_start was false and no destination directories. These are added by me.
    I have to ask after setting database into archivemode
    and enabling the automatic archival.

    log_archive_start = true
    log_archive_dest_1 = "location=D:\Oracle\oradata\mdb\archive"
    log_archive_dest_2 = "location=G:\oradata\marchive"
    log_archive_dest_3 = "location=H:\oradata\marchive"
    # log_archive_format = %%ORACLE_SID%%T%TS%S.ARC

    I my Linux machine with 8.1.5 in init file there is nothing mentioned about 'log archive start ' parameter.
    Do I have to write code above in the similar manner in linux oracle parameter as well

    Amol [/B][/QUOTE]

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