How to enable archiving in an Oracle RAC environment

Oracle RAC Archive settings need to be less simple than single-instance setup, with some details to be noticed during the open process

Archive Open Ideas:

1: See if the database is open for archiving

2: Create a shared directory (archive must be placed on shared storage)

3: Set RAC to single-instance mode

4: Close individual node instances individually

5: Boot One of the nodes into the Mount State, open the archive, set the archive path, format, and open the database restore RAC mode

6: Open All nodes Database

7: See if Database archive parameter settings are in effect

8: Switch archive to see if the archive is working properly

1. Query Archive Current Information

Sql> Show parameter Recoveryname TYPE VALUE-------------------------------------------------- ---------------------------db_recovery_file_dest stringdb_recovery_file_dest_size Big integer 0recover Y_parallelism integer 0

2, inquire whether to open an account archive log

Sql> Archive Log listdatabase log mode archive modeautomatic archival enabledarchive destination /oracle/app/oracle/product/11.2.0/db_1/dbs/archoldest Online log sequence 35Next log sequence to archive 36C urrent Log Sequence 36

Description: From the current query is the archive mode has started, but the specified path is not to be re-modified

3. Query Cluster parameters

Sql> Show parameter clustername TYPE VALUE--------------------------------------------------- --------------------------cluster_database boolean truecluster_database_instances integer 2clu Ster_interconnects string

4. Close another node database

sql> shutdown immediatedatabase closed. Database dismounted. ORACLE instance shut down.

5, in the current normal node to modify the cluster as a single node mode

Sql> alter system set CLUSTER_DATABASE=FALSE Scope=spfile; System altered.

6. Configure the Flash back size

Sql> alter system set DB_RECOVERY_FILE_DEST_SIZE=2G Scope=both; System altered.

7, configure the archive log path, configured in the DG

Sql> alter system set db_recovery_file_dest= ' +dgrecovery ' Scope=both; System altered.

8. Close the current node database

sql> shutdown immediatedatabase closed. Database dismounted. ORACLE instance shut down.

9. Modify the archive by booting the current node database into the Mount state

Sql> Startup Mountoracle instance started.  Total System Global area 784998400 bytesfixed size 2257352 bytesvariable size 331353656 bytesdatabase Buffers 448790528 Bytesredo buffers 2596864 bytesdatabase mounted.

10. Querying what state the current database is in

Sql> Select status from V$instance 2; STATUS------------Mounted

11. Modify the Database archive

sql> ALTER DATABASE Archivelog;database altered.

12. Restoring a two-node instance of a database

Sql> alter system set CLUSTER_DATABASE=TRUE Scope=spfile; System altered.

13. Open the Database

sql> ALTER DATABASE Open;database altered.

14. Querying the current database state

Sql> select status from V$instance; STATUS------------OPEN

15. Querying the Database cluster status

Sql> Show parameter clustername TYPE VALUE--------------------------------------------------- --------------------------cluster_database boolean truecluster_database_instances integer 2clu Ster_interconnects string

16. Start another node

Startup

17. Switch the archive log to determine if the switch is successful.

sql> alter system switch logfile; System altered.

18, query the data in the archive

Asmcmd> pwd+dgrecovery/rac/archivelog/2017_06_13asmcmd> Lsthread_1_seq_37.256.946542069thread_1_seq_ 38.257.946542129thread_1_seq_39.258.946542133thread_1_seq_40.260.946542135thread_1_seq_41.261.946543367thread_ 1_seq_42.262.946543369thread_1_seq_43.264.946543373thread_1_seq_44.265.946543375thread_1_seq_ 45.266.946543377thread_1_seq_46.267.946543377thread_1_seq_47.269.946544929thread_2_seq_4.259.946542029thread_2 _seq_5.263.946543265thread_2_seq_6.268.946543277

The above can be used to determine the database can be properly archived

This article is from the "My main beam margin" blog, please be sure to keep this source http://xiaocao13140.blog.51cto.com/6198256/1936847

How to enable archiving in an Oracle RAC environment