Oracle Data Guard 10g 10205:RAC –> Standby
前提:
1. 主库:Oracle RAC 10g
2. 备库:Oracle DB 10g 10205
主库:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 |
[root@rac2 ~]# su - grid [grid@rac2 ~]$ [grid@rac2 ~]$ crs_stat -t -v Name Type R/RA F/FT Target State Host ---------------------------------------------------------------------- ora....SM1.asm application 0/5 0/0 ONLINE ONLINE rac1 ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1 ora.rac1.gsd application 0/5 0/0 ONLINE ONLINE rac1 ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1 ora.rac1.vip application 0/0 0/0 ONLINE ONLINE rac1 ora....SM2.asm application 0/5 0/0 ONLINE ONLINE rac2 ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2 ora.rac2.gsd application 0/5 0/0 ONLINE ONLINE rac2 ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2 ora.rac2.vip application 0/0 0/0 ONLINE ONLINE rac2 ora.zona.db application 0/1 0/1 ONLINE ONLINE rac2 ora....a1.inst application 0/5 0/0 ONLINE ONLINE rac1 ora....a2.inst application 0/5 0/0 ONLINE ONLINE rac2 [grid@rac2 ~]$ [grid@rac2 ~]$ exit logout [root@rac2 ~]# su - oracle [oracle@rac2 ~]$ [oracle@rac2 ~]$ ps -ef | grep pmon oracle 3484 1 0 08:12 ? 00:00:00 asm_pmon_+ASM2 oracle 20559 20478 0 10:07 pts/4 00:00:00 grep pmon oracle 26556 1 0 09:05 ? 00:00:00 ora_pmon_zona2 [oracle@rac2 ~]$ [oracle@rac2 ~]$ env | grep SID ORACLE_SID=zona2 [oracle@rac2 ~]$ [oracle@rac2 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Tue Jul 3 10:07:52 2018 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options SQL> select instance_name,status from v$instance; INSTANCE_NAME STATUS ---------------- ------------ zona2 OPEN SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options [oracle@rac2 ~]$ |
备库:
1 2 3 4 5 |
[oracle@standby-rac ~]$ sqlplus -V SQL*Plus: Release 10.2.0.5.0 - Production [oracle@standby-rac ~]$ |
一、基础配置检查:
文件【/etc/hosts】
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
[oracle@standby-rac ~]$ cat /etc/hosts # Do not remove the following line, or various programs # that require network functionality will fail. #127.0.0.1 localhost.localdomain localhost #::1 localhost6.localdomain6 localhost6 # Local 127.0.0.1 localhost # Pub # DG - RAC - Standby 10.158.1.98 standby-rac # DG - RAC - Primary # Pub 10.158.1.46 rac1 10.158.1.47 rac2 # Priv 192.168.0.11 rac1-priv 192.168.0.12 rac2-priv # Virtual 10.158.1.94 rac1-vip 10.158.1.95 rac2-vip # Storage 10.158.1.45 openfiler # Done [oracle@standby-rac ~]$ |
二、主库配置:
强制日志:
节点一:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
SQL> select inst_id,dbid,name,db_unique_name,database_role,current_scn,force_logging from gv$database; INST_ID DBID NAME DB_UNIQUE_NAME DATABASE_ROLE CURRENT_SCN FOR ---------- ---------- --------- ------------------------------ ---------------- ----------- --- 2 1347185043 ZONA zona PRIMARY 1304096 NO 1 1347185043 ZONA zona PRIMARY 1304098 NO SQL> SQL> alter database force logging; alter database force logging * ERROR at line 1: ORA-12920: database is already in force logging mode SQL> select inst_id,dbid,name,db_unique_name,database_role,current_scn,force_logging from gv$database; INST_ID DBID NAME DB_UNIQUE_NAME DATABASE_ROLE CURRENT_SCN FOR ---------- ---------- --------- ------------------------------ ---------------- ----------- --- 2 1347185043 ZONA zona PRIMARY 1305062 YES 1 1347185043 ZONA zona PRIMARY 1305062 YES SQL> |
节点二:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
SQL> set linesize 400 SQL> SQL> select inst_id,dbid,name,db_unique_name,database_role,current_scn,force_logging from gv$database; INST_ID DBID NAME DB_UNIQUE_NAME DATABASE_ROLE CURRENT_SCN FOR ---------- ---------- --------- ------------------------------ ---------------- ----------- --- 2 1347185043 ZONA zona PRIMARY 1304095 NO 1 1347185043 ZONA zona PRIMARY 1304097 NO SQL> SQL> alter database force logging; Database altered. SQL> select inst_id,dbid,name,db_unique_name,database_role,current_scn,force_logging from gv$database; INST_ID DBID NAME DB_UNIQUE_NAME DATABASE_ROLE CURRENT_SCN FOR ---------- ---------- --------- ------------------------------ ---------------- ----------- --- 2 1347185043 ZONA zona PRIMARY 1305061 YES 1 1347185043 ZONA zona PRIMARY 1305061 YES SQL> |
节点一是启用了【强制日志】的,节点二没有启用,所以一开始查询的时候,两个都是【NO】。
后来节点二开启后,再次查询,两个就都是【YES】了。
归档日志模式:
节点一:
1 2 3 4 5 6 7 |
SQL> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination /u01/app/oracle/product/10g/dbhome_1/dbs/arch Oldest online log sequence 41 Current log sequence 42 SQL> |
节点二:
1 2 3 4 5 6 7 |
SQL> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination /u01/app/oracle/product/10g/dbhome_1/dbs/arch Oldest online log sequence 6 Current log sequence 7 SQL> |
可以看到,都没有打开归档模式。
停库:
其中一个节点:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
[root@rac1 ~]# su - grid [grid@rac1 ~]$ [grid@rac1 ~]$ ps -ef | grep pmon oracle 15990 1 0 08:58 ? 00:00:00 ora_pmon_zona1 grid 25407 25181 0 10:17 pts/6 00:00:00 grep pmon oracle 27945 1 0 08:12 ? 00:00:00 asm_pmon_+ASM1 [grid@rac1 ~]$ [grid@rac1 ~]$ crs_stat -t -v Name Type R/RA F/FT Target State Host ---------------------------------------------------------------------- ora....SM1.asm application 0/5 0/0 ONLINE ONLINE rac1 ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1 ora.rac1.gsd application 0/5 0/0 ONLINE ONLINE rac1 ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1 ora.rac1.vip application 0/0 0/0 ONLINE ONLINE rac1 ora....SM2.asm application 0/5 0/0 ONLINE ONLINE rac2 ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2 ora.rac2.gsd application 0/5 0/0 ONLINE ONLINE rac2 ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2 ora.rac2.vip application 0/0 0/0 ONLINE ONLINE rac2 ora.zona.db application 0/1 0/1 ONLINE ONLINE rac2 ora....a1.inst application 0/5 0/0 ONLINE ONLINE rac1 ora....a2.inst application 0/5 0/0 ONLINE ONLINE rac2 [grid@rac1 ~]$ [grid@rac1 ~]$ srvctl stop database -d zona [grid@rac1 ~]$ srvctl status database -d zona Instance zona1 is not running on node rac1 Instance zona2 is not running on node rac2 [grid@rac1 ~]$ [grid@rac1 ~]$ ps -ef | grep pmon oracle 27945 1 0 08:12 ? 00:00:00 asm_pmon_+ASM1 grid 28228 25181 0 10:19 pts/6 00:00:00 grep pmon [grid@rac1 ~]$ |
其中一个节点启动到MOUNT模式,修改归档模式,然后打开库:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 |
[root@rac1 ~]# su - oracle [oracle@rac1 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Tue Jul 3 10:23:58 2018 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to an idle instance. SQL> startup mount; ORACLE instance started. Total System Global Area 536870912 bytes Fixed Size 2097624 bytes Variable Size 234884648 bytes Database Buffers 293601280 bytes Redo Buffers 6287360 bytes Database mounted. SQL> SQL> set linesize 400 SQL> select inst_id,dbid,name,db_unique_name,database_role,current_scn,force_logging from gv$database; INST_ID DBID NAME DB_UNIQUE_NAME DATABASE_ROLE CURRENT_SCN FOR ---------- ---------- --------- ------------------------------ ---------------- ----------- --- 1 1347185043 ZONA zona PRIMARY 0 YES SQL> SQL> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination /u01/app/oracle/product/10g/dbhome_1/dbs/arch Oldest online log sequence 41 Current log sequence 42 SQL> SQL> alter database archivelog; Database altered. SQL> SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /u01/app/oracle/product/10g/dbhome_1/dbs/arch Oldest online log sequence 41 Next log sequence to archive 42 Current log sequence 42 SQL> SQL> select inst_id,dbid,name,db_unique_name,database_role,current_scn,force_logging from gv$database; INST_ID DBID NAME DB_UNIQUE_NAME DATABASE_ROLE CURRENT_SCN FOR ---------- ---------- --------- ------------------------------ ---------------- ----------- --- 1 1347185043 ZONA zona PRIMARY 0 YES SQL> SQL> alter database open; Database altered. SQL> |
另一个节点打开库:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
[oracle@rac2 ~]$ ps -ef | grep pmon oracle 3484 1 0 08:12 ? 00:00:00 asm_pmon_+ASM2 oracle 28324 20478 0 10:26 pts/4 00:00:00 grep pmon [oracle@rac2 ~]$ [oracle@rac2 ~]$ env | grep SID ORACLE_SID=zona2 [oracle@rac2 ~]$ [oracle@rac2 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Tue Jul 3 10:26:30 2018 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 536870912 bytes Fixed Size 2097624 bytes Variable Size 150998568 bytes Database Buffers 377487360 bytes Redo Buffers 6287360 bytes Database mounted. Database opened. SQL> SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /u01/app/oracle/product/10g/dbhome_1/dbs/arch Oldest online log sequence 6 Next log sequence to archive 7 Current log sequence 7 SQL> |
创建上面归档中看到的目录(两个节点都操作):
1 2 3 4 5 6 7 8 9 10 11 12 13 |
[oracle@rac1 ~]$ df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/VolGroup00-LogVol00 70G 12G 55G 18% / /dev/sda1 99M 13M 81M 14% /boot tmpfs 2.0G 0 2.0G 0% /dev/shm /dev/sr0 4.4G 4.4G 0 100% /media/CentOS_5.10_Final [oracle@rac1 ~]$ [oracle@rac1 ~]$ mkdir -p /u01/app/oracle/product/10g/dbhome_1/dbs/arch [oracle@rac1 ~]$ [oracle@rac1 ~]$ ls -ltr /u01/app/oracle/product/10g/dbhome_1/dbs/arch total 0 [oracle@rac1 ~]$ |
做一次日志切换测试一下:
节点一:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
SQL> !ls -ltr /u01/app/oracle/product/10g/dbhome_1/dbs/arch total 0 SQL> SQL> alter system switch logfile; System altered. SQL> SQL> !ls -ltr /u01/app/oracle/product/10g/dbhome_1/dbs/arch total 20256 -rw-r----- 1 oracle oinstall 20716032 Jul 3 10:29 1_42_980450518.dbf SQL> |
节点二:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
SQL> !ls -ltr /u01/app/oracle/product/10g/dbhome_1/dbs/arch total 0 SQL> SQL> alter system switch logfile; System altered. SQL> SQL> !ls -ltr /u01/app/oracle/product/10g/dbhome_1/dbs/arch total 6812 -rw-r----- 1 oracle oinstall 6960128 Jul 3 10:29 2_7_980450518.dbf SQL> |
Rman查看(其中一个节点):
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
[oracle@rac1 ~]$ rman target / Recovery Manager: Release 10.2.0.5.0 - Production on Tue Jul 3 10:32:01 2018 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: ZONA (DBID=1347185043) RMAN> list archivelog all; using target database control file instead of recovery catalog List of Archived Log Copies Key Thrd Seq S Low Time Name ------- ---- ------- - -------------------- ---- 2 1 42 A 03-JUL-2018 09:05:16 /u01/app/oracle/product/10g/dbhome_1/dbs/arch/1_42_980450518.dbf 1 2 7 A 03-JUL-2018 09:05:58 /u01/app/oracle/product/10g/dbhome_1/dbs/arch/2_7_980450518.dbf RMAN> |
修改归档路径(其中一个节点操作):
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /u01/app/oracle/product/10g/dbhome_1/dbs/arch Oldest online log sequence 8 Next log sequence to archive 9 Current log sequence 9 SQL> SQL> show parameter db_recovery_file_dest; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string db_recovery_file_dest_size big integer 2G SQL> SQL> alter system set db_recovery_file_dest="+DATA" scope=both; System altered. SQL> show parameter db_recovery_file_dest; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string +DATA db_recovery_file_dest_size big integer 2G SQL> SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 8 Next log sequence to archive 9 Current log sequence 9 SQL> |
ASM中查看一下:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
[oracle@rac2 ~]$ asmcmd ASMCMD> ls DATA/ ASMCMD> ls DATA/ ZONA/ ASMCMD> ls DATA/ZONA ARCHIVELOG/ CONTROLFILE/ DATAFILE/ ONLINELOG/ PARAMETERFILE/ TEMPFILE/ spfilezona.ora ASMCMD> ls DATA/ZONA/ARCHIVELOG 2018_07_03/ ASMCMD> ls DATA/ZONA/ARCHIVELOG/2018_07_03 thread_1_seq_44.270.980506159 thread_1_seq_45.271.980506227 thread_2_seq_10.272.980506229 thread_2_seq_9.269.980506159 ASMCMD> exit [oracle@rac2 ~]$ |
清理日志:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 |
[oracle@rac1 ~]$ rman target / Recovery Manager: Release 10.2.0.5.0 - Production on Tue Jul 3 10:46:48 2018 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: ZONA (DBID=1347185043) RMAN> list archivelog all; using target database control file instead of recovery catalog List of Archived Log Copies Key Thrd Seq S Low Time Name ------- ---- ------- - -------------------- ---- 2 1 42 A 03-JUL-2018 09:05:16 /u01/app/oracle/product/10g/dbhome_1/dbs/arch/1_42_980450518.dbf 3 1 43 A 03-JUL-2018 10:29:27 /u01/app/oracle/product/10g/dbhome_1/dbs/arch/1_43_980450518.dbf 1 2 7 A 03-JUL-2018 09:05:58 /u01/app/oracle/product/10g/dbhome_1/dbs/arch/2_7_980450518.dbf 4 2 8 A 03-JUL-2018 10:29:26 /u01/app/oracle/product/10g/dbhome_1/dbs/arch/2_8_980450518.dbf RMAN> crosscheck archivelog all; allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=129 instance=zona1 devtype=DISK validation succeeded for archived log archive log filename=/u01/app/oracle/product/10g/dbhome_1/dbs/arch/1_42_980450518.dbf recid=2 stamp=980504968 validation succeeded for archived log archive log filename=/u01/app/oracle/product/10g/dbhome_1/dbs/arch/1_43_980450518.dbf recid=3 stamp=980505545 validation failed for archived log archive log filename=/u01/app/oracle/product/10g/dbhome_1/dbs/arch/2_7_980450518.dbf recid=1 stamp=980504967 validation failed for archived log archive log filename=/u01/app/oracle/product/10g/dbhome_1/dbs/arch/2_8_980450518.dbf recid=4 stamp=980505546 Crosschecked 4 objects RMAN> delete expired archivelog all; released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=129 instance=zona1 devtype=DISK List of Archived Log Copies Key Thrd Seq S Low Time Name ------- ---- ------- - -------------------- ---- 1 2 7 X 03-JUL-2018 09:05:58 /u01/app/oracle/product/10g/dbhome_1/dbs/arch/2_7_980450518.dbf 4 2 8 X 03-JUL-2018 10:29:26 /u01/app/oracle/product/10g/dbhome_1/dbs/arch/2_8_980450518.dbf Do you really want to delete the above objects (enter YES or NO)? yes deleted archive log archive log filename=/u01/app/oracle/product/10g/dbhome_1/dbs/arch/2_7_980450518.dbf recid=1 stamp=980504967 deleted archive log archive log filename=/u01/app/oracle/product/10g/dbhome_1/dbs/arch/2_8_980450518.dbf recid=4 stamp=980505546 Deleted 2 EXPIRED objects RMAN> |
创建RMAN全备目录:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
[root@rac1 ~]# su - oracle [oracle@rac1 ~]$ [oracle@rac1 ~]$ cd $ORACLE_BASE [oracle@rac1 oracle]$ [oracle@rac1 oracle]$ pwd /u01/app/oracle [oracle@rac1 oracle]$ [oracle@rac1 oracle]$ mkdir rman_backup_data [oracle@rac1 oracle]$ cd rman_backup_data/ [oracle@rac1 rman_backup_data]$ [oracle@rac1 rman_backup_data]$ pwd /u01/app/oracle/rman_backup_data [oracle@rac1 rman_backup_data]$ [oracle@rac1 rman_backup_data]$ ls -ltr total 0 [oracle@rac1 rman_backup_data]$ |
RMAN:全备
脚本:
1 2 3 4 5 6 |
run{ allocate channel c1 type disk; backup database format '/u01/app/oracle/rman_backup_data/FULL_ZONA_%U.bk'; backup archivelog all format '/u01/app/oracle/rman_backup_data/ARCH_ZONA_%U.arch'; release channel c1; } |
执行:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 |
RMAN> run{ 2> allocate channel c1 type disk; 3> backup database format '/u01/app/oracle/rman_backup_data/FULL_ZONA_%U.bk'; 4> backup archivelog all format '/u01/app/oracle/rman_backup_data/ARCH_ZONA_%U.arch'; 5> release channel c1; }6> allocated channel: c1 channel c1: sid=129 instance=zona1 devtype=DISK Starting backup at 03-JUL-2018 10:49:43 channel c1: starting full datafile backupset channel c1: specifying datafile(s) in backupset input datafile fno=00002 name=+DATA/zona/datafile/undotbs1.258.980450439 input datafile fno=00001 name=+DATA/zona/datafile/system.256.980450437 input datafile fno=00003 name=+DATA/zona/datafile/sysaux.257.980450437 input datafile fno=00005 name=+DATA/zona/datafile/example.264.980450535 input datafile fno=00006 name=+DATA/zona/datafile/undotbs2.265.980450653 input datafile fno=00004 name=+DATA/zona/datafile/users.259.980450439 channel c1: starting piece 1 at 03-JUL-2018 10:49:44 channel c1: finished piece 1 at 03-JUL-2018 10:50:19 piece handle=/u01/app/oracle/rman_backup_data/FULL_ZONA_06t72li8_1_1.bk tag=TAG20180703T104943 comment=NONE channel c1: backup set complete, elapsed time: 00:00:35 channel c1: starting full datafile backupset channel c1: specifying datafile(s) in backupset including current control file in backupset including current SPFILE in backupset channel c1: starting piece 1 at 03-JUL-2018 10:50:21 channel c1: finished piece 1 at 03-JUL-2018 10:50:22 piece handle=/u01/app/oracle/rman_backup_data/FULL_ZONA_07t72ljb_1_1.bk tag=TAG20180703T104943 comment=NONE channel c1: backup set complete, elapsed time: 00:00:03 Finished backup at 03-JUL-2018 10:50:22 Starting backup at 03-JUL-2018 10:50:25 current log archived channel c1: starting archive log backupset channel c1: specifying archive log(s) in backup set input archive log thread=1 sequence=42 recid=2 stamp=980504968 input archive log thread=1 sequence=43 recid=3 stamp=980505545 input archive log thread=1 sequence=44 recid=6 stamp=980506160 input archive log thread=1 sequence=45 recid=7 stamp=980506226 input archive log thread=2 sequence=9 recid=5 stamp=980506159 input archive log thread=2 sequence=10 recid=8 stamp=980506228 channel c1: starting piece 1 at 03-JUL-2018 10:50:32 channel c1: finished piece 1 at 03-JUL-2018 10:50:33 piece handle=/u01/app/oracle/rman_backup_data/ARCH_ZONA_08t72ljo_1_1.arch tag=TAG20180703T105031 comment=NONE channel c1: backup set complete, elapsed time: 00:00:01 Finished backup at 03-JUL-2018 10:50:33 released channel: c1 RMAN> |
看看RMAN备份目录:
1 2 3 4 5 6 7 8 9 10 11 12 13 |
[oracle@rac1 rman_backup_data]$ pwd /u01/app/oracle/rman_backup_data [oracle@rac1 rman_backup_data]$ ll total 1119568 -rw-r----- 1 oracle oinstall 23899648 Jul 3 10:50 ARCH_ZONA_08t72ljo_1_1.arch -rw-r----- 1 oracle oinstall 1106034688 Jul 3 10:50 FULL_ZONA_06t72li8_1_1.bk -rw-r----- 1 oracle oinstall 15368192 Jul 3 10:50 FULL_ZONA_07t72ljb_1_1.bk [oracle@rac1 rman_backup_data]$ [oracle@rac1 rman_backup_data]$ du -sh * 23M ARCH_ZONA_08t72ljo_1_1.arch 1.1G FULL_ZONA_06t72li8_1_1.bk 15M FULL_ZONA_07t72ljb_1_1.bk [oracle@rac1 rman_backup_data]$ |
RMAN:备份控制文件:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
RMAN> backup device type disk format '/u01/app/oracle/rman_backup_data/ctl_standby_%U.ctl' current controlfile for standby; Starting backup at 03-JUL-2018 10:56:45 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=129 instance=zona1 devtype=DISK channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset including standby control file in backupset channel ORA_DISK_1: starting piece 1 at 03-JUL-2018 10:56:46 channel ORA_DISK_1: finished piece 1 at 03-JUL-2018 10:56:47 piece handle=/u01/app/oracle/rman_backup_data/ctl_standby_09t72lvd_1_1.ctl tag=TAG20180703T105645 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 Finished backup at 03-JUL-2018 10:56:47 RMAN> |
查看备份目录:
1 2 3 4 5 6 7 8 9 10 11 12 13 |
[oracle@rac1 rman_backup_data]$ ll total 1134564 -rw-r----- 1 oracle oinstall 23899648 Jul 3 10:50 ARCH_ZONA_08t72ljo_1_1.arch -rw-r----- 1 oracle oinstall 15335424 Jul 3 10:56 ctl_standby_09t72lvd_1_1.ctl -rw-r----- 1 oracle oinstall 1106034688 Jul 3 10:50 FULL_ZONA_06t72li8_1_1.bk -rw-r----- 1 oracle oinstall 15368192 Jul 3 10:50 FULL_ZONA_07t72ljb_1_1.bk [oracle@rac1 rman_backup_data]$ [oracle@rac1 rman_backup_data]$ du -sh * 23M ARCH_ZONA_08t72ljo_1_1.arch 15M ctl_standby_09t72lvd_1_1.ctl 1.1G FULL_ZONA_06t72li8_1_1.bk 15M FULL_ZONA_07t72ljb_1_1.bk [oracle@rac1 rman_backup_data]$ |
初始化参数文件:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 |
[oracle@rac1 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Tue Jul 3 10:58:10 2018 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options SQL> create pfile='/u01/app/oracle/rman_backup_data/init_zona_primary_thread1.ora' from spfile; File created. SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options [oracle@rac1 ~]$ [oracle@rac1 ~]$ ls -ltr /u01/app/oracle/rman_backup_data/ total 1134568 -rw-r----- 1 oracle oinstall 1106034688 Jul 3 10:50 FULL_ZONA_06t72li8_1_1.bk -rw-r----- 1 oracle oinstall 15368192 Jul 3 10:50 FULL_ZONA_07t72ljb_1_1.bk -rw-r----- 1 oracle oinstall 23899648 Jul 3 10:50 ARCH_ZONA_08t72ljo_1_1.arch -rw-r----- 1 oracle oinstall 15335424 Jul 3 10:56 ctl_standby_09t72lvd_1_1.ctl -rw-r--r-- 1 oracle oinstall 1275 Jul 3 10:58 init_zona_primary_thread1.ora [oracle@rac1 ~]$ |
将主库生成的备份传到备库:
主库
1 2 3 4 5 6 7 |
[oracle@rac1 ~]$ scp -r /u01/app/oracle/rman_backup_data/ standby-rac:/u01/app/oracle/ FULL_ZONA_06t72li8_1_1.bk 100% 1055MB 24.5MB/s 00:43 init_zona_primary_thread1.ora 100% 1275 1.3KB/s 00:00 ARCH_ZONA_08t72ljo_1_1.arch 100% 23MB 22.8MB/s 00:01 FULL_ZONA_07t72ljb_1_1.bk 100% 15MB 14.7MB/s 00:01 ctl_standby_09t72lvd_1_1.ctl 100% 15MB 14.6MB/s 00:01 [oracle@rac1 ~]$ |
备库:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
[oracle@standby-rac rman_backup_data]$ pwd /u01/app/oracle/rman_backup_data [oracle@standby-rac rman_backup_data]$ [oracle@standby-rac rman_backup_data]$ ls -ltr total 1134568 -rw-r--r-- 1 oracle oinstall 1275 Jul 3 11:28 init_zona_primary_thread1.ora -rw-r----- 1 oracle oinstall 1106034688 Jul 3 11:28 FULL_ZONA_06t72li8_1_1.bk -rw-r----- 1 oracle oinstall 23899648 Jul 3 11:28 ARCH_ZONA_08t72ljo_1_1.arch -rw-r----- 1 oracle oinstall 15368192 Jul 3 11:28 FULL_ZONA_07t72ljb_1_1.bk -rw-r----- 1 oracle oinstall 15335424 Jul 3 11:29 ctl_standby_09t72lvd_1_1.ctl [oracle@standby-rac rman_backup_data]$ [oracle@standby-rac rman_backup_data]$ du -sh * 23M ARCH_ZONA_08t72ljo_1_1.arch 15M ctl_standby_09t72lvd_1_1.ctl 1.1G FULL_ZONA_06t72li8_1_1.bk 15M FULL_ZONA_07t72ljb_1_1.bk 4.0K init_zona_primary_thread1.ora [oracle@standby-rac rman_backup_data]$ |
密码文件传到备库:
主库:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
[root@rac1 ~]# su - oracle [oracle@rac1 ~]$ cd $ORACLE_HOME/dbs [oracle@rac1 dbs]$ ls -ltr total 15004 -rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora -rw-r--r-- 1 oracle oinstall 12920 May 3 2001 initdw.ora -rw-r----- 1 oracle oinstall 1536 Jul 2 19:19 orapw+ASM1 lrwxrwxrwx 1 oracle oinstall 41 Jul 2 19:19 init+ASM1.ora -> /u01/app/oracle/admin/+ASM/pfile/init.ora -rw-r----- 1 oracle oinstall 35 Jul 2 19:25 initzona1.ora -rw-r----- 1 oracle oinstall 1536 Jul 2 19:25 orapwzona1 -rw-rw---- 1 oracle oinstall 1588 Jul 3 08:12 ab_+ASM1.dat drwxr-xr-x 2 oracle oinstall 4096 Jul 3 10:39 arch -rw-r----- 1 oracle oinstall 15286272 Jul 3 10:56 snapcf_zona1.f -rw-rw---- 1 oracle oinstall 1552 Jul 3 11:21 hc_+ASM1.dat -rw-rw---- 1 oracle oinstall 1552 Jul 3 11:22 hc_zona1.dat [oracle@rac1 dbs]$ [oracle@rac1 dbs]$ scp orapw* standby-rac:$ORACLE_HOME/dbs oracle@standby-rac's password: orapw+ASM1 100% 1536 1.5KB/s 00:00 orapwzona1 100% 1536 1.5KB/s 00:00 [oracle@rac1 dbs]$ |
备库:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
[oracle@standby-rac rman_backup_data]$ cd $ORACLE_HOME/dbs [oracle@standby-rac dbs]$ ls -ltr total 36 -rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora -rw-r--r-- 1 oracle oinstall 12920 May 3 2001 initdw.ora -rw-r----- 1 oracle oinstall 1536 Jul 3 13:03 orapwzona1 -rw-r----- 1 oracle oinstall 1536 Jul 3 13:03 orapw+ASM1 [oracle@standby-rac dbs]$ cp orapwzona1 orapwzona [oracle@standby-rac dbs]$ ls -ltr total 40 -rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora -rw-r--r-- 1 oracle oinstall 12920 May 3 2001 initdw.ora -rw-r----- 1 oracle oinstall 1536 Jul 3 13:03 orapwzona1 -rw-r----- 1 oracle oinstall 1536 Jul 3 13:03 orapw+ASM1 -rw-r----- 1 oracle oinstall 1536 Jul 3 13:04 orapwzona [oracle@standby-rac dbs]$ |
三、配置初始化参数:
主库:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 |
[oracle@rac1 rman_backup_data]$ pwd /u01/app/oracle/rman_backup_data [oracle@rac1 rman_backup_data]$ [oracle@rac1 rman_backup_data]$ cat init_zona_primary_4_dg.ora zona1.__db_cache_size=293601280 zona2.__db_cache_size=377487360 zona1.__java_pool_size=41943040 zona2.__java_pool_size=4194304 zona1.__large_pool_size=4194304 zona2.__large_pool_size=4194304 zona1.__shared_pool_size=188743680 zona2.__shared_pool_size=142606336 zona1.__streams_pool_size=0 zona2.__streams_pool_size=0 *.audit_file_dest='/u01/app/oracle/admin/zona/adump' *.background_dump_dest='/u01/app/oracle/admin/zona/bdump' *.cluster_database_instances=2 *.cluster_database=TRUE *.compatible='10.2.0.1.0' *.control_files='+DATA/zona/controlfile/current.260.980450515' *.core_dump_dest='/u01/app/oracle/admin/zona/cdump' *.db_block_size=8192 *.db_create_file_dest='+DATA' *.db_domain='' *.db_file_multiblock_read_count=16 *.db_name='zona' *.db_recovery_file_dest_size=2147483648 *.db_recovery_file_dest='+DATA' *.dispatchers='(PROTOCOL=TCP) (SERVICE=zonaXDB)' zona2.instance_number=2 zona1.instance_number=1 *.job_queue_processes=10 *.open_cursors=300 *.pga_aggregate_target=402653184 *.processes=150 *.remote_listener='LISTENERS_ZONA' *.remote_login_passwordfile='exclusive' *.sga_target=536870912 zona2.thread=2 zona1.thread=1 *.undo_management='AUTO' zona1.undo_tablespace='UNDOTBS1' zona2.undo_tablespace='UNDOTBS2' *.user_dump_dest='/u01/app/oracle/admin/zona/udump' *.fal_client='zona' *.fal_server='zonadg' *.log_archive_config='dg_config=(zona,zonadg)' *.log_archive_dest_1='location=+DATA valid_for=(all_logfiles,all_roles) db_unique_name=zona' *.log_archive_dest_2='service=lenkadg lgwr sync affirm valid_for=(online_logfiles,primary_role) db_unique_name=zonadg' [oracle@rac1 rman_backup_data]$ |
备库:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 |
[oracle@standby-rac dbs]$ cd $ORACLE_BASE/rman* [oracle@standby-rac rman_backup_data]$ ls -ltr total 1134568 -rw-r--r-- 1 oracle oinstall 1275 Jul 3 11:28 init_zona_primary_thread1.ora -rw-r----- 1 oracle oinstall 1106034688 Jul 3 11:28 FULL_ZONA_06t72li8_1_1.bk -rw-r----- 1 oracle oinstall 23899648 Jul 3 11:28 ARCH_ZONA_08t72ljo_1_1.arch -rw-r----- 1 oracle oinstall 15368192 Jul 3 11:28 FULL_ZONA_07t72ljb_1_1.bk -rw-r----- 1 oracle oinstall 15335424 Jul 3 11:29 ctl_standby_09t72lvd_1_1.ctl [oracle@standby-rac rman_backup_data]$ cp init_zona_primary_thread1.ora init_zona_standby_dg.ora [oracle@standby-rac rman_backup_data]$ [oracle@standby-rac rman_backup_data]$ cat init_zona_standby_dg.ora *.__db_cache_size=293601280 *.__java_pool_size=41943040 *.__large_pool_size=4194304 *.__shared_pool_size=188743680 *.__streams_pool_size=0 *.audit_file_dest='/u01/app/oracle/admin/zona/adump' *.background_dump_dest='/u01/app/oracle/admin/zona/bdump' *.compatible='10.2.0.1.0' *.control_files='+DATA/zona/controlfile/current.260.980450515' *.core_dump_dest='/u01/app/oracle/admin/zona/cdump' *.db_block_size=8192 *.db_domain='' *.db_file_multiblock_read_count=16 *.db_name='zona' *.db_recovery_file_dest_size=2147483648 *.db_recovery_file_dest='/u01/app/oracle/archivelog_data' *.dispatchers='(PROTOCOL=TCP) (SERVICE=zonaXDB)' *.instance_number=1 *.job_queue_processes=10 *.open_cursors=300 *.pga_aggregate_target=402653184 *.processes=150 *.sga_target=536870912 *.thread=1 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.db_unique_name='zonadg' *.fal_client='zonadg' *.fal_server='zona' *.log_archive_config='dg_config=(zona,zonadg)' *.log_archive_dest_1='location=/u01/app/oracle/primary_archlog_data valid_for=(all_logfiles,all_roles) db_unique_name=zonadg' *.log_archive_dest_2='service=zona1 lgwr sync affirm valid_for=(online_logfiles,primary_role) db_unique_name=zona' *.log_archive_dest_3='service=zona2 lgwr sync affirm valid_for=(online_logfiles,primary_role) db_unique_name=zona' *.log_archive_dest_state_1='enable' *.log_archive_dest_state_2='enable' *.log_archive_dest_state_3='enable' *.log_file_name_convert='+DATA/ZONA/','/u01/app/oracle/primary_archlog_data' *.db_file_name_convert='+DATA/ZONA/','/u01/app/oracle/primary_archlog_data' *.service_names='zonadg' *.standby_file_management='AUTO' [oracle@standby-rac rman_backup_data]$ |
主库按照新的参数文件启动:
1. 关掉主库RAC的数据库实例
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
[oracle@rac1 dbs]$ su - grid -c "crs_stat -t -v" Password: Name Type R/RA F/FT Target State Host ---------------------------------------------------------------------- ora....SM1.asm application 0/5 0/0 ONLINE ONLINE rac1 ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1 ora.rac1.gsd application 0/5 0/0 ONLINE ONLINE rac1 ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1 ora.rac1.vip application 0/0 0/0 ONLINE ONLINE rac1 ora....SM2.asm application 0/5 0/0 ONLINE ONLINE rac2 ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2 ora.rac2.gsd application 0/5 0/0 ONLINE ONLINE rac2 ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2 ora.rac2.vip application 0/0 0/0 ONLINE ONLINE rac2 ora.zona.db application 0/1 0/1 OFFLINE OFFLINE ora....a1.inst application 0/5 0/0 OFFLINE OFFLINE ora....a2.inst application 0/5 0/0 OFFLINE OFFLINE [oracle@rac1 dbs]$ |
2. 其中一个节点上,准备pfile:
1 2 3 4 5 6 7 8 9 10 11 12 |
[oracle@rac1 dbs]$ ls -ltr | grep initzona -rw-r----- 1 oracle oinstall 1355 Jul 5 11:03 initzona1.ora_bak_20180705 -rw-r--r-- 1 oracle oinstall 35 Jul 5 11:38 initzona1.ora -rw-r--r-- 1 oracle oinstall 35 Jul 5 13:23 initzona1.ora_bak_before_change [oracle@rac1 dbs]$ [oracle@rac1 dbs]$ cat /u01/app/oracle/rman_backup_data/init_zona_primary_thread1.ora > initzona1.ora [oracle@rac1 dbs]$ [oracle@rac1 dbs]$ ls -ltr | grep initzona -rw-r----- 1 oracle oinstall 1355 Jul 5 11:03 initzona1.ora_bak_20180705 -rw-r--r-- 1 oracle oinstall 35 Jul 5 13:23 initzona1.ora_bak_before_change -rw-r--r-- 1 oracle oinstall 1595 Jul 5 13:27 initzona1.ora [oracle@rac1 dbs]$ |
3. 查看ASM上的状态:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 |
[oracle@rac1 dbs]$ env | grep SID ORACLE_SID=zona1 [oracle@rac1 dbs]$ [oracle@rac1 dbs]$ ps -ef | grep pmon oracle 3368 27098 0 13:29 pts/2 00:00:00 grep pmon oracle 6013 1 0 02:42 ? 00:00:00 asm_pmon_+ASM1 [oracle@rac1 dbs]$ [oracle@rac1 dbs]$ export ORACLE_SID=+ASM1 [oracle@rac1 dbs]$ [oracle@rac1 dbs]$ pwd /u01/app/oracle/product/10g/dbhome_1/dbs [oracle@rac1 dbs]$ [oracle@rac1 dbs]$ ls -ltr | grep spfile -rw-r----- 1 oracle oinstall 4608 Jul 5 13:27 spfilezona1.ora [oracle@rac1 dbs]$ [oracle@rac1 dbs]$ asmcmd ASMCMD> ls -ltr State Type Rebal Unbal Name MOUNTED EXTERN N N DATA/ ASMCMD> ASMCMD> cd DATA ASMCMD> ls -ltr Type Redund Striped Time Sys Name Y ZONA/ ASMCMD> cd ZONA ASMCMD> ls -ltr Type Redund Striped Time Sys Name Y ARCHIVELOG/ Y CONTROLFILE/ Y DATAFILE/ Y ONLINELOG/ Y PARAMETERFILE/ Y TEMPFILE/ N spfilezona.ora => +DATA/ZONA/PARAMETERFILE/spfile.268.980450687 ASMCMD> |
4. 开始生成spfile:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
[oracle@rac1 dbs]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Thu Jul 5 13:39:41 2018 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to an idle instance. SQL> create spfile='+DATA/ZONA/spfilezona.ora' from pfile; File created. SQL> exit Disconnected [oracle@rac1 dbs]$ |
再看看ASM的状态:
1 2 3 4 5 6 7 8 9 10 11 12 |
[oracle@rac1 dbs]$ export ORACLE_SID=+ASM1 [oracle@rac1 dbs]$ asmcmd ASMCMD> ls -ltr /DATA/ZONA/ Type Redund Striped Time Sys Name Y ARCHIVELOG/ Y CONTROLFILE/ Y DATAFILE/ Y ONLINELOG/ Y TEMPFILE/ N spfilezona.ora => +DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.268.980689239 ASMCMD> exit [oracle@rac1 dbs]$ |
5. 还原之前的【initzona1.ora】
1 2 |
[oracle@rac1 dbs]$ cat initzona1.ora_bak_before_change > initzona1.ora [oracle@rac1 dbs]$ |
6. 按照新的参数文件起库,并检查参数配置:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 |
[oracle@rac1 dbs]$ export ORACLE_SID=zona1 [oracle@rac1 dbs]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Thu Jul 5 13:43:21 2018 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 536870912 bytes Fixed Size 2097624 bytes Variable Size 234884648 bytes Database Buffers 293601280 bytes Redo Buffers 6287360 bytes Database mounted. Database opened. SQL> SQL> show parameter fal NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ fal_client string zona fal_server string zonadg SQL> SQL> show parameter log_archive_config NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_config string dg_config=(zona,zonadg) SQL> SQL> show parameter log_archive_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest string log_archive_dest_1 string location=+DATA valid_for=(all_ logfiles,all_roles) db_unique_ name=zona log_archive_dest_10 string log_archive_dest_2 string service=zonadg lgwr sync affir m valid_for=(online_logfiles,p rimary_role) db_unique_name=zo nadg log_archive_dest_3 string log_archive_dest_4 string NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_5 string log_archive_dest_6 string log_archive_dest_7 string log_archive_dest_8 string log_archive_dest_9 string log_archive_dest_state_1 string enable log_archive_dest_state_10 string enable log_archive_dest_state_2 string enable log_archive_dest_state_3 string enable log_archive_dest_state_4 string enable log_archive_dest_state_5 string enable NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_state_6 string enable log_archive_dest_state_7 string enable log_archive_dest_state_8 string enable log_archive_dest_state_9 string enable SQL> SQL> show parameter list NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ local_listener string remote_listener string LISTENERS_ZONA SQL> |
————————————————
备库创建目录:
1 2 3 4 5 6 7 8 9 10 11 12 |
[oracle@standby-rac ~]$ mkdir -p $ORACLE_BASE/admin/zona/{adump,dpdump,bdump,pfile} [oracle@standby-rac ~]$ [oracle@standby-rac ~]$ mkdir -p $ORACLE_BASE/oradata/zona/{controlfile,datafile,onlinelog} [oracle@standby-rac ~]$ mkdir -p $ORACLE_BASE/oradata/ZONA/onlinelog [oracle@standby-rac ~]$ [oracle@standby-rac ~]$ mkdir -p $ORACLE_BASE/oradata/zonadg/{controlfile,datafile,onlinelog} [oracle@standby-rac ~]$ mkdir -p $ORACLE_BASE/oradata/ZONADG/onlinelog [oracle@standby-rac ~]$ [oracle@standby-rac ~]$ mkdir -p $ORACLE_BASE/diag/rdbms/zonadg [oracle@standby-rac ~]$ [oracle@standby-rac ~]$ mkdir -p /u01/app/oracle/primary_archlog_data/{datafile,archivelog,controlfile,onlinelog,parameterfile,tempfile} [oracle@standby-rac ~]$ |
四、TNS配置:
将主库的TNS拷贝到备库:
1 2 3 4 5 6 7 8 9 10 11 12 13 |
[root@rac2 ~]# su - oracle [oracle@rac2 ~]$ scp /u01/app/oracle/product/10g/dbhome_1/network/admin/tnsnames.ora standby-rac:$ORACLE_HOME/network/admin The authenticity of host 'standby-rac (10.158.1.98)' can't be established. RSA key fingerprint is 38:50:0b:15:17:7e:ef:b6:52:62:ed:2f:5d:7a:a7:89. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added 'standby-rac,10.158.1.98' (RSA) to the list of known hosts. oracle@standby-rac's password: tnsnames.ora 100% 1198 1.2KB/s 00:00 [oracle@rac2 ~]$ [oracle@rac2 ~]$ scp /u01/app/oracle/product/10g/dbhome_1/network/admin/listener.ora standby-rac:$ORACLE_HOME/network/admin oracle@standby-rac's password: listener.ora 100% 618 0.6KB/s 00:00 [oracle@rac2 ~]$ |
备库:
监听器:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 |
[oracle@standby-rac admin]$ ps -ef | grep lsnr oracle 1284 1121 0 18:38 pts/1 00:00:00 grep lsnr [oracle@standby-rac admin]$ [oracle@standby-rac admin]$ pwd /u01/app/oracle/product/10g/dbhome_1/network/admin [oracle@standby-rac admin]$ [oracle@standby-rac admin]$ cat listener.ora # listener.ora.rac2 Network Configuration File: /u01/app/oracle/product/10g/dbhome_1/network/admin/listener.ora.rac2 # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = standby-rac)(PORT = 1521)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = zona) (ORACLE_HOME = /u01/app/oracle/product/10g/dbhome_1) (PROGRAM = extproc) ) ) [oracle@standby-rac admin]$ [oracle@standby-rac admin]$ lsnrctl start LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 03-JUL-2018 18:38:56 Copyright (c) 1991, 2010, Oracle. All rights reserved. Starting /u01/app/oracle/product/10g/dbhome_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 10.2.0.5.0 - Production System parameter file is /u01/app/oracle/product/10g/dbhome_1/network/admin/listener.ora Log messages written to /u01/app/oracle/product/10g/dbhome_1/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=standby-rac)(PORT=1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production Start Date 03-JUL-2018 18:38:56 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/10g/dbhome_1/network/admin/listener.ora Listener Log File /u01/app/oracle/product/10g/dbhome_1/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=standby-rac)(PORT=1521))) Services Summary... Service "zona" has 1 instance(s). Instance "zona", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully [oracle@standby-rac admin]$ |
文件【tnsnames.ora】
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 |
[oracle@standby-rac admin]$ cat tnsnames.ora # tnsnames.ora.rac2 Network Configuration File: /u01/app/oracle/product/10g/dbhome_1/network/admin/tnsnames.ora.rac2 # Generated by Oracle configuration tools. LISTENERS_ZONA = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521)) ) ZONA = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = zona) ) ) ZONA2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = zona) (INSTANCE_NAME = zona2) ) ) ZONA1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = zona) (INSTANCE_NAME = zona1) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) ZONADG = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = standby-rac)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = zona) ) ) [oracle@standby-rac admin]$ |
测试:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
[oracle@standby-rac admin]$ tnsping zonadg TNS Ping Utility for Linux: Version 10.2.0.5.0 - Production on 03-JUL-2018 18:41:25 Copyright (c) 1997, 2010, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = standby-rac)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = zona))) OK (10 msec) [oracle@standby-rac admin]$ [oracle@standby-rac admin]$ tnsping zona TNS Ping Utility for Linux: Version 10.2.0.5.0 - Production on 03-JUL-2018 18:41:28 Copyright (c) 1997, 2010, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = zona))) OK (30 msec) [oracle@standby-rac admin]$ |
五、备库:Rman创建
启动到nomount
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 |
[root@standby-rac ~]# su - oracle [oracle@standby-rac ~]$ [oracle@standby-rac ~]$ env | grep SID ORACLE_SID=zona [oracle@standby-rac ~]$ [oracle@standby-rac ~]$ ps -ef | grep pmon oracle 1335 1310 0 18:44 pts/1 00:00:00 grep pmon [oracle@standby-rac ~]$ [oracle@standby-rac ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Tue Jul 3 18:44:07 2018 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to an idle instance. SQL> !ls -ltr total 0 SQL> !ls -ltr $ORACLE_HOME/dbs | grep zona -rw-r----- 1 oracle oinstall 1536 Jul 3 13:03 orapwzona1 -rw-r----- 1 oracle oinstall 1536 Jul 3 13:04 orapwzona SQL> !ls -ltr $ORACLE_BASE/rman* | grep zona -rw-r--r-- 1 oracle oinstall 1275 Jul 3 11:28 init_zona_primary_thread1.ora -rw-r--r-- 1 oracle oinstall 1594 Jul 3 13:29 init_zona_standby_dg.ora SQL> SQL> create spfile from pfile='/u01/app/oracle/rman_backup_data/init_zona_standby_dg.ora'; File created. SQL> startup nomount; ORACLE instance started. Total System Global Area 536870912 bytes Fixed Size 2097624 bytes Variable Size 234884648 bytes Database Buffers 293601280 bytes Redo Buffers 6287360 bytes SQL> SQL> select instance_name,status from v$instance; INSTANCE_NAME STATUS ---------------- ------------ zona STARTED SQL> |
Rman恢复数据:控制文件:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
[oracle@standby-rac ~]$ rman target / Recovery Manager: Release 10.2.0.5.0 - Production on Tue Jul 3 18:50:49 2018 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: zona (not mounted) RMAN> restore standby controlfile from '/u01/app/oracle/rman_backup_data/ctl_standby_09t72lvd_1_1.ctl'; Starting restore at 03-JUL-2018 18:50:58 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=156 devtype=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:03 output filename=/u01/app/oracle/archivelog_data/ZONADG/controlfile/o1_mf_fmpo8otk_.ctl Finished restore at 03-JUL-2018 18:51:02 RMAN> |
启动数据库:MOUNT
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
[oracle@standby-rac ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Tue Jul 3 18:51:59 2018 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> alter database mount; Database altered. SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@standby-rac ~]$ |
RMAN恢复数据库:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 |
[oracle@standby-rac ~]$ rman target / Recovery Manager: Release 10.2.0.5.0 - Production on Tue Jul 3 19:12:43 2018 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: ZONA (DBID=1347185043, not open) RMAN> run { 2> allocate channel c1 type disk; 3> restore database; 4> release channel c1; 5> } using target database control file instead of recovery catalog allocated channel: c1 channel c1: sid=156 devtype=DISK Starting restore at 03-JUL-2018 19:13:07 channel c1: starting datafile backupset restore channel c1: specifying datafile(s) to restore from backup set restoring datafile 00001 to /u01/app/oracle/primary_archlog_data/datafile/system.256.980450437 restoring datafile 00002 to /u01/app/oracle/primary_archlog_data/datafile/undotbs1.258.980450439 restoring datafile 00003 to /u01/app/oracle/primary_archlog_data/datafile/sysaux.257.980450437 restoring datafile 00004 to /u01/app/oracle/primary_archlog_data/datafile/users.259.980450439 restoring datafile 00005 to /u01/app/oracle/primary_archlog_data/datafile/example.264.980450535 restoring datafile 00006 to /u01/app/oracle/primary_archlog_data/datafile/undotbs2.265.980450653 channel c1: reading from backup piece /u01/app/oracle/rman_backup_data/FULL_ZONA_06t72li8_1_1.bk channel c1: restored backup piece 1 piece handle=/u01/app/oracle/rman_backup_data/FULL_ZONA_06t72li8_1_1.bk tag=TAG20180703T104943 channel c1: restore complete, elapsed time: 00:12:35 Finished restore at 03-JUL-2018 19:25:42 released channel: c1 RMAN> |
看看数据目录状态:
1 2 3 4 5 6 7 8 |
[oracle@standby-rac rman_backup_data]$ du -sh /u01/app/oracle/primary_archlog_data/* 4.0K /u01/app/oracle/primary_archlog_data/archivelog 4.0K /u01/app/oracle/primary_archlog_data/controlfile 1.5G /u01/app/oracle/primary_archlog_data/datafile 4.0K /u01/app/oracle/primary_archlog_data/onlinelog 4.0K /u01/app/oracle/primary_archlog_data/parameterfile 4.0K /u01/app/oracle/primary_archlog_data/tempfile [oracle@standby-rac rman_backup_data]$ |
查看当前数据库的状态(备库)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 |
[oracle@standby-rac ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Tue Jul 3 19:27:18 2018 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select instance_name,status from v$instance; INSTANCE_NAME STATUS ---------------- ------------ zona MOUNTED SQL> set linesize 400 SQL> col name for a65 SQL> SQL> select name from v$database 2 union 3 select name from v$controlfile 4 union 5 select member from v$logfile; NAME ----------------------------------------------------------------- /u01/app/oracle/archivelog_data/ZONADG/controlfile/o1_mf_fmpp9vds _.ctl /u01/app/oracle/primary_archlog_data/onlinelog/group_1.261.980450 519 /u01/app/oracle/primary_archlog_data/onlinelog/group_2.262.980450 519 /u01/app/oracle/primary_archlog_data/onlinelog/group_3.266.980450 685 NAME ----------------------------------------------------------------- /u01/app/oracle/primary_archlog_data/onlinelog/group_4.267.980450 685 ZONA 6 rows selected. SQL> |
添加standby日志文件:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 |
SQL> set linesize 400 SQL> col member for a70 SQL> select group#,member from v$logfile; GROUP# MEMBER ---------- ---------------------------------------------------------------------- 2 /u01/app/oracle/primary_archlog_data/onlinelog/group_2.262.980450519 1 /u01/app/oracle/primary_archlog_data/onlinelog/group_1.261.980450519 3 /u01/app/oracle/primary_archlog_data/onlinelog/group_3.266.980450685 4 /u01/app/oracle/primary_archlog_data/onlinelog/group_4.267.980450685 SQL> SQL> alter database add standby logfile thread 1 group 5 size 50M ,group 6 size 50M ,group 7 size 50M; Database altered. SQL> alter database add standby logfile thread 2 group 8 size 50M ,group 9 size 50M ,group 10 size 50M; Database altered. SQL> select group#,member from v$logfile; GROUP# MEMBER ---------- ---------------------------------------------------------------------- 2 /u01/app/oracle/primary_archlog_data/onlinelog/group_2.262.980450519 1 /u01/app/oracle/primary_archlog_data/onlinelog/group_1.261.980450519 3 /u01/app/oracle/primary_archlog_data/onlinelog/group_3.266.980450685 4 /u01/app/oracle/primary_archlog_data/onlinelog/group_4.267.980450685 5 /u01/app/oracle/archivelog_data/ZONADG/onlinelog/o1_mf_5_fmps083q_.log 6 /u01/app/oracle/archivelog_data/ZONADG/onlinelog/o1_mf_6_fmps0g8p_.log 7 /u01/app/oracle/archivelog_data/ZONADG/onlinelog/o1_mf_7_fmps0pz5_.log 8 /u01/app/oracle/archivelog_data/ZONADG/onlinelog/o1_mf_8_fmps42yq_.log 9 /u01/app/oracle/archivelog_data/ZONADG/onlinelog/o1_mf_9_fmps4b0f_.log 10 /u01/app/oracle/archivelog_data/ZONADG/onlinelog/o1_mf_10_fmps4jhm_.lo g GROUP# MEMBER ---------- ---------------------------------------------------------------------- 10 rows selected. SQL> |
六、将备库的DG复制打开:
打开前:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 |
[oracle@standby-rac ~]$ ps -ef | grep pmon oracle 3647 1 0 19:43 ? 00:00:00 ora_pmon_zona oracle 10153 10008 0 19:58 pts/2 00:00:00 grep pmon [oracle@standby-rac ~]$ [oracle@standby-rac ~]$ sh check_dg.sh zona SQL*Plus: Release 10.2.0.5.0 - Production on Tue Jul 3 19:58:54 2018 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> INSTANCE_NAME STATUS ---------------- ------------ zona MOUNTED SQL> NAME DATABASE_ROLE OPEN_MODE --------- ---------------- ---------- ZONA PHYSICAL STANDBY MOUNTED SQL> no rows selected SQL> COUNT(*) ---------- 6 SQL> NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string /u01/app/oracle/product/10g/db home_1/dbs/spfilezona.ora SQL> NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_files string /u01/app/oracle/archivelog_dat a/ZONADG/controlfile/o1_mf_fmp p9vds_.ctl SQL> NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ background_core_dump string partial background_dump_dest string /u01/app/oracle/admin/zona/bdu mp SQL> NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ local_listener string SQL> SQL> Summary Size of GB ------------------ 1.45507813 SQL> SQL> SQL> SQL> PROCESS PID CLIENT_PID STATUS DELAY_MINS KNOWN_AGENTS ACTIVE_AGENTS --------- ---------- -------------------- ------------ ---------- ------------ ------------- ARCH 3677 3677 CONNECTED 0 0 0 ARCH 3675 3675 CONNECTED 0 0 0 SQL> SQL> SQL> SQL> no rows selected SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@standby-rac ~]$ |
打开:
1 2 3 4 5 |
SQL> alter database recover managed standby database disconnect from session; Database altered. SQL> |
打开后,检查备库的DG状态:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 |
[oracle@standby-rac ~]$ sh check_dg.sh zona SQL*Plus: Release 10.2.0.5.0 - Production on Thu Jul 5 13:45:27 2018 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> INSTANCE_NAME STATUS ---------------- ------------ zona MOUNTED SQL> NAME DATABASE_ROLE OPEN_MODE --------- ---------------- ---------- ZONA PHYSICAL STANDBY MOUNTED SQL> THREAD# Sequence ---------- ---------- 1 56 2 17 SQL> COUNT(*) ---------- 6 SQL> NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string /u01/app/oracle/product/10g/db home_1/dbs/spfilezona.ora SQL> NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_files string /u01/app/oracle/archivelog_dat a/ZONADG/controlfile/o1_mf_fmp p9vds_.ctl SQL> NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ background_core_dump string partial background_dump_dest string /u01/app/oracle/admin/zona/bdu mp SQL> NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ local_listener string LISTENERS_STANDBY_RAC SQL> SQL> Summary Size of GB ------------------ 1.51367188 SQL> SQL> SQL> SQL> PROCESS PID CLIENT_PID STATUS DELAY_MINS KNOWN_AGENTS ACTIVE_AGENTS --------- ---------- -------------------- ------------ ---------- ------------ ------------- ARCH 12527 12527 CLOSING 0 0 0 ARCH 12529 12529 CLOSING 0 0 0 MRP0 18506 N/A WAIT_FOR_LOG 0 0 0 RFS 18890 9094 IDLE 0 0 0 RFS 18892 9227 IDLE 0 0 0 SQL> SQL> SQL> SQL> NAME THREAD# SEQUENCE# First Next APP ----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- --- /u01/app/oracle/primary_archlog_data/1_51_980450518.dbf 1 51 2018-07-04 07:58:16 2018-07-04 12:27:49 YES /u01/app/oracle/primary_archlog_data/1_52_980450518.dbf 1 52 2018-07-04 12:27:49 2018-07-05 02:40:35 YES /u01/app/oracle/primary_archlog_data/1_53_980450518.dbf 1 53 2018-07-05 02:40:35 2018-07-05 11:12:16 YES /u01/app/oracle/primary_archlog_data/1_54_980450518.dbf 1 54 2018-07-05 11:12:16 2018-07-05 13:36:34 YES /u01/app/oracle/primary_archlog_data/1_55_980450518.dbf 1 55 2018-07-05 13:36:34 2018-07-05 13:38:56 YES /u01/app/oracle/primary_archlog_data/1_56_980450518.dbf 1 56 2018-07-05 13:38:56 2018-07-05 13:43:40 YES 6 rows selected. SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@standby-rac ~]$ |
七、测试
主库日志切换:
节点一:
1 2 3 4 5 6 7 8 9 10 11 12 13 |
SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination +DATA Oldest online log sequence 56 Next log sequence to archive 57 Current log sequence 57 SQL> SQL> alter system switch logfile; System altered. SQL> |
节点二:
1 2 3 4 5 6 7 8 9 10 11 12 13 |
SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination +DATA Oldest online log sequence 19 Next log sequence to archive 20 Current log sequence 20 SQL> SQL> alter system switch logfile; System altered. SQL> |
备库:
Alert日志:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 |
[root@standby-rac ~]# tail -f /u01/app/oracle/admin/zona/bdump/alert_zona.log RFS[6]: Successfully opened standby log 5: '/u01/app/oracle/archivelog_data/ZONADG/onlinelog/o1_mf_5_fmps083q_.log' Thu Jul 05 13:43:45 CST 2018 Redo Shipping Client Connected as PUBLIC -- Connected User is Valid RFS[7]: Assigned to RFS process 18892 RFS[7]: Identified database type as 'physical standby' RFS[7]: Successfully opened standby log 6: '/u01/app/oracle/archivelog_data/ZONADG/onlinelog/o1_mf_6_fmps0g8p_.log' Thu Jul 05 13:43:47 CST 2018 Media Recovery Log /u01/app/oracle/primary_archlog_data/1_56_980450518.dbf Media Recovery Waiting for thread 1 sequence 57 (in transit) ========================== Thu Jul 05 13:48:35 CST 2018 Redo Shipping Client Connected as PUBLIC -- Connected User is Valid RFS[8]: Assigned to RFS process 18932 RFS[8]: Identified database type as 'physical standby' Primary database is in MAXIMUM PERFORMANCE mode Redo Shipping Client Connected as PUBLIC -- Connected User is Valid RFS[9]: Assigned to RFS process 18935 RFS[9]: Identified database type as 'physical standby' Primary database is in MAXIMUM PERFORMANCE mode Primary database is in MAXIMUM PERFORMANCE mode RFS[9]: Successfully opened standby log 8: '/u01/app/oracle/archivelog_data/ZONADG/onlinelog/o1_mf_8_fmps42yq_.log' Thu Jul 05 13:48:43 CST 2018 Redo Shipping Client Connected as PUBLIC -- Connected User is Valid RFS[10]: Assigned to RFS process 18937 RFS[10]: Identified database type as 'physical standby' RFS[10]: Successfully opened standby log 9: '/u01/app/oracle/archivelog_data/ZONADG/onlinelog/o1_mf_9_fmps4b0f_.log' ========================== Thu Jul 05 13:49:26 CST 2018 Primary database is in MAXIMUM PERFORMANCE mode RFS[6]: Successfully opened standby log 5: '/u01/app/oracle/archivelog_data/ZONADG/onlinelog/o1_mf_5_fmps083q_.log' Thu Jul 05 13:49:27 CST 2018 Media Recovery Log /u01/app/oracle/primary_archlog_data/1_57_980450518.dbf Media Recovery Log /u01/app/oracle/primary_archlog_data/2_19_980450518.dbf Media Recovery Waiting for thread 2 sequence 20 (in transit) ========================== Thu Jul 05 13:49:41 CST 2018 Primary database is in MAXIMUM PERFORMANCE mode RFS[9]: Successfully opened standby log 9: '/u01/app/oracle/archivelog_data/ZONADG/onlinelog/o1_mf_9_fmps4b0f_.log' Thu Jul 05 13:49:42 CST 2018 Media Recovery Log /u01/app/oracle/primary_archlog_data/2_20_980450518.dbf Media Recovery Waiting for thread 1 sequence 58 (in transit) |
八、终了
至此,RAC到单实例的10g Dataguard就结束了。
——————————
Done。