Sql>alter system set log_archive_dest= ' +lwk/archivelog ' scope=spfile sid= ' * ';
Then close two instances, launch the instance, change the database to archive mode:
Sql>shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
Sql>startup Mount;
ORACLE instance started.
Total System Global area 1258291200 bytes
Fixed Size 1978336 bytes
Variable Size 352325664 bytes
Database buffers 889192448 bytes
Redo buffers 14794752 bytes
Database mounted.
Sql>alter database Archivelog;
Database altered.
Sql>alter database open;
Sql>archive log list;
Database Log Mode Archive mode
Automatic Archival Enabled
Archive destination/opt/oracle/archive
Oldest online log sequence 83
Next Log sequence to archive 84
Current Log Sequence 84
Next, start another node to complete the change process for the archive mode.
in a RAC Environment, the choice of archive path is worth considering, and if you use a shared archive directory as the archive path, you can reduce the complexity of the backup. If you use a separate directory, special handling is required for backup.
This article is from the "Li_weikang" blog, make sure to keep this source http://liweikang.blog.51cto.com/3246878/1872765
Oracle RAC Change Archive directory