OCM_Session8_1_PreparingthePrimaryDatabaseforStandbyDatabaseCreation - 数据库编程

3 2001 initdw.ora -rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora -rw-r--r-- 1 oracle oinstall 658 Mar 18 10:09 initPROD.ora -rw-rw---- 1 oracle oinstall 24 Mar 18 10:18 lkPROD -rw-r----- 1 oracle oinstall 5120 Mar 18 09:54 orapwPROD -rw-r--r-- 1 oracle oinstall 318 Mar 17 20:37 pfile.ora -rw-r----- 1 oracle oinstall 6832128 Mar 19 19:51 snapcf_PROD.f -rw-r----- 1 oracle oinstall 3584 Mar 25 08:54 spfilePROD.ora
如果没有需要重新创建，使用以下语句： [oracle@ocm1 dbs]$ orapwd file=orapwPROD password=oracle
1.3配置Standby Redo Log a.standby logfile是备库组件，当成为备库时用来接收来自主库的redo日志内容; b.添加standby logfile大小需要与logfile 大小保持一致，数量最好n+1用于日志缓冲;
①查看主库的日志组和日志成员 主库有5组日志，每组2个成员，文件大小为100M
SYS@PROD>select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- 1 1 9 104857600 2 YES INACTIVE 270814 25-MAR-14 2 1 10 104857600 2 YES INACTIVE 291251 25-MAR-14 3 1 11 104857600 2 NO CURRENT 311895 25-MAR-14 4 1 7 104857600 2 YES INACTIVE 238268 19-MAR-14 5 1 8 104857600 2 YES INACTIVE 244809 19-MAR-14
SYS@PROD>select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_ ---------- ------- ------- -------------------------------------------------- --- 1 STALE ONLINE /u01/app/oracle/oradata/PROD/Disk1/redo01.log NO 2 STALE ONLINE /u01/app/oracle/oradata/PROD/Disk1/redo02.log NO 3 ONLINE /u01/app/oracle/oradata/PROD/Disk1/redo03.log NO 1 STALE ONLINE /u01/app/oracle/oradata/PROD/Disk2/redo01_1.log NO 2 STALE ONLINE /u01/app/oracle/oradata/PROD/Disk2/redo02_1.log NO 3 ONLINE /u01/app/oracle/oradata/PROD/Disk2/redo03_1.log NO 4 ONLINE /u01/app/oracle/oradata/PROD/Disk1/redo04.log NO 4 ONLINE /u01/app/oracle/oradata/PROD/Disk2/redo04_1.log NO 5 STALE ONLINE /u01/app/oracle/oradata/PROD/Disk1/redo05.log NO 5 STALE ONLINE /u01/app/oracle/oradata/PROD/Disk2/redo05_1.log NO
10 rows selected.
②即添加6组standby logfile
SYS@PROD>alter database add standby logfile group 6 ('/u01/app/oracle/oradata/PROD/Disk1/standby06.log','/u01/app/oracle/oradata/PROD/Disk2/standby06_1.log') size 100m;
Database altered.

SYS@PROD>alter database add standby logfile group 7('/u01/app/oracle/oradata/PROD/Disk1/standby07.log','/u01/app/oracle/oradata/PROD/Disk2/standby07_1.log') size 100m;
Database altered.
SYS@PROD>alter database add standby logfile group 8 ('/u01/app/oracle/oradata/PROD/Disk1/standby08.log','/u01/app/oracle/oradata/PROD/Disk2/standby08_1.log') size 100m;
Database altered.
SYS@PROD>alter database add standby logfile group 9('/u01/app/oracle/oradata/PROD/Disk1/standby09.log','/u01/app/oracle/oradata/PROD/Disk2/standby09_1.log') size 100m;
Database altered.
SYS@PROD>alter database add standby logfile group 10 ('/u01/app/oracle/oradata/PROD/Disk1/standby10.log','/u01/app/oracle/oradata/PROD/Disk2/standby10_1.log') size 100m;
Database altered.
SYS@PROD>alter database add standby logfile group 11 ('/u01/app/oracle/oradata/PROD/Disk1/standby11.log','/u01/app/oracle/oradata/PROD/Disk2/standby11_1.log') size 100m;
Database altered.
SYS@PROD>select * from v$standby_log;
GROUP# DBID THREAD# SEQUENCE# BYTES USED ARC STATUS FIRST_CHANGE# FIRST_TIM LAST_CHANGE# LAST_TIME ---------- ---------------------------------------- ---------- ---------- ---------- ---------- ---

OCM_Session8_1_PreparingthePrimaryDatabaseforStandbyDatabaseCreation(二)