Oracle 数据库归档配置-9i,10g,11g

  本月帮客户9i 数据库从Solaris 5.8 迁移到 AIX 平台，并配置RAC ，设置归档，所以将Oracle 9i,10g,11g 数据库设置归档的方法一并记录于此。

Oracle RAC 归档配置：

9i:
    ALTER SYSTEM SET log_archive_start=TRUE SCOPE=spfile;

    ALTER SYSTEM SET log_archive_dest_1='location=/u01/oradata/LIS/archive/' SCOPE=spfile;
      ---各节点路径一致则同意命名，不一致在log_archive_dest_1 前加上SID.
          ALTER SYSTEM SET LIS1.log_archive_dest_1='location=/u01/oradata/LIS/archive/' SCOPE=spfile;
          ALTER SYSTEM SET LIS2.log_archive_dest_1='location=/u01/oradata/LIS/archive/' SCOPE=spfile;

    ALTER SYSTEM SET log_archive_format='arch_%t_%s.arc' SCOPE=spfile;


      ALTER SYSTEM SET cluster_database=FALSE SCOPE=spfile;
  
      $ srvctl stop database -d LIS
  
        STARTUP MOUNT;
        ARCHIVE LOG START;
        ALTER DATABASE ARCHIVELOG;
        ALTER SYSTEM SET cluster_database=TRUE SCOPE=spfile;
        SHUTDOWN IMMEDIATE;

      $ srvctl start database -d LIS

10g:
        ALTER SYSTEM SET log_archive_dest_1='location=/u01/oradata/LIS/archive/' SCOPE=spfile;
          ---各节点路径一致则同意命名，不一致在log_archive_dest_1 前加上SID.
               ALTER SYSTEM SET LIS1.log_archive_dest_1='location=/u01/oradata/LIS/archive/' SCOPE=spfile;
               ALTER SYSTEM SET LIS2.log_archive_dest_1='location=/u01/oradata/LIS/archive/' SCOPE=spfile;

        ALTER SYSTEM SET log_archive_format='arch_%t_%s_%r.arc' SCOPE=spfile;

        ALTER SYSTEM SET cluster_database=FALSE SCOPE=spfile;

        $ srvctl stop database -d LIS

        STARTUP MOUNT;
        ALTER DATABASE ARCHIVELOG;
        ALTER SYSTEM SET cluster_database=TRUE SCOPE=spfile;
        SHUTDOWN IMMEDIATE;
        
        $ srvctl start database -d LIS

11g:

     ALTER SYSTEM SET log_archive_dest_1='location=/u01/oradata/LIS/archive/' SCOPE=spfile;
        ---各节点路径一致则同意命名，不一致在log_archive_dest_1 前加上SID.
            ALTER SYSTEM SET LIS1.log_archive_dest_1='location=/u01/oradata/LIS/archive/' SCOPE=spfile;
            ALTER SYSTEM SET LIS2.log_archive_dest_1='location=/u01/oradata/LIS/archive/' SCOPE=spfile;

        ALTER SYSTEM SET log_archive_format='arch_%t_%s_%r.arc' SCOPE=spfile;

        $ srvctl stop database -d LIS

        STARTUP MOUNT;
         ALTER DATABASE ARCHIVELOG;
        SHUTDOWN IMMEDIATE;
        
      $ srvctl start database -d LIS

相对9i 最麻烦，11g 最简便。如果使用ASM 作为归档的路径 则将 '/u01......' 改为 ’+FRA'(disk group name) 就行。

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

转载于:http://blog.itpub.net/34596/viewspace-1716157/