oracle rac 归档开启

1、查看数据库是否开启归档SQL> archive log list;

3、将rac设置成单实例模式SQL> show parameter cluster_databaseNAME TYPE VALUE--幻腾寂埒---------------------------------- ----------- ------------------------------cluster_database boolean TRUEcluster_database_instances integer 2在各个节点上都要执行以下命令SQL> alter system set cluster_database=false scope=spfile sid='*';System altered.

5、将其中一个节点启动到mount状态，开启归档，设置归档路径，格式，并打开数据库棵褶佐峨还原rac模式SQL> startup mountSQL> show parameter cluster_database 查看之前设置是否生效SQL> alter database archivelog; 开启归档SQL> alter system set log_archive_format='test_%t_%s_%r.log' scope=spfile; 设置归档格式SQL> alter system set log_archive_start=true scope=spfile;SQL> alter system set log_archive_dest_1='location=+DATADG/arch' scope=spfile;SQL> alter database open;SQL> alter system set cluster_database=true scope=spfile sid='*';SQL> shutdown immediate;归档格式说明：%t 重做线程号%s 日志序列号%r resetlogs的id号

7、查看数据库归档参数设置是否生效SQL> archive log list;