Shulou(Shulou.com)05/31 Report--

It is believed that many inexperienced people don't know what to do about how to open archiving in oracle rac environment. Therefore, this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Oracle rac archiving settings need not be as simple as single instance settings, and some details need to be paid attention to in the enabling process.

Archiving opens the mind:

1: check whether archiving is enabled in the database

2: create a shared directory (archives must be placed on shared storage)

3: set rac to single instance mode

4: close each node instance separately

5: start one of the nodes to the mount state, open the archive, set the archive path, format, and open the database to restore the rac mode

6: open all node databases

7: check whether the database archive parameter settings are in effect

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

1. Query and archive current information

SQL > show parameter recoveryNAME TYPE VALUE-- db_recovery_file_dest stringdb_recovery_file_dest_size Big integer 0recovery_parallelism integer 0

2. Query whether to open an account and archive logs.

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 36Current log sequence 36

Description: archive mode has been started from the current query, but the path is not correct and needs to be modified.

3. Query cluster parameters

SQL > show parameter clusterNAME TYPE VALUE-- cluster_database boolean TRUEcluster_database_instances integer 2cluster_interconnects string

4. Close another node database

SQL > shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.

5. Modify the cluster to single node mode on the current normal node.

SQL > alter system set cluster_database=false scope=spfile;System altered.

6. Configure flashback size

SQL > alter system set db_recovery_file_dest_size=2G scope=both;System altered.

7. Configure the archive log path, which is configured in 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. Launch the current node database to the mount state to modify the archive

SQL > startup mountORACLE instance started.Total System Global Area 784998400 bytesFixed Size 2257352 bytesVariable Size 331353656 bytesDatabase Buffers 448790528 bytesRedo Buffers 259864 bytesDatabase mounted.

10. Query what state the current database is in

SQL > select status from v$instance 2; STATUS-MOUNTED

11. Modify database archive

SQL > alter database archivelog;Database altered.

twelve。 Restore a database two-node instance

SQL > alter system set cluster_database=true scope=spfile;System altered.

13. Open the database

SQL > alter database open;Database altered.

14. Query the current database status

SQL > select status from vastness instance

15. Query database cluster status

SQL > show parameter clusterNAME TYPE VALUE-- cluster_database boolean TRUEcluster_database_instances integer 2cluster_interconnects string

16. Start another node

Startup

17. Switch archive logs to determine whether the switch is successful or not

SQL > alter system switch logfile;System altered.

18. Query archived data

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. After reading the above content, 269.946544929thread_2_seq_4.259.946542029thread_2_seq_5.263.946543265thread_2_seq_6.268.946543277 Have you mastered how to open archiving in oracle rac environment? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.