Oracle 11g mengubah mode Archive

Tahukah anda mengubah mode No Archive Mode menjadi Archive Mode, di RAC ????

Berikut langkah – langkahnya :

1. periksa database dalam mode apa ?
[oracle@rac2 ~]$ sqlplus sys@rac2 as sysdba
SQL*Plus: Release 11.1.0.6.0 – Production on Sat Mar 22 15:53:25 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u01/app/oracle/product/11.1.0/db_1/dbs/arch
Oldest online log sequence 733
Current log sequence 734

2. pada contoh database belum dlm mode archive. Tentukan posisi archive
misal dalam contoh di /u03
SQL> alter system set log_archive_dest_1=’location=/u03′;
System altered.

3. periksa ulang dengan command archive log list
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u03
Oldest online log sequence 733
Current log sequence 734
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release
11.1.0.6.0 – Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

4. matikan instance database dengan perintah srvctl
[oracle@rac2 ~]$ srvctl stop database -d rac

5. mounting salah satu node, dalam contoh ada 2 node rac1 dan rac2,
dimana rac1 di start sedangkan rac2 tidak dengan option startup mount.
[oracle@rac2 ~]$ srvctl start instance -d rac -i rac1 -o mount

6. ubah database menjadi mode archivelog
[oracle@rac2 ~]$ sqlplus sys@rac1 as sysdba
SQL*Plus: Release 11.1.0.6.0 – Production on Sat Mar 22 16:09:56 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> alter database archivelog;
Database altered.

7. periksa mode archive
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u03
Oldest online log sequence 876
Next log sequence to archive 877
Current log sequence 877
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release
11.1.0.6.0 – Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

8. restart instance database
[oracle@rac2 ~]$ srvctl stop database -d rac
[oracle@rac2 ~]$ srvctl sart database -d rac

by Setijo Agus