ITPub博客

首页 > IT基础架构 > 网络安全 > Enabling Archive Logs in a RAC Environment

Enabling Archive Logs in a RAC Environment

原创 网络安全 作者:maojinyu 时间:2011-01-04 11:00:19 0 删除 编辑
  1. Login to one of the nodes (i.e. racnode1) and disable the cluster instance parameter by setting cluster_database to FALSE from the current instance:


    $ sqlplus "/ as sysdba"
    SQL> alter system set cluster_database=false scope=spfile sid='racdb1';

  2. Shutdown all instances accessing the clustered database:


    $ srvctl stop database -d racdb

  3. Using the local instance, MOUNT the database:


    $ sqlplus "/ as sysdba"
    SQL> startup mount

  4. Enable archiving:


    SQL> alter database archivelog;

  5. Re-enable support for clustering by modifying the instance parameter cluster_database to TRUE from the current instance:


    SQL> alter system set cluster_database=true scope=spfile sid='racdb1';

  6. Shutdown the local instance:


    SQL> shutdown immediate

  7. Bring all instance back up using srvctl:


    $ srvctl start database -d racdb

  8. (Optional) Bring any services (i.e. TAF) back up using srvctl:


    $ srvctl start service -d racdb

  9. Login to the local instance and verify Archive Log Mode is enabled:


    $ sqlplus "/ as sysdba"
    SQL> archive log list
    Database log mode Archive Mode
    Automatic archival Enabled
    Archive destination USE_DB_RECOVERY_FILE_DEST
    Oldest online log sequence 83
    Next log sequence to archive 84
    Current log sequence 84

After enabling Archive Log Mode, each instance in the RAC configuration can automatically archive redologs!

[@more@]

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

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

注册时间:2012-05-09

  • 博文量
    178
  • 访问量
    376683