ITPub博客

首页 > 数据库 > Oracle > RAC数据库启用归档和闪回的步骤

RAC数据库启用归档和闪回的步骤

原创 Oracle 作者:db_wjw 时间:2014-08-17 10:57:07 1 删除 编辑
1、RAC数据库调整为归档模式步骤:
SQL> alter system set cluster_database=false scope=spfile sid='orcl1';
SQL> alter system set db_recovery_file_dest='+ORAFLASH' scope=spfile;
SQL> alter system set db_recovery_file_dest_size=20g scope=spfile;
$ srvctl stop database -d orcl
$ sqlplus / as sysdba;
SQL> startup mount;
SQL> alter database archivelog;
SQL> alter system set cluster_database=true scope=spfile sid='orcl1';
SQL> shutdown immediate;
$ srvctl start database -d orcl
SQL> select name,log_mode,flashback_on from v$database;

2、RAC数据库启动闪回特性步骤:
确认数据已经运行在归档模式中:
SQL> archive log list;
SQL> alter system set cluster_database=false scope=spfile sid='orcl1';
SQL> alter system set db_recovery_file_dest='+ORAFLASH' scope=spfile;
SQL> alter system set db_recovery_file_dest_size=20g scope=spfile;
$ srvctl stop database -d orcl
SQL> startup mount;
SQL> alter database flashback on;
SQL> alter system set cluster_database=true scope=spfile sid='orcl1';
SQL> shutdown immediate;
$ srvctl start database -d orcl
注意:可以根据需要为特定的表空间打开或关闭闪回:
SQL> alter tablespace users flashback on;
SQL> alter tablespace users flashback off;

SQL> select name,log_mode,flashback_on from v$database;

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26194851/viewspace-1252601/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-08-21

  • 博文量
    96
  • 访问量
    506459