Tuesday, 31 December 2013

multiple archive log destination

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Jan 8 23:41:50 2010

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> conn /as sysdba;
Connected.

SQL>



SQL> alter system set log_archive_dest_1="location=/archive1" ;

System altered.

SQL> alter system set log_archive_dest_2="service=standby_db1" ;

System altered.

SQL> alter system set log_archive_dest_1="location=archive/mandatory reopen";

System altered.

SQL> alter system set log_archive_dest_2="service=standby_db1/mandatory reopen=6
00" ;

System altered.

SQL> alter system set log_archive_dest_3="location=archive/optional"
  2  ;

System altered.

SQL> alter system set log_archive_min_succeed_dest=2;

System altered.

============================================================

control archive to a destination

============================================

SQL> alter system set log_archive_dest_state_2=defer;

System altered.

SQL> alter system set log_archive_dest_state_2=enable;

System altered.

SQL>

===================================
archive log information

===============================

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            archive/optional
Oldest online log sequence     6
Next log sequence to archive   8
Current log sequence           8


SQL>

No comments:

Post a Comment