Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how use the templater attribute in log_archive_dest_n parameter

user5858147Jan 13 2010 — edited Jan 13 2010
hi
i meet this error

alter system set log_archive_dest_2='location=/arch/arch_f_s template=source_%t_%s_%r.dbf valid_for=(standby_logfile,primary_role)' scope=both
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting
attributes
ORA-16154: suspect attribute: TEMPLATE

what's wrong ?

other parameter

log_archive_format string %t_%s_%r.dbf
log_archive_dest_1 string location=/arch mandatory reopen=5 valid_for=(online_logfile,primary_role)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 10 2010
Added on Jan 13 2010
3 comments
387 views