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>
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