Enable the archive mode and set the archive path for OracleRAC

The parameter file of OracleRAC is different from the parameter file of a single instance. Therefore, when modifying the parameter file, pay attention to it. First, set the archive path: SQLgt; altersystemsetlog_arch.

The parameter file of Oracle RAC is different from the parameter file of a single instance. Therefore, when modifying the parameter file, pay attention to it. First, set the archive path: SQLgt; alter system set log_arch.

The parameter file of Oracle RAC is different from the parameter file of a single instance. Therefore, when modifying the parameter file, pay attention to it.

First, set the archive path:

SQL> alter system set log_archive_dest = '/opt/oracle/archive' scope = spfile sid = '*';

System altered.

SQL> col sid for a10
SQL> col name for a20
SQL> col value for a30
SQL> select sid, name, value from v $ spparameter where name = 'Log _ archive_dest ';

SID NAME VALUE
---------------------
* Log_archive_dest/opt/oracle/archive

Close the two instances, start the instance, and 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;

Database altered.

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 archive mode change process.

In the RAC environment, the selection of the archive path is worth considering. If the shared archive directory is used as the archive path, the complexity of backup can be reduced. If an independent directory is used, special processing is required during Backup.