Change archive mode

Change archive mode

1. The HA orSINGLEmode,Changetothearchivemode (Please freeze the cluster)

$ sqlplus '/ as sysdba'

SQL> show parameter  spfile;

NAME                                 TYPE        VALUE

----------------------------------------------- ------------------------------

spfile                               string      +DISKGROUP2/ora11g/spfileora11g.ora

SQL>alter system set log_archive_format='arch_%r_%t_%s.dbf' scope=spfile sid='*';

SQL>alter system set log_archive_start=TRUE scope=spfile sid='*';

SQL>alter system set log_archive_dest_1='LOCATION=/archive' scope=both sid='*';

SQL>shutdown immediate;

SQL>startup mount;

SQL>alter database archivelog;

SQL>alter database open;

SQL>archive log list;

Databaselogmode              ArchiveMode

 

2. The RAC mode,Changetothearchivemode

2.1. Inthe node1:

SQL> show parameter  spfile;

NAME                                 TYPE        VALUE

----------------------------------------------- ------------------------------

spfile                               string      +DISKGROUP2/ora11g/spfileora11g.ora

SQL>alter system set cluster_database=false scope=spfile sid='*';

SQL>alter system set log_archive_format='arch_%r_%t_%s.dbf' scope=spfile sid='*';

SQL> alter system set log_archive_dest_1='LOCATION=/archive' scope=both sid='*';

--- Or SQL>alter system set log_archive_dest_1='LOCATION=+DG_ARCH' scope=both sid='*';

2.2. Shutdowndatabaseinall nodes.

SQL>shutdown immediate;

2.3. Inthe node1:

SQL>startup mount;

SQL>alter database archivelog;

SQL>alter database open;

SQL>alter system set cluster_database=true scope=spfile sid='*';

SQL> shutdown immediate;

2.4. Startup databaseinall nodes.

SQL>startup;

SQL>archive log list;

Databaselogmode              ArchiveMode

LOG_ARCHIVE_STARTparameter is deprecated in Oracle 10g.

Above the ORACLE10g,

Check theautomatic archive:

SQL>select log_mode from v$database