oracle 11g RAC : mengubah menjadi mode archive log

23 Sep

oracle 11g RAC : mengubah menjadi mode archive log

a. apakah database Instance masih hidup ?
[oracle@node1 ~]$ srvctl status database -d node
Instance node1 is running on node node1
Instance node2 is running on node node2

b. matikan database Instance
[oracle@node1 ~]$ srvctl stop database -d node

c. Menyiapkan salah satu database instance agar diset menjadi mode archive log, dengan mengirimkan perintah instance mount
[oracle@node1 ~]$ srvctl start instance -d node -i node1 -o mount
[oracle@node1 ~]$ srvctl status database -d node
Instance node1 is running on node node1
Instance node2 is not running on node node2

[oracle@node1 ~]$ sqlplus / as sysdba
SQL> alter database archivelog;
Database altered.

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +DATA1
Oldest online log sequence 3
Current log sequence 4
SQL> exit

d. restart database instance
[oracle@node1 ~]$ srvctl stop instance -d node -i node1
[oracle@node1 ~]$ srvctl start database -d node
[oracle@node1 ~]$ srvctl status database -d node
Instance node1 is running on node node1
Instance node2 is running on node node2

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: