ORACLE10G RAC 环境搭建物理 DATA GUARD.docx

ORACLE10G RAC 环境搭建物理 DATA GUARD 一. 检查数据库要处于归档模式. SQL archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 11 Current log sequence 12 SQL 1 修改数据库为归档模式(RAC 环境) 停止数据库 srvctl stop database -d racdb 第一个实例启动到 mount 状态. srvctl start instance -d racdb -i racdb1 shutdown immediate; startup mount; SQL archive log list Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 11 Current log sequence 12 SQL shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL startup mount ORACLE instance started. Total System Global Area 1224736768 bytes Fixed Size 2072352 bytes Variable Size 285212896 bytes Database Buffers 922746880 bytes Redo Buffersbytes Database mounted. SQL alter database archivelog; Database altered. SQL alter database open; Database altered. 启动第二个实例 [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 NO NO 2. 修改数据库为 force logging SQL alter database force logging; Database altered. note : 只需要在一个 instance 执行即可. 三: 1 rman full backup RMAN backup full database tag dbfull format /app/temp/dbfull_%u_%s_%p; Starting backup at 30-JUN-08 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=519 instance=racdb1 devtype=DISK channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fno=00003 name=+DG1/racdb/datafile/sysaux.257.657295195 input datafile fno=00004 name=+DG1/racdb/datafile/users.259.657295199 input datafile fno=00001 name=+DG1/racdb/datafile/system.256.657295195 input datafile fno=00002 name=+DG1/racdb/datafile/undotbs1.258.657295197 input datafile fno=00005 name=+DG1/racdb/datafile/undotbs2.264.65