-
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
-
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.
-
[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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|