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

配置RAC (ASM) + DATA GUARD (FILE SYSTEM)+ RMAN建库一. 检查数据库要处于归档模式.SQL archive log list;Database log mode No Archive ModeAutomatic archival DisabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 11Current log sequence 12SQL1 修改数据库为归档模式(RAC 环境)1. 停止数据库 srvctl stop database -d ORCLA2. 第一个实例启动到mount 状态. srvctl start instance -d ORCLA -i ORCLA1 shutdown immediate; startup mount;SQL archive log listDatabase log mode No Archive ModeAutomatic archival DisabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 11Current log sequence 12SQL shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL startup mountORACLE instance started.Total System Global Area 1224736768 bytesFixed Size 2072352 bytesVariable Size 285212896 bytesDatabase Buffers 922746880 bytesRedo Buffers 14704640 bytesDatabase mounted.SQL alter database archivelog;Database altered.SQL alter database open;Database altered.3. 启动第二个实例oraclerac1 $ srvctl start instance -d racdb -i racdb2 oraclerac1 $ srvctl start service -d racdb -s testdb oraclerac1 $ crs_stat -t二: 检查是否为 force logging .1.SQL select inst_id , force_logging from gv$database; INST_ID FOR- - 1 NO 2 NO2. 修改数据库为 force loggingSQL alter database force logging;Database altered. note : 只需要在一个instance 执行即可.三 修改参数1 Create pfile from spfile;orcla1._db_cache_size=390070272orcla2._db_cache_size=390070272orcla1._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/admin/orcla/adump*.background_dump_dest=C:oracleproduct10.2.0/admin/orcla/bdump*.cluster_database_instances=2*.cluster_database=true*.compatible=.0*.control_files=+ASM/orcla/controlfile/current.260.733500285*.core_dump_dest=C:oracleproduct10.2.0/admin/orcla/cdump*.db_block_size=8192*.db_create_file_dest=+ASM*.db_domain=*.db_file_multiblock_read_count=16*.db_name=orcla*.dispatchers=(PROTOCOL=TCP) (SERVICE=orclaXDB)orcla1.instance_number=1orcla2.instance_number=2*.job_queue_processes=10*.nls_language=SIMPLIFIED CHINESE*.nls_territory=CHINA*.open_cursors=300*.pga_aggregate_target=203423744*.processes=150*.remote_listener=LISTENERS_ORCLA*.remote_login_passwordfile=exclusive*.sga_target=612368384orcla2.thread=2orcla1.thread=1*.undo_management=AUTOorcla1.undo_tablespace=UNDOTBS1orcla2.undo_tablespace=UNDOTBS2*.user_dump_dest=C:oracleproduct10.2.0/admin/orcla/udump*.log_archive_config=dg_config=(orcla,orcldg)*.db_unique_name=orcla*.log_archive_dest_1=location=+asmorclaarch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcla*.log_archive_dest_2=service=orcldg lgwr async VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcldg*.log_archive_dest_state_1=enable*.log_archive_dest_state_2=enable*.LOG_ARCHIVE_FORMAT=%t_%s_%r.arc*.log_archive_max_processes=1*.fal_client=orcla1,orcla2*.fal_server=orcldg*.DB_FILE_NAME_CONVERT=+ASM/ORCLA/datafile,C:oracleproduct10.2.0oradataorcldg *.LOG_FILE_NAME_CONVERT=+asm/orcla/onlinelog/,c:oracleproduct10.2.0oradataorcldg,+asm/orcla/arch/,c:oracleproduct10.2.0flash_recovery_areaORCLDGONLINELOG*.standby_file_management=auto2. 使用新参数启动关闭两个实例 shutdown immediate;启动一个 ：startup pfile=c:pfile.ora3. RMAN备份sql alter system archive log current ;backup as compressed backupset full format=c:backupset-%d_%s.bak database include current controlfile for standby plus archivelog ;这里包含了controlfile ，这样恢复最简单！4配置主库tnsnames5. 将密码文件，备份文件拷贝到备库相应的目录（目录不能错）四配置备库1oradim -new -sid orcla (sid要和主库一样)2. 配置主库tnsnames，listenner ，确保tnsping能通。3从主库copy修改pfileorcla._db_cache_size=390070272orcla._java_pool_size=4194304orcla._large_pool_size=4194304orcla._shared_pool_size=205520896orcla._streams_pool_size=0*.audit_file_dest=C:oracleproduct10.2.0/admin/orcldg/adump*.background_dump_dest=C:oracleproduct10.2.0/admin/orcldg/bdump*.compatible=.0*.control_files=C:oracleproduct10.2.0oradataorcldgcontrol01.ctl,C:oracleproduct10.2.0oradataorcldgcontrol02.ctl,C:oracleproduct10.2.0oradataorcldgcontrol03.ctl*.core_dump_dest=C:oracleproduct10.2.0/admin/orcldg/cdump*.db_block_size=8192*.db_create_file_dest=C:oracleproduct10.2.0oradataorcldg*.db_domain=*.db_file_multiblock_read_count=16*.db_name=orcla*.dispatchers=(PROTOCOL=TCP) (SERVICE=orclaXDB)*.job_queue_processes=10*.nls_language=SIMPLIFIED CHINESE*.nls_territory=CHINA*.open_cursors=300*.pga_aggregate_target=203423744*.processes=150*.remote_login_passwordfile=exclusive*.undo_tablespace=UNDOTBS1*.sga_target=612368384*.undo_management=AUTO*.user_dump_dest=C:oracleproduct10.2.0/admin/orcldg/udump*.log_archive_config=dg_config=(orcla,orcldg)*.db_unique_name=orcldg*.log_archive_dest_1=location=c:oracleproduct10.2.0flash_recovery_areaORCLDGONLINELOG VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcldg*.log_archive_dest_2=service=orcla1 lgwr async VALID_FOR=(online_LOGFILES,PRIMARY_ROLES) DB_UNIQUE_NAME=orcla*.log_archive_dest_state_1=enable*.log_archive_dest_state_2=enable*.LOG_ARCHIVE_FORMAT=%t_%s_%r.arc*.log_archive_max_processes=1*.fal_client=orcldg*.fal_server=orcla1,orcla2*.DB_FILE_NAME_CONVERT=+ASM/ORCLA/datafile/,C:oracleproduct10.2.0oradataorcldg *.LOG_FILE_NAME_CONVERT=+asm/orcla/onlinelog/,c:oracleproduct10.2.0oradataorcldg,+asm/orcla/arch/,c:oracleproduct10.2.0flash_recovery_areaORCLDGONLINELOG*.standby_file_management=auto注意： RAC将全部的文件放在ASM上，备库是在文件系统 ，所以要CONVERT，如何在ASM上没对应的目录要