Oralce 10g rac archive Mode Modification

I have been trying to modify the rac archive mode for the past few days, but I have not done it. I have been referring to the following documents and added some operations this morning. The change was successful, it is intended to solve this problem in the future, where the red font is self-operated on the local machine.

1. Check whether the node is in archive mode.
SQL> archive log list;

Database log mode No Archive Mode
Automatic archival Disabled
Archive destination/Oracle/product/database/dbs/arch
Oldest online log sequence 3
Current log sequence 4

2. view and modify cluster_database Parameters

SQL> show parameter cluster_database;

NAME TYPE VALUE
--------------------------
Cluster_database boolean TRUE <---Set this parameter to false.
Cluster_database_instances integer 2
2.1 run the following commandNodeThe cluster_database parameter of is false.

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

Note: * represents the sid of the Local Machine
3. Disable instances on each node
SQL> shutdown immediate;<-- RAC1
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> shutdown immediate;<-RAC2
Database closed.
Database dismounted.
ORACLE instance shut down.

4.Start one of the nodes to the mount status. Take RAC1 as an example.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 281018368 bytes
Fixed Size 1267044 bytes
Variable Size 113248924 bytes
Database Buffers 163577856 bytes
Redo Buffers 2924544 bytes
SQL> alter database mount;

Database altered.

5. Modify the archive mode and

SQL>Alter database archivelog; ---> I often forget this command.

Database altered.
6. Put the database in the open state

SQL> alter database open;

Database altered.

6.1 specify the archiving target

SQL> alter system set LOG_ARCHIVE_DEST_1 = 'location =/archive ';

System altered.

Note: If the specified directory needs to be created by the root user and chown-R oracle: dba/archive, I will create this directory on two nodes respectively,

After this parameter is specified, switch the log to the directory to generate the corresponding file. (Alter system switch logfile ;)

7. Check that the cluster_database parameter is false.

SQL> show parameter cluster_database;

NAME TYPE VALUE
--------------------------
Cluster_database boolean FALSE
Cluster_database_instances integer 1
7.1 if another node is started, an error is reported.

SQL> startup nomount;-> If the RAC2 node is set to nomount or startup, an error is reported, as shown in the following figure:
ORA-29707: inconsistent value 2 for initialization parameter
Cluster_database_instances with other instances

1 2 Next Page