配置RAC(ASM)+DATAGUARD(FILESYSTEM)+RMAN建库

《配置RAC(ASM)+DATAGUARD(FILESYSTEM)+RMAN建库》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、配置RAC(ASM)+DATAGUARD(FILESYSTEM)+RMAN建库一.检查数据库要处于归档模式.SQL>archiveloglist;Databaselogmode             NoArchiveModeAutomaticarchival            DisabledArchivedestination           USE_DB_RECOVERY_FILE_DESTOldestonlinelogsequence    11Currentlogsequence          12SQL>1>修改数据库为归档模式(RAC环境) 1.停止数据库  s

2、rvctlstopdatabase-dORCLA 2.第一个实例启动到mount状态.   srvctlstartinstance-dORCLA-iORCLA1      shutdownimmediate;   startupmount;SQL>archiveloglistDatabaselogmode             NoArchiveModeAutomaticarchival            DisabledArchivedestination           USE_DB_RECOVERY_FILE_DESTOldestonlinelogsequence    1

3、1Currentlogsequence          12SQL>shutdownimmediate;Databaseclosed.Databasedismounted.ORACLEinstanceshutdown.SQL>startupmountORACLEinstancestarted.TotalSystemGlobalArea1224736768bytesFixedSize                 2072352bytesVariableSize            285212896bytesDatabaseBuffers         922746880bytes

4、RedoBuffers              14704640bytesDatabasemounted.SQL>alterdatabasearchivelog;Databasealtered.SQL>alterdatabaseopen;Databasealtered.    3.启动第二个实例  [oracle@rac1~]$srvctlstartinstance-dracdb-iracdb2              [oracle@rac1~]$srvctlstartservice-dracdb-stestdb   [oracle@rac1~]$crs_stat-t二:检查是否为f

5、orcelogging.1.SQL>selectinst_id,force_loggingfromgv$database;  INST_IDFOR-------------        1NO        2NO2.修改数据库为forcelogging SQL>alterdatabaseforcelogging;Databasealtered.   note:只需要在一个instance执行即可.三．修改参数1．Createpfilefromspfile;orcla1.__db_cache_size=390070272orcla2.__db_cache_size=390070272or

6、cla1.__java_pool_size=4194304orcla2.__java_pool_size=4194304orcla1.__large_pool_size=4194304orcla2.__large_pool_size=4194304orcla1.__shared_pool_size=205520896orcla2.__shared_pool_size=205520896orcla1.__streams_pool_size=0orcla2.__streams_pool_size=0*.audit_file_dest='C:oracleproduct10.2.0/admi

7、n/orcla/adump'*.background_dump_dest='C:oracleproduct10.2.0/admin/orcla/bdump'*.cluster_database_instances=2*.cluster_database=true*.compatible='10.2.0.1.0'*.control_files='+ASM/orcla/controlfile/current.260.7