配置RAC (ASM) + DATA GUARD (FILE SYSTEM)+ 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?????????? 12SQL 1 修改数据库为归档模式(RAC 环境)?1. 停止数据库 ?? srvctl stop database -d ORCLA?2. 第一个实例启动到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牋牋牋牋?9bytesRedo Buffers牋牋牋牋牋牋牋bytesDatabase mounted.SQL alter database archivelog; Database altered. SQL alter database open; Database altered.牋牋3. 启动第二个实例??[oracle@rac1 ~]$ srvctl start instance -d racdb -i racdb2?????????????? [oracle@rac1 ~]$ srvctl start service -d racdb -s testdb??? [oracle@rac1 ~]$ crs_stat -t 二: 检查是否为 force logging . 1.SQL select inst_id , force_logging from gv$database; ?? INST_ID FOR---------- ---???????? 1 NO???????? 2 NO 2. 修改数据库为 force logging?SQL alter database force logging; Database altered.??? note : 只需要在一个instance 执行即可. 三． 修改参数 1． Create pfile from spfile; orcla1.__db_cache_size=390070272 orcla2.__db_cache_size=390070272 orcla1.__java_pool_size=4194304 orcla2.__java_pool_size=4194304 orcla1.__large_pool_size=4194304 orcla2.__large_pool_size=4194304 orcla1.__shared_pool_size=205520896 orcla2.__shared_pool_size=205520896 orcla1.__streams_pool_size=0 orcla2.__streams_pool_size=0 *.audit_file_dest=C:\oracle\product\10.2