Oracle RAC 11g Modify Open Archive and modify archive log path

1. Modify the archive Path parameter

Sqlplus/as SYSDBA

Sql> alter system set log_archive_dest_1= ' Location=+asmarch ' scope=spfile sid= ' * ';

2. Close the database and all nodes are closed

Srvctl Stop database-d racdb

3. Boot a node database to mount State 5 and modify the database's archive mode and start the database

Srvctl start instance-d racdb-i racdb2-o Mount

sql> ALTER DATABASE Archivelog;

sql> ALTER DATABASE open;

4. Start another database of nodes

Srvctl Start instance-d racdb-i racdb1

Oracle RAC 11g Modify Open Archive and modify archive log path