SQL> show parameter log_archive_dest_31
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_31 string
So. read more:
- If configured, each LOG_ARCHIVE_DEST_1 through LOG_ARCHIVE_DEST_10 destination must contain either a LOCATION or SERVICE attribute to specify a local disk directory or a remotely accessed database, respectively. Each LOG_ARCHIVE_DEST_11 through LOG_ARCHIVE_DEST_31 destination must contain a SERVICE attribute.
- LOG_ARCHIVE_DEST_11 through LOG_ARCHIVE_DEST_31 cannot be specified as an ALTERNATE redo transport location.
- LOG_ARCHIVE_DEST_11 through LOG_ARCHIVE_DEST_31 can only be used when the COMPATIBLE initialization parameter is set to 11.2.0.0 or later.
SQL> alter system set log_archive_dest_6='location=+disk02'
System altered.
SQL> alter system set log_archive_dest_11='location=+disk02'
alter system set log_archive_dest_11='location=+disk01'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16025: parameter LOG_ARCHIVE_DEST_11 contains repeated or conflicting attributes
1 comment:
Hi
The log_archive_dest_n from 1 to 31 is for increased avalibility using standby database. With 11G you can have up to 30 standby database where in 10g you can have up to 10 standby databases for a single primary database.
Post a Comment