开始本文前，你需要准备好以下环境：
主库端：ORACLE RAC 11g
备库端：ORACLE database 11g【standalone】
在我的环境里：
主库端：
[root@oracle-cluster-1 ~]# su - grid Last login: Wed Mar 22 14:23:30 CST 2017 on pts/3 [grid@oracle-cluster-1 ~]$ [grid@oracle-cluster-1 ~]$ cat /etc/hosts #127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 #::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 # Local 127.0.0.1 localhost # Public # eth0 10.158.1.45 ora12c-1 # for: oracle database 12c r2 rac 10.158.1.46 oracle-cluster-1 10.158.1.157 oracle-cluster-2 10.158.1.161 oracle-cluster-3 10.158.1.178 oracle-cluster-4 # vip 10.158.1.94 oracle-cluster-1-vip 10.158.1.95 oracle-cluster-2-vip # Private 192.168.24.94 oracle-cluster-1-priv 192.168.24.95 oracle-cluster-2-priv # SCAN 10.158.1.96 scan1 # Storage 10.158.1.47 openfiler [grid@oracle-cluster-1 ~]$ [grid@oracle-cluster-1 ~]$ crs_stat -t -v Name Type R/RA F/FT Target State Host ---------------------------------------------------------------------- ora.CRS.dg ora....up.type 0/5 0/ ONLINE ONLINE orac...er-1 ora.DATA01.dg ora....up.type 0/5 0/ ONLINE ONLINE orac...er-1 ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE orac...er-1 ora....N1.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE orac...er-1 ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE orac...er-1 ora.cvu ora.cvu.type 0/5 0/0 ONLINE ONLINE orac...er-1 ora.gsd ora.gsd.type 0/5 0/ OFFLINE OFFLINE ora.lenka.db ora....se.type 0/2 0/1 ONLINE ONLINE orac...er-1 ora....network ora....rk.type 0/5 0/ ONLINE ONLINE orac...er-1 ora.oc4j ora.oc4j.type 0/1 0/2 ONLINE ONLINE orac...er-1 ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE orac...er-1 ora....SM1.asm application 0/5 0/0 ONLINE ONLINE orac...er-1 ora....-1.lsnr application 0/5 0/0 ONLINE ONLINE orac...er-1 ora....r-1.gsd application 0/5 0/0 OFFLINE OFFLINE ora....r-1.ons application 0/3 0/0 ONLINE ONLINE orac...er-1 ora....r-1.vip ora....t1.type 0/0 0/0 ONLINE ONLINE orac...er-1 ora....SM2.asm application 0/5 0/0 ONLINE ONLINE orac...er-2 ora....-2.lsnr application 0/5 0/0 ONLINE ONLINE orac...er-2 ora....r-2.gsd application 0/5 0/0 OFFLINE OFFLINE ora....r-2.ons application 0/3 0/0 ONLINE ONLINE orac...er-2 ora....r-2.vip ora....t1.type 0/0 0/0 ONLINE ONLINE orac...er-2 ora.scan1.vip ora....ip.type 0/0 0/0 ONLINE ONLINE orac...er-1 [grid@oracle-cluster-1 ~]$ [grid@oracle-cluster-1 ~]$ lsnrctl status LISTENER_SCAN1 LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 22-MAR-2017 19:45:17 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))) STATUS of the LISTENER ------------------------ Alias LISTENER_SCAN1 Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 22-MAR-2017 13:57:39 Uptime 0 days 5 hr. 47 min. 41 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora Listener Log File /u01/app/11.2.0/grid/log/diag/tnslsnr/oracle-cluster-1/listener_scan1/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.158.1.96)(PORT=1521))) Services Summary... Service "lenka" has 2 instance(s). Instance "lenka1", status READY, has 1 handler(s) for this service... Instance "lenka2", status READY, has 1 handler(s) for this service... Service "lenkaXDB" has 2 instance(s). Instance "lenka1", status READY, has 1 handler(s) for this service... Instance "lenka2", status READY, has 1 handler(s) for this service... The command completed successfully [grid@oracle-cluster-1 ~]$
备库端：
[root@oracle-cluster-3 ~]# ifconfig
ens32: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 10.158.1.161 netmask 255.255.254.0 broadcast 10.158.1.255
inet6 fe80::250:56ff:fe84:22c9 prefixlen 64 scopeid 0x20
ether 00:50:56:84:22:c9 txqueuelen 1000 (Ethernet)
RX packets 5740716 bytes 3399648828 (3.1 GiB)
RX errors 0 dropped 7898 overruns 0 frame 0
TX packets 417853 bytes 147490416 (140.6 MiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
ens33: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
ether 00:50:56:84:77:4f txqueuelen 1000 (Ethernet)
RX packets 2899003 bytes 232436159 (221.6 MiB)
RX errors 0 dropped 7898 overruns 0 frame 0
TX packets 0 bytes 0 (0.0 B)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
ens34: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
ether 00:50:56:84:7e:be txqueuelen 1000 (Ethernet)
RX packets 2899022 bytes 232439392 (221.6 MiB)
RX errors 0 dropped 7899 overruns 0 frame 0
TX packets 0 bytes 0 (0.0 B)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
lo: flags=73<UP,LOOPBACK,RUNNING> mtu 65536
inet 127.0.0.1 netmask 255.0.0.0
inet6 ::1 prefixlen 128 scopeid 0x10
loop txqueuelen 0 (Local Loopback)
RX packets 1624 bytes 108194 (105.6 KiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 1624 bytes 108194 (105.6 KiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
[root@oracle-cluster-3 ~]#
[root@oracle-cluster-3 ~]# su - oracle
Last login: Wed Mar 22 16:16:56 CST 2017 on pts/1
[oracle@oracle-cluster-3 ~]$ sqlplus -V
SQL*Plus: Release 11.2.0.4.0 Production
[oracle@oracle-cluster-3 ~]$所有服务器（本环境中，涉及到了三台服务器）均做以下操作：
关闭防火墙与SELINUX
[root@oracle-cluster-1 ~]# sestatus SELinux status: disabled [root@oracle-cluster-1 ~]# [root@oracle-cluster-1 ~]# systemctl status firewalld firewalld.service - firewalld - dynamic firewall daemon Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled) Active: inactive (dead) [root@oracle-cluster-1 ~]#
零、RAC + DG 架构关系
【主机名，IP，数据库名，DB_UNIQUE_NAME / NET Service NAME（这两个名字一致）】
主库：
oracle-cluster-1，10.158.1.46 ，lenka，lenka1
oracle-cluster-2，10.158.1.157，lenka，lenka2
备库：
oracle-cluster-3，10.158.1.161，lenka，lenkadg
一、主库端操作：
查看数据库版本：
[root@oracle-cluster-1 ~]# su - oracle Last login: Wed Mar 22 15:18:16 CST 2017 on pts/1 [oracle@oracle-cluster-1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 22 16:37:10 2017 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production PL/SQL Release 11.2.0.4.0 - Production CORE 11.2.0.4.0 Production TNS for Linux: Version 11.2.0.4.0 - Production NLSRTL Version 11.2.0.4.0 - Production SQL>
ASM磁盘组的情况：
SQL> col name for a10 SQL> select name,state from v$asm_diskgroup; NAME STATE ---------- ----------- CRS MOUNTED DATA01 CONNECTED 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 1983099308 LENKA lenka PRIMARY 953598 NO
2 1983099308 LENKA lenka PRIMARY 953598 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
---------- ---------- ---------- ------------------------------ ---------------- ----------- ---
1 1983099308 LENKA lenka PRIMARY 953752 YES
2 1983099308 LENKA lenka PRIMARY 953752 YES
SQL>归档模式：启用【主库】
查看当前归档模式：
SQL> archive log list Database log mode No Archive Mode Automatic archival Disabled Archive destination /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch Oldest online log sequence 1 Current log sequence 2 SQL>
在RAC环境中，开启归档模式，首先需要停掉所有节点上运行的数据库实例：
停库：
[oracle@oracle-cluster-1 ~]$ su - grid Password: Last login: Wed Mar 22 16:32:49 CST 2017 on pts/1 [grid@oracle-cluster-1 ~]$ srvctl status database -d lenka Instance lenka1 is running on node oracle-cluster-1 Instance lenka2 is running on node oracle-cluster-2 [grid@oracle-cluster-1 ~]$ [grid@oracle-cluster-1 ~]$ srvctl stop database -d lenka [grid@oracle-cluster-1 ~]$ [grid@oracle-cluster-1 ~]$ srvctl status database -d lenka Instance lenka1 is not running on node oracle-cluster-1 Instance lenka2 is not running on node oracle-cluster-2 [grid@oracle-cluster-1 ~]$
在其中一个节点上启动数据库到【mount】并启用归档模式：
这里我们选择节点一【oracle-cluster-1】
[oracle@oracle-cluster-1 ~]$ ps -ef | grep pmon
oracle 9666 8068 0 17:03 pts/1 00:00:00 grep --color=auto pmon
grid 14621 1 0 13:55 ? 00:00:01 asm_pmon_+ASM1
[oracle@oracle-cluster-1 ~]$
[oracle@oracle-cluster-1 ~]$ env | grep SID
ORACLE_SID=lenka1
[oracle@oracle-cluster-1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 22 17:03:35 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 2421825536 bytes
Fixed Size 2255632 bytes
Variable Size 671089904 bytes
Database Buffers 1744830464 bytes
Redo Buffers 3649536 bytes
Database mounted.
SQL>
SQL> !ps -ef | grep pmon
oracle 9699 1 0 17:03 ? 00:00:00 ora_pmon_lenka1
oracle 9821 9672 0 17:04 pts/1 00:00:00 /bin/bash -c ps -ef | grep pmon
oracle 9823 9821 0 17:04 pts/1 00:00:00 grep pmon
grid 14621 1 0 13:55 ? 00:00:01 asm_pmon_+ASM1
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 1983099308 LENKA lenka PRIMARY 0 YES
SQL>
SQL> select inst_id,instance_name,status from gv$instance;
INST_ID INSTANCE_NAME STATUS
---------- ---------------- ------------
1 lenka1 MOUNTED
SQL>
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch
Oldest online log sequence 1
Current log sequence 2
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/11.2.0/dbhome_1/dbs/arch
Oldest online log sequence 1
Next log sequence to archive 2
Current log sequence 2
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 1983099308 LENKA lenka PRIMARY 0 YES
SQL> alter database open;
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
---------- ---------- --------- ------------------------------ ---------------- ----------- ---
1 1983099308 LENKA lenka PRIMARY 957176 YES
SQL>然后，另一个节点也启动实例：
[root@oracle-cluster-2 ~]# su - oracle Last login: Wed Mar 22 14:32:38 CST 2017 on pts/0 [oracle@oracle-cluster-2 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 22 17:07:25 2017 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 2421825536 bytes Fixed Size 2255632 bytes Variable Size 671089904 bytes Database Buffers 1744830464 bytes Redo Buffers 3649536 bytes Database mounted. Database opened. SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options [oracle@oracle-cluster-2 ~]$
再次查看：
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 1983099308 LENKA lenka PRIMARY 959330 YES
2 1983099308 LENKA lenka PRIMARY 959330 YES
SQL>这样，归档模式【RAC】就开启好了。
可以看到，当前，主库端的归档路径为：
/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch
但这个目录并不存在，创建：
[oracle@oracle-cluster-2 ~]$ mkdir /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch
[oracle@oracle-cluster-2 ~]$
分别在RAC的两个节点上执行日志切换，看看生成的归档：
SQL> alter system switch logfile; System altered. SQL>
节点一：
[oracle@oracle-cluster-1 arch]$ pwd /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch [oracle@oracle-cluster-1 arch]$ ls -ltr total 616 -rw-r----- 1 oracle asmadmin 611328 Mar 22 17:32 1_3_939308144.dbf -rw-r----- 1 oracle asmadmin 14848 Mar 22 17:34 1_4_939308144.dbf [oracle@oracle-cluster-1 arch]$
节点二：
[oracle@oracle-cluster-2 arch]$ pwd /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch [oracle@oracle-cluster-2 arch]$ [oracle@oracle-cluster-2 arch]$ ls -ltr total 264 -rw-r----- 1 oracle asmadmin 266752 Mar 22 17:33 2_3_939308144.dbf [oracle@oracle-cluster-2 arch]$ [oracle@oracle-cluster-2 arch]$
RMAN中查看归档：
[oracle@oracle-cluster-1 arch]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Wed Mar 22 17:36:52 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: LENKA (DBID=1983099308)
RMAN> list archivelog all;
using target database control file instead of recovery catalog
List of Archived Log Copies for database with db_unique_name LENKA
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - --------------------
2 1 2 A 22-MAR-2017 14:56:32
Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_2_939308144.dbf
4 1 3 A 22-MAR-2017 17:14:23
Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch/1_3_939308144.dbf
6 1 4 A 22-MAR-2017 17:32:45
Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch/1_4_939308144.dbf
1 2 1 A 22-MAR-2017 14:58:30
Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_1_939308144.dbf
3 2 2 A 22-MAR-2017 17:07:51
Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_2_939308144.dbf
5 2 3 A 22-MAR-2017 17:14:32
Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch/2_3_939308144.dbf
RMAN>RMAN执行数据库全备：
创建RMAN备份的存储目录：
[oracle@oracle-cluster-1 oracle]$ pwd /u01/app/oracle [oracle@oracle-cluster-1 oracle]$ [oracle@oracle-cluster-1 oracle]$ ls -ltr total 0 drwxr-xr-x. 3 oracle oinstall 19 Mar 21 21:57 product drwxrwxr-x 11 oracle oinstall 119 Mar 22 14:43 diag drwxr-x--- 3 oracle oinstall 18 Mar 22 14:50 admin drwxr-x--- 5 oracle oinstall 44 Mar 22 15:00 cfgtoollogs drwxr-xr-x 2 oracle oinstall 6 Mar 22 15:12 checkpoints [oracle@oracle-cluster-1 oracle]$ [oracle@oracle-cluster-1 oracle]$ mkdir rman_backup [oracle@oracle-cluster-1 oracle]$ [oracle@oracle-cluster-1 oracle]$ cd rman_backup/ [oracle@oracle-cluster-1 rman_backup]$ pwd /u01/app/oracle/rman_backup [oracle@oracle-cluster-1 rman_backup]$
删除刚才上面测试时候创建的归档日志：
[oracle@oracle-cluster-1 rman_backup]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Wed Mar 22 17:39:42 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: LENKA (DBID=1983099308)
RMAN> report need backup;
using target database control file instead of recovery catalog
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------
1 0 +DATA01/lenka/datafile/system.256.939307941
2 0 +DATA01/lenka/datafile/sysaux.257.939307941
3 0 +DATA01/lenka/datafile/undotbs1.258.939307943
4 0 +DATA01/lenka/datafile/users.259.939307943
5 0 +DATA01/lenka/datafile/undotbs2.264.939308211
RMAN>
RMAN> delete archivelog all;
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=54 instance=lenka1 device type=DISK
List of Archived Log Copies for database with db_unique_name LENKA
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - --------------------
2 1 2 A 22-MAR-2017 14:56:32
Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_2_939308144.dbf
4 1 3 A 22-MAR-2017 17:14:23
Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch/1_3_939308144.dbf
6 1 4 A 22-MAR-2017 17:32:45
Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch/1_4_939308144.dbf
1 2 1 A 22-MAR-2017 14:58:30
Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_1_939308144.dbf
3 2 2 A 22-MAR-2017 17:07:51
Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_2_939308144.dbf
5 2 3 A 22-MAR-2017 17:14:32
Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch/2_3_939308144.dbf
Do you really want to delete the above objects (enter YES or NO)? YES
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_2_939308144.dbf RECID=2 STAMP=939316464
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch/1_3_939308144.dbf RECID=4 STAMP=939317566
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch/1_4_939308144.dbf RECID=6 STAMP=939317684
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_1_939308144.dbf RECID=1 STAMP=939316030
Deleted 4 objects
RMAN-06207: WARNING: 2 objects could not be deleted for DISK channel(s) due
RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212: Object Type Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Archivelog /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_2_939308144.dbf
RMAN-06214: Archivelog /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch/2_3_939308144.dbf
RMAN> list backup;
specification does not match any backup in the repository
RMAN>
RMAN> list archivelog all;
specification does not match any archived log in the repository
RMAN>
RMAN> crosscheck archivelog all;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=35 instance=lenka1 device type=DISK
validation succeeded for archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch/1_5_939308144.dbf RECID=7 STAMP=939318531
validation succeeded for archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch/1_6_939308144.dbf RECID=10 STAMP=939336291
validation failed for archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch/2_4_939308144.dbf RECID=8 STAMP=939318532
validation failed for archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch/2_5_939308144.dbf RECID=9 STAMP=939333700
validation failed for archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch/2_6_939308144.dbf RECID=11 STAMP=939336292
Crosschecked 5 objects
RMAN> delete expired archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=35 instance=lenka1 device type=DISK
List of Archived Log Copies for database with db_unique_name LENKA
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - --------------------
8 2 4 X 22-MAR-2017 17:33:47
Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch/2_4_939308144.dbf
9 2 5 X 22-MAR-2017 17:48:51
Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch/2_5_939308144.dbf
11 2 6 X 22-MAR-2017 22:01:31
Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch/2_6_939308144.dbf
Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch/2_4_939308144.dbf RECID=8 STAMP=939318532
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch/2_5_939308144.dbf RECID=9 STAMP=939333700
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch/2_6_939308144.dbf RECID=11 STAMP=939336292
Deleted 3 EXPIRED objects
RMAN>开始执行备份：
[oracle@oracle-cluster-1 ~]$ cd rman_bak/
[oracle@oracle-cluster-1 rman_bak]$
[oracle@oracle-cluster-1 rman_bak]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Wed Mar 22 22:51:49 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: LENKA (DBID=1983099308, not open)
RMAN> run {
2> allocate channel c1 type disk;
3> backup database format '/home/oracle/rman_bak/FULL_%U.bk';
4> backup archivelog all format '/home/oracle/rman_bak/ARCH_%U.arch';
5> release channel c1;
6> }
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=1 instance=lenka1 device type=DISK
Starting backup at 22-MAR-2017 22:53:02
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA01/lenka/datafile/system.256.939307941
input datafile file number=00002 name=+DATA01/lenka/datafile/sysaux.257.939307941
input datafile file number=00005 name=+DATA01/lenka/datafile/undotbs2.264.939308211
input datafile file number=00003 name=+DATA01/lenka/datafile/undotbs1.258.939307943
input datafile file number=00004 name=+DATA01/lenka/datafile/users.259.939307943
channel c1: starting piece 1 at 22-MAR-2017 22:53:03
channel c1: finished piece 1 at 22-MAR-2017 22:53:28
piece handle=/home/oracle/rman_bak/FULL_0ervq92f_1_1.bk tag=TAG20170322T225302 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:25
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
including current control file in backup set
channel c1: starting piece 1 at 22-MAR-2017 22:53:35
channel c1: finished piece 1 at 22-MAR-2017 22:53:36
piece handle=/home/oracle/rman_bak/FULL_0frvq938_1_1.bk tag=TAG20170322T225302 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 22-MAR-2017 22:53:36
Starting backup at 22-MAR-2017 22:53:36
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=5 RECID=7 STAMP=939318531
input archived log thread=1 sequence=6 RECID=10 STAMP=939336291
input archived log thread=1 sequence=7 RECID=12 STAMP=939336811
channel c1: starting piece 1 at 22-MAR-2017 22:53:37
channel c1: finished piece 1 at 22-MAR-2017 22:53:40
piece handle=/home/oracle/rman_bak/ARCH_0grvq93h_1_1.arch tag=TAG20170322T225336 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:03
Finished backup at 22-MAR-2017 22:53:40
released channel: c1
RMAN> exit
Recovery Manager complete.
[oracle@oracle-cluster-1 rman_bak]$ pwd
/home/oracle/rman_bak
[oracle@oracle-cluster-1 rman_bak]$ ls -ltr
total 1107692
-rw-r----- 1 oracle asmadmin 1101791232 Mar 22 22:53 FULL_0ervq92f_1_1.bk
-rw-r----- 1 oracle asmadmin 18546688 Mar 22 22:53 FULL_0frvq938_1_1.bk
-rw-r----- 1 oracle asmadmin 13936640 Mar 22 22:53 ARCH_0grvq93h_1_1.arch
[oracle@oracle-cluster-1 rman_bak]$ du -sh *
14M ARCH_0grvq93h_1_1.arch
1.1G FULL_0ervq92f_1_1.bk
18M FULL_0frvq938_1_1.bk
[oracle@oracle-cluster-1 rman_bak]$备份控制文件：
[oracle@oracle-cluster-1 rman_bak]$ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Wed Mar 22 22:56:12 2017 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: LENKA (DBID=1983099308, not open) RMAN> backup device type disk format '/home/oracle/rman_bak/ctl_standby_%U.ctl' current controlfile for standby; Starting backup at 22-MAR-2017 22:56:24 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=35 instance=lenka1 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including standby control file in backup set channel ORA_DISK_1: starting piece 1 at 22-MAR-2017 22:56:28 channel ORA_DISK_1: finished piece 1 at 22-MAR-2017 22:56:31 piece handle=/home/oracle/rman_bak/ctl_standby_0hrvq98p_1_1.ctl tag=TAG20170322T225625 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03 Finished backup at 22-MAR-2017 22:56:31 RMAN>
初始化参数文件：
[oracle@oracle-cluster-1 rman_backup]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 22 18:44:45 2017 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> create pfile='/u01/app/oracle/rman_backup/init_lenka.ora' from spfile; File created. SQL>
备份目录状态：
[oracle@oracle-cluster-1 rman_bak]$ [oracle@oracle-cluster-1 rman_bak]$ ls -ltr total 1125804 -rw-r----- 1 oracle asmadmin 1101791232 Mar 22 22:53 FULL_0ervq92f_1_1.bk -rw-r----- 1 oracle asmadmin 18546688 Mar 22 22:53 FULL_0frvq938_1_1.bk -rw-r----- 1 oracle asmadmin 13936640 Mar 22 22:53 ARCH_0grvq93h_1_1.arch -rw-r----- 1 oracle asmadmin 18546688 Mar 22 22:56 ctl_standby_0hrvq98p_1_1.ctl [oracle@oracle-cluster-1 rman_bak]$ pwd /home/oracle/rman_bak [oracle@oracle-cluster-1 rman_bak]$
将主库的备份数据，传到备端：
[oracle@oracle-cluster-1 rman_bak]$ scp * oracle-cluster-3:/home/oracle/rman_bak oracle@oracle-cluster-3's password: ARCH_0grvq93h_1_1.arch 100% 13MB 13.3MB/s 00:00 ctl_standby_0hrvq98p_1_1.ctl 100% 18MB 17.7MB/s 00:01 FULL_0ervq92f_1_1.bk 100% 1051MB 50.0MB/s 00:21 FULL_0frvq938_1_1.bk 100% 18MB 17.7MB/s 00:00 [oracle@oracle-cluster-1 rman_bak]$ [oracle@oracle-cluster-1 ~]$ cd $ORACLE_HOME/dbs [oracle@oracle-cluster-1 dbs]$ ls arch hc_lenka1.dat initlenka1.ora init.ora orapwlenka1 snapcf_lenka1.f [oracle@oracle-cluster-1 dbs]$ [oracle@oracle-cluster-1 dbs]$ scp *lenka* oracle-cluster-3:/u01/app/rman_backup oracle@oracle-cluster-3's password: hc_lenka1.dat 100% 1544 1.5KB/s 00:00 initlenka1.ora 100% 39 0.0KB/s 00:00 orapwlenka1 100% 1536 1.5KB/s 00:00 snapcf_lenka1.f 100% 18MB 17.6MB/s 00:00 [oracle@oracle-cluster-1 dbs]$
备库端需要对密码文件作出修改：
[oracle@oracle-cluster-3 dbs]$ pwd /u01/app/oracle/product/11.2.0/dbhome_1/dbs [oracle@oracle-cluster-3 dbs]$ [oracle@oracle-cluster-3 dbs]$ ls -ltr | grep orapw -rw-r----- 1 oracle oinstall 1536 Mar 23 15:32 orapwlenka1 -rw-r----- 1 oracle oinstall 1536 Mar 23 15:32 orapwlenka [oracle@oracle-cluster-3 dbs]$
初始化参数：
主库：
[oracle@oracle-cluster-1 dbs]$ cat initlenka1.ora lenka1.__db_cache_size=1795162112 lenka2.__db_cache_size=1795162112 lenka1.__java_pool_size=16777216 lenka2.__java_pool_size=16777216 lenka1.__large_pool_size=33554432 lenka2.__large_pool_size=33554432 lenka1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment lenka2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment lenka1.__pga_aggregate_target=822083584 lenka2.__pga_aggregate_target=822083584 lenka1.__sga_target=2432696320 lenka2.__sga_target=2432696320 lenka1.__shared_io_pool_size=0 lenka2.__shared_io_pool_size=0 lenka1.__shared_pool_size=570425344 lenka2.__shared_pool_size=570425344 lenka1.__streams_pool_size=0 lenka2.__streams_pool_size=0 *.audit_file_dest='/u01/app/oracle/admin/lenka/adump' *.audit_trail='db' *.cluster_database=true *.compatible='11.2.0.4.0' *.control_files='+DATA01/lenka/controlfile/current.260.939308141' *.db_block_size=8192 *.db_create_file_dest='+DATA01' *.db_domain='' *.db_name='lenka' *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=lenkaXDB)' *.fal_client='lenka' *.fal_server='lenkadg' lenka1.instance_number=1 lenka2.instance_number=2 *.log_archive_config='dg_config=(lenka,lenkadg)' *.log_archive_dest_1='location=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch valid_for=(all_logfiles,all_roles) db_unique_name=lenka' *.log_archive_dest_2='service=lenkadg lgwr sync affirm valid_for=(online_logfiles,primary_role) db_unique_name=lenkadg' *.open_cursors=300 *.pga_aggregate_target=810549248 *.processes=150 *.remote_listener='scan1:1521' *.remote_login_passwordfile='exclusive' *.sga_target=2431647744 lenka2.thread=2 lenka1.thread=1 lenka1.undo_tablespace='UNDOTBS1' lenka2.undo_tablespace='UNDOTBS2' [oracle@oracle-cluster-1 dbs]$
备库：
[oracle@oracle-cluster-3 dbs]$ cat initlenka.ora lenkadg.__db_cache_size=1795162112 lenka.__db_cache_size=1811939328 lenkadg.__java_pool_size=16777216 lenka.__java_pool_size=16777216 lenkadg.__large_pool_size=33554432 lenka.__large_pool_size=83886080 lenkadg.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment lenka.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment lenkadg.__pga_aggregate_target=822083584 lenka.__pga_aggregate_target=822083584 lenkadg.__sga_target=2432696320 lenka.__sga_target=2432696320 lenkadg.__shared_io_pool_size=0 lenka.__shared_io_pool_size=0 lenkadg.__shared_pool_size=570425344 lenka.__shared_pool_size=503316480 lenkadg.__streams_pool_size=0 lenka.__streams_pool_size=0 *.audit_file_dest='/u01/app/oracle/admin/lenkadg/adump' *.audit_trail='db' *.cluster_database=false *.compatible='11.2.0.4.0' *.control_files='/u01/app/oracle/oradata/lenkadg/controlfile/ctl_lenkadg.ctl'#Restore Controlfile *.db_block_size=8192 *.db_create_file_dest='/u01/app/oracle/oradata' *.db_domain='' *.db_file_name_convert='+DATA01/lenka/','/u01/app/oracle/oradata/lenkadg/' *.db_name='lenka' *.db_unique_name='lenkadg' *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=lenkadgXDB)' *.fal_client='lenkadg' *.fal_server='lenka' *.log_archive_config='dg_config=(lenka,lenkadg)' *.log_archive_dest_1='location=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch valid_for=(all_logfiles,all_roles) db_unique_name=lenkadg' *.log_archive_dest_2='service=lenka1 lgwr sync affirm valid_for=(online_logfiles,primary_role) db_unique_name=lenka' *.log_archive_dest_3='service=lenka2 lgwr sync affirm valid_for=(online_logfiles,primary_role) db_unique_name=lenka' *.log_archive_dest_state_1='enable' *.log_archive_dest_state_2='enable' *.log_archive_dest_state_3='enable' *.log_file_name_convert='+DATA01/lenka/','/u01/app/oracle/oradata/lenkadg/' *.open_cursors=300 *.pga_aggregate_target=810549248 *.processes=150 *.remote_login_passwordfile='exclusive' *.service_names='lenkadg' *.sga_target=2431647744 *.standby_file_management='AUTO' *.thread=1 *.undo_tablespace='UNDOTBS1' [oracle@oracle-cluster-3 dbs]$
备库，创建相关目录：
[oracle@oracle-cluster-3 dbs]$ mkdir -p $ORACLE_BASE/admin/lenkadg/{adump,dpdump,hdump,pfile}
[oracle@oracle-cluster-3 dbs]$ mkdir -p $ORACLE_BASE/diag/rdbms/lenkadg
[oracle@oracle-cluster-3 dbs]$ mkdir -p $ORACLE_BASE/oradata/{lenkadg/{controlfile,datafile,onlinelog},LENKADG/onlinelog}
[oracle@oracle-cluster-3 dbs]$配置TNSNAME：
备库：
[oracle@oracle-cluster-3 oradata]$ cd $ORACLE_HOME/network/admin [oracle@oracle-cluster-3 admin]$ ls listener.ora listener.ora_orig_20170323 samples shrept.lst tnsnames.ora [oracle@oracle-cluster-3 admin]$ [oracle@oracle-cluster-3 admin]$ cat tnsnames.ora lenka = (DESCRIPTION = (address = (PROTOCOL=TCP)(HOST=scan1)(PORT=1521)) (connect_data= (SERVER=DEDICATED) (SERVICE_NAME=lenka) ) ) lenka1 = (DESCRIPTION = (address = (PROTOCOL=TCP)(HOST=oracle-cluster-1-vip)(PORT=1521)) (connect_data= (SERVER=DEDICATED) (SERVICE_NAME=lenka) ) ) lenka2 = (DESCRIPTION = (address = (PROTOCOL=TCP)(HOST=oracle-cluster-2-vip)(PORT=1521)) (connect_data= (SERVER=DEDICATED) (SERVICE_NAME=lenka) ) ) lenkadg = (DESCRIPTION = (address = (PROTOCOL=TCP)(HOST=oracle-cluster-3)(PORT=1521)) (connect_data= (SERVER=DEDICATED) (SERVICE_NAME=lenkadg) ) ) [oracle@oracle-cluster-3 admin]$ [oracle@oracle-cluster-3 admin]$
备库，测试到主库的连通性：
[oracle@oracle-cluster-3 admin]$ tnsping lenka1 TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 23-MAR-2017 15:54:01 Copyright (c) 1997, 2013, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (address = (PROTOCOL=TCP)(HOST=oracle-cluster-1-vip)(PORT=1521)) (connect_data= (SERVER=DEDICATED) (SERVICE_NAME=lenka))) OK (10 msec) [oracle@oracle-cluster-3 admin]$ [oracle@oracle-cluster-3 admin]$ tnsping lenka2 TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 23-MAR-2017 15:54:06 Copyright (c) 1997, 2013, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (address = (PROTOCOL=TCP)(HOST=oracle-cluster-2-vip)(PORT=1521)) (connect_data= (SERVER=DEDICATED) (SERVICE_NAME=lenka))) OK (0 msec) [oracle@oracle-cluster-3 admin]$ [oracle@oracle-cluster-3 admin]$ tnsping lenka TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 23-MAR-2017 15:54:12 Copyright (c) 1997, 2013, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (address = (PROTOCOL=TCP)(HOST=scan1)(PORT=1521)) (connect_data= (SERVER=DEDICATED) (SERVICE_NAME=lenka))) OK (0 msec) [oracle@oracle-cluster-3 admin]$ [oracle@oracle-cluster-3 admin]$ tnsping lenkadg TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 23-MAR-2017 15:54:16 Copyright (c) 1997, 2013, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (address = (PROTOCOL=TCP)(HOST=oracle-cluster-3)(PORT=1521)) (connect_data= (SERVER=DEDICATED) (SERVICE_NAME=lenkadg))) OK (0 msec) [oracle@oracle-cluster-3 admin]$
备库：
实例启动到NOMOUNT：
[oracle@oracle-cluster-3 admin]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 22 20:01:20 2017 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> create spfile from pfile='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initlenkadg.ora'; File created. SQL> SQL> startup nomount; ORACLE instance started. Total System Global Area 2421825536 bytes Fixed Size 2255632 bytes Variable Size 603981040 bytes Database Buffers 1811939328 bytes Redo Buffers 3649536 bytes SQL> SQL> select instance_name,status from v$instance; INSTANCE_NAME STATUS ---------------- ------------ lenka STARTED SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@oracle-cluster-3 admin]$ [oracle@oracle-cluster-3 admin]$
用RMAN恢复出备库端的库：
[oracle@oracle-cluster-3 ~]$ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Wed Mar 22 23:05:11 2017 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: LENKA (not mounted) RMAN> restore standby controlfile from '/home/oracle/rman_bak/ctl_standby_0hrvq98p_1_1.ctl'; Starting restore at 22-MAR-2017 23:06:08 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=19 device type=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 output file name=/u01/app/oracle/oradata/lenkadg/controlfile/ctl_lenkadg.ctl Finished restore at 22-MAR-2017 23:06:10 RMAN>
看看数据目录的情况：
[oracle@oracle-cluster-3 ~]$ ls -ltr /u01/app/oracle/oradata/lenkadg/controlfile/ total 18064 -rw-r----- 1 oracle oinstall 18497536 Mar 22 23:06 ctl_lenkadg.ctl [oracle@oracle-cluster-3 ~]$
将数据库启动到MOUNT阶段【备库】
[oracle@oracle-cluster-3 admin]$ ps -ef | grep pmon oracle 6439 1 0 20:01 ? 00:00:00 ora_pmon_lenka oracle 6565 4791 0 20:06 pts/0 00:00:00 grep --color=auto pmon [oracle@oracle-cluster-3 admin]$ [oracle@oracle-cluster-3 admin]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 22 20:07:18 2017 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.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 ---------------- ------------ lenka STARTED SQL> alter database mount; Database altered. SQL> select instance_name,status from v$instance; INSTANCE_NAME STATUS ---------------- ------------ lenka MOUNTED SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@oracle-cluster-3 admin]$
RMAN：开始恢复数据库
[oracle@oracle-cluster-3 ~]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Wed Mar 22 23:07:29 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: LENKA (DBID=1983099308, not open)
RMAN> list backup;
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
1 Full 9.20M DISK 00:00:56 22-MAR-2017 17:47:49
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20170322T174652
Piece Name: /u01/app/oracle/rman_backup/FULL_03rvpn4d_1_1.bak
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
3 Full 962701 22-MAR-2017 17:46:54 /u01/app/oracle/oradata/lenkadg/datafile/undotbs1.258.939307943
5 Full 962701 22-MAR-2017 17:46:54 /u01/app/oracle/oradata/lenkadg/datafile/undotbs2.264.939308211
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
2 Full 630.17M DISK 00:01:50 22-MAR-2017 17:48:42
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20170322T174652
Piece Name: /u01/app/oracle/rman_backup/FULL_01rvpn4c_1_1.bak
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
1 Full 962695 22-MAR-2017 17:46:53 /u01/app/oracle/oradata/lenkadg/datafile/system.256.939307941
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
3 Full 381.03M DISK 00:01:52 22-MAR-2017 17:48:45
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20170322T174652
Piece Name: /u01/app/oracle/rman_backup/FULL_02rvpn4d_1_1.bak
List of Datafiles in backup set 3
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
2 Full 962697 22-MAR-2017 17:46:53 /u01/app/oracle/oradata/lenkadg/datafile/sysaux.257.939307941
4 Full 962697 22-MAR-2017 17:46:53 /u01/app/oracle/oradata/lenkadg/datafile/users.259.939307943
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
4 Full 80.00K DISK 00:00:00 22-MAR-2017 17:48:49
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20170322T174652
Piece Name: /u01/app/oracle/rman_backup/FULL_05rvpn81_1_1.bak
SPFILE Included: Modification time: 22-MAR-2017 17:08:29
SPFILE db_unique_name: LENKA
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
5 Full 17.67M DISK 00:01:56 22-MAR-2017 17:48:50
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20170322T174652
Piece Name: /u01/app/oracle/rman_backup/FULL_04rvpn4e_1_1.bak
Control File Included: Ckp SCN: 962702 Ckp time: 22-MAR-2017 17:46:55
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
9 Full 1022.71M DISK 00:00:26 22-MAR-2017 20:17:05
BP Key: 9 Status: AVAILABLE Compressed: NO Tag: TAG20170322T201639
Piece Name: /u01/app/oracle/rman_backup/FULL_09rvpvt7_1_1.bak
List of Datafiles in backup set 9
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
1 Full 978564 22-MAR-2017 20:16:39 /u01/app/oracle/oradata/lenkadg/datafile/system.256.939307941
2 Full 978564 22-MAR-2017 20:16:39 /u01/app/oracle/oradata/lenkadg/datafile/sysaux.257.939307941
3 Full 978564 22-MAR-2017 20:16:39 /u01/app/oracle/oradata/lenkadg/datafile/undotbs1.258.939307943
4 Full 978564 22-MAR-2017 20:16:39 /u01/app/oracle/oradata/lenkadg/datafile/users.259.939307943
5 Full 978564 22-MAR-2017 20:16:39 /u01/app/oracle/oradata/lenkadg/datafile/undotbs2.264.939308211
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
10 Full 17.70M DISK 00:00:04 22-MAR-2017 20:17:18
BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20170322T201639
Piece Name: /u01/app/oracle/rman_backup/FULL_0arvpvua_1_1.bak
SPFILE Included: Modification time: 22-MAR-2017 17:08:29
SPFILE db_unique_name: LENKA
Control File Included: Ckp SCN: 978585 Ckp time: 22-MAR-2017 20:17:14
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
11 Full 17.67M DISK 00:00:03 22-MAR-2017 20:18:07
BP Key: 11 Status: AVAILABLE Compressed: NO Tag: TAG20170322T201804
Piece Name: /u01/app/oracle/rman_backup/standby_ctrl_0brvpvvs_1_1.ctl
Standby Control File Included: Ckp SCN: 978648 Ckp time: 22-MAR-2017 20:18:04
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
12 Full 1.03G DISK 00:02:02 22-MAR-2017 22:44:38
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20170322T224236
Piece Name: /home/oracle/rman_bak/FULL_0crvq8es_1_1.bk
List of Datafiles in backup set 12
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
1 Full 1000255 22-MAR-2017 22:42:37 /u01/app/oracle/oradata/lenkadg/datafile/system.256.939307941
2 Full 1000255 22-MAR-2017 22:42:37 /u01/app/oracle/oradata/lenkadg/datafile/sysaux.257.939307941
3 Full 1000255 22-MAR-2017 22:42:37 /u01/app/oracle/oradata/lenkadg/datafile/undotbs1.258.939307943
4 Full 1000255 22-MAR-2017 22:42:37 /u01/app/oracle/oradata/lenkadg/datafile/users.259.939307943
5 Full 1000255 22-MAR-2017 22:42:37 /u01/app/oracle/oradata/lenkadg/datafile/undotbs2.264.939308211
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
13 Full 17.70M DISK 00:00:05 22-MAR-2017 22:44:47
BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20170322T224236
Piece Name: /home/oracle/rman_bak/FULL_0drvq8iq_1_1.bk
SPFILE Included: Modification time: 22-MAR-2017 17:08:29
SPFILE db_unique_name: LENKA
Control File Included: Ckp SCN: 1000414 Ckp time: 22-MAR-2017 22:44:42
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
14 Full 1.03G DISK 00:00:24 22-MAR-2017 22:53:27
BP Key: 14 Status: AVAILABLE Compressed: NO Tag: TAG20170322T225302
Piece Name: /home/oracle/rman_bak/FULL_0ervq92f_1_1.bk
List of Datafiles in backup set 14
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
1 Full 1000614 22-MAR-2017 22:47:30 /u01/app/oracle/oradata/lenkadg/datafile/system.256.939307941
2 Full 1000614 22-MAR-2017 22:47:30 /u01/app/oracle/oradata/lenkadg/datafile/sysaux.257.939307941
3 Full 1000614 22-MAR-2017 22:47:30 /u01/app/oracle/oradata/lenkadg/datafile/undotbs1.258.939307943
4 Full 1000614 22-MAR-2017 22:47:30 /u01/app/oracle/oradata/lenkadg/datafile/users.259.939307943
5 Full 1000614 22-MAR-2017 22:47:30 /u01/app/oracle/oradata/lenkadg/datafile/undotbs2.264.939308211
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
15 Full 17.67M DISK 00:00:07 22-MAR-2017 22:53:35
BP Key: 15 Status: AVAILABLE Compressed: NO Tag: TAG20170322T225302
Piece Name: /home/oracle/rman_bak/FULL_0frvq938_1_1.bk
Control File Included: Ckp SCN: 1000614 Ckp time: 22-MAR-2017 22:47:30
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
16 13.29M DISK 00:00:01 22-MAR-2017 22:53:38
BP Key: 16 Status: AVAILABLE Compressed: NO Tag: TAG20170322T225336
Piece Name: /home/oracle/rman_bak/ARCH_0grvq93h_1_1.arch
List of Archived Logs in backup set 16
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 5 961514 22-MAR-2017 17:34:44 962805 22-MAR-2017 17:48:50
1 6 962805 22-MAR-2017 17:48:50 1000433 22-MAR-2017 22:44:50
1 7 1000433 22-MAR-2017 22:44:50 1000592 22-MAR-2017 22:47:26
RMAN>
RMAN> crosscheck backup;
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=28 device type=DISK
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/oracle/rman_backup/FULL_03rvpn4d_1_1.bak RECID=1 STAMP=939318420
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/oracle/rman_backup/FULL_01rvpn4c_1_1.bak RECID=2 STAMP=939318413
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/oracle/rman_backup/FULL_02rvpn4d_1_1.bak RECID=3 STAMP=939318414
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/oracle/rman_backup/FULL_05rvpn81_1_1.bak RECID=4 STAMP=939318529
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/oracle/rman_backup/FULL_04rvpn4e_1_1.bak RECID=5 STAMP=939318529
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/rman_backup/FULL_09rvpvt7_1_1.bak RECID=9 STAMP=939327400
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/rman_backup/FULL_0arvpvua_1_1.bak RECID=10 STAMP=939327437
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/rman_backup/standby_ctrl_0brvpvvs_1_1.ctl RECID=11 STAMP=939327487
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/rman_bak/FULL_0crvq8es_1_1.bk RECID=12 STAMP=939336157
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/rman_bak/FULL_0drvq8iq_1_1.bk RECID=13 STAMP=939336285
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/home/oracle/rman_bak/FULL_0ervq92f_1_1.bk RECID=14 STAMP=939336783
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/home/oracle/rman_bak/FULL_0frvq938_1_1.bk RECID=15 STAMP=939336815
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/home/oracle/rman_bak/ARCH_0grvq93h_1_1.arch RECID=16 STAMP=939336817
Crosschecked 13 objects
RMAN> delete expired backup;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
1 1 1 1 EXPIRED DISK /u01/app/oracle/rman_backup/FULL_03rvpn4d_1_1.bak
2 2 1 1 EXPIRED DISK /u01/app/oracle/rman_backup/FULL_01rvpn4c_1_1.bak
3 3 1 1 EXPIRED DISK /u01/app/oracle/rman_backup/FULL_02rvpn4d_1_1.bak
4 4 1 1 EXPIRED DISK /u01/app/oracle/rman_backup/FULL_05rvpn81_1_1.bak
5 5 1 1 EXPIRED DISK /u01/app/oracle/rman_backup/FULL_04rvpn4e_1_1.bak
12 12 1 1 EXPIRED DISK /home/oracle/rman_bak/FULL_0crvq8es_1_1.bk
13 13 1 1 EXPIRED DISK /home/oracle/rman_bak/FULL_0drvq8iq_1_1.bk
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/u01/app/oracle/rman_backup/FULL_03rvpn4d_1_1.bak RECID=1 STAMP=939318420
deleted backup piece
backup piece handle=/u01/app/oracle/rman_backup/FULL_01rvpn4c_1_1.bak RECID=2 STAMP=939318413
deleted backup piece
backup piece handle=/u01/app/oracle/rman_backup/FULL_02rvpn4d_1_1.bak RECID=3 STAMP=939318414
deleted backup piece
backup piece handle=/u01/app/oracle/rman_backup/FULL_05rvpn81_1_1.bak RECID=4 STAMP=939318529
deleted backup piece
backup piece handle=/u01/app/oracle/rman_backup/FULL_04rvpn4e_1_1.bak RECID=5 STAMP=939318529
deleted backup piece
backup piece handle=/home/oracle/rman_bak/FULL_0crvq8es_1_1.bk RECID=12 STAMP=939336157
deleted backup piece
backup piece handle=/home/oracle/rman_bak/FULL_0drvq8iq_1_1.bk RECID=13 STAMP=939336285
Deleted 7 EXPIRED objects
RMAN>
[oracle@oracle-cluster-3 lenkadg]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Wed Mar 22 23:12:18 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: LENKA (DBID=1983099308, 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=19 device type=DISK
Starting restore at 22-MAR-2017 23:12:47
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00001 to /u01/app/oracle/oradata/lenkadg/datafile/system.256.939307941
channel c1: restoring datafile 00002 to /u01/app/oracle/oradata/lenkadg/datafile/sysaux.257.939307941
channel c1: restoring datafile 00003 to /u01/app/oracle/oradata/lenkadg/datafile/undotbs1.258.939307943
channel c1: restoring datafile 00004 to /u01/app/oracle/oradata/lenkadg/datafile/users.259.939307943
channel c1: restoring datafile 00005 to /u01/app/oracle/oradata/lenkadg/datafile/undotbs2.264.939308211
channel c1: reading from backup piece /home/oracle/rman_bak/FULL_0ervq92f_1_1.bk
channel c1: piece handle=/home/oracle/rman_bak/FULL_0ervq92f_1_1.bk tag=TAG20170322T225302
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:02:25
Finished restore at 22-MAR-2017 23:15:12
released channel: c1
RMAN> exit
Recovery Manager complete.
[oracle@oracle-cluster-3 lenkadg]$创建STANDBY LOGFILE【备库】
[oracle@oracle-cluster-3 lenkadg]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 22 23:20:55 2017 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select name,database_role,open_mode from v$database; NAME DATABASE_ROLE OPEN_MODE --------- ---------------- -------------------- LENKA PHYSICAL STANDBY MOUNTED SQL> set linesize 400 SQL> col name for a65 SQL> SQL> select name from v$datafile 2 union 3 select name from v$controlfile 4 union 5 select member from v$logfile; NAME ----------------------------------------------------------------- /u01/app/oracle/oradata/lenkadg/controlfile/ctl_lenkadg.ctl /u01/app/oracle/oradata/lenkadg/datafile/sysaux.257.939307941 /u01/app/oracle/oradata/lenkadg/datafile/system.256.939307941 /u01/app/oracle/oradata/lenkadg/datafile/undotbs1.258.939307943 /u01/app/oracle/oradata/lenkadg/datafile/undotbs2.264.939308211 /u01/app/oracle/oradata/lenkadg/datafile/users.259.939307943 /u01/app/oracle/oradata/lenkadg/onlinelog/group_1.261.939308145 /u01/app/oracle/oradata/lenkadg/onlinelog/group_2.262.939308151 /u01/app/oracle/oradata/lenkadg/onlinelog/group_3.265.939308299 /u01/app/oracle/oradata/lenkadg/onlinelog/group_4.266.939308305 10 rows selected. SQL>
增加STANDBY日志文件：
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>
SQL> select name from v$datafile
2 union
3 select name from v$controlfile
4 union
5 select member from v$logfile;
NAME
-----------------------------------------------------------------
/u01/app/oracle/oradata/LENKADG/onlinelog/o1_mf_10_df55slz5_.log
/u01/app/oracle/oradata/LENKADG/onlinelog/o1_mf_5_df55rm29_.log
/u01/app/oracle/oradata/LENKADG/onlinelog/o1_mf_6_df55rm4l_.log
/u01/app/oracle/oradata/LENKADG/onlinelog/o1_mf_7_df55rmv2_.log
/u01/app/oracle/oradata/LENKADG/onlinelog/o1_mf_8_df55sh6o_.log
/u01/app/oracle/oradata/LENKADG/onlinelog/o1_mf_9_df55shc8_.log
/u01/app/oracle/oradata/lenkadg/controlfile/ctl_lenkadg.ctl
/u01/app/oracle/oradata/lenkadg/datafile/sysaux.257.939307941
/u01/app/oracle/oradata/lenkadg/datafile/system.256.939307941
/u01/app/oracle/oradata/lenkadg/datafile/undotbs1.258.939307943
/u01/app/oracle/oradata/lenkadg/datafile/undotbs2.264.939308211
NAME
-----------------------------------------------------------------
/u01/app/oracle/oradata/lenkadg/datafile/users.259.939307943
/u01/app/oracle/oradata/lenkadg/onlinelog/group_1.261.939308145
/u01/app/oracle/oradata/lenkadg/onlinelog/group_2.262.939308151
/u01/app/oracle/oradata/lenkadg/onlinelog/group_3.265.939308299
/u01/app/oracle/oradata/lenkadg/onlinelog/group_4.266.939308305
16 rows selected.
SQL>
SQL> col dbid for a19
SQL> select * from v$standby_log;
GROUP# DBID THREAD# SEQUENCE# BYTES BLOCKSIZE USED ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME LAST_CHANGE# LAST_TIME
---------- ------------------- ---------- ---------- ---------- ---------- ---------- --- ---------- ------------- --------- ------------ --------- ------------ ---------
5 UNASSIGNED 1 0 52428800 512 0 YES UNASSIGNED
6 UNASSIGNED 1 0 52428800 512 0 YES UNASSIGNED
7 UNASSIGNED 1 0 52428800 512 0 YES UNASSIGNED
8 UNASSIGNED 2 0 52428800 512 0 YES UNASSIGNED
9 UNASSIGNED 2 0 52428800 512 0 YES UNASSIGNED
10 UNASSIGNED 2 0 52428800 512 0 YES UNASSIGNED
6 rows selected.
SQL>
SQL> col member for a65
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- ----------------------------------------------------------------- ---
2 ONLINE /u01/app/oracle/oradata/lenkadg/onlinelog/group_2.262.939308151 NO
1 ONLINE /u01/app/oracle/oradata/lenkadg/onlinelog/group_1.261.939308145 NO
3 ONLINE /u01/app/oracle/oradata/lenkadg/onlinelog/group_3.265.939308299 NO
4 ONLINE /u01/app/oracle/oradata/lenkadg/onlinelog/group_4.266.939308305 NO
5 STANDBY /u01/app/oracle/oradata/LENKADG/onlinelog/o1_mf_5_df55rm29_.log NO
6 STANDBY /u01/app/oracle/oradata/LENKADG/onlinelog/o1_mf_6_df55rm4l_.log NO
7 STANDBY /u01/app/oracle/oradata/LENKADG/onlinelog/o1_mf_7_df55rmv2_.log NO
8 STANDBY /u01/app/oracle/oradata/LENKADG/onlinelog/o1_mf_8_df55sh6o_.log NO
9 STANDBY /u01/app/oracle/oradata/LENKADG/onlinelog/o1_mf_9_df55shc8_.log NO
10 STANDBY /u01/app/oracle/oradata/LENKADG/onlinelog/o1_mf_10_df55slz5_.log NO
10 rows selected.
SQL>监听器：
主库：节点一
[oracle@oracle-cluster-1 dbs]$ cd $ORACLE_HOME/network/admin
[oracle@oracle-cluster-1 admin]$ ls -ltr
total 28
-rw-r--r-- 1 oracle oinstall 381 Dec 17 2012 shrept.lst
drwxr-xr-x 2 oracle oinstall 61 Mar 22 14:27 samples
-rw-r--r-- 1 oracle oinstall 815 Mar 23 11:42 tnsnames17032311AM4226.bak
-rw-r--r-- 1 oracle oinstall 815 Mar 23 11:55 tnsnames17032311AM5510.bak
-rw-r--r-- 1 oracle oinstall 211 Mar 23 11:56 endpoints_listener.ora
-rw-r--r-- 1 oracle oinstall 187 Mar 23 14:52 listener.ora_orig_20170323
-rw-r----- 1 oracle oinstall 1999 Mar 23 14:57 tnsnames.ora
-rw-r--r-- 1 oracle oinstall 408 Mar 23 15:07 listener.ora
[oracle@oracle-cluster-1 admin]$
[oracle@oracle-cluster-1 admin]$ cat listener.ora
LISTENER_ORACLE=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_ORACLE)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_ORACLE=ON # line added by Agent
# ---------------
ADR_BASE_LISTENER = /u01/app/oracle
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = lenka)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = lenka1)
)
)
[oracle@oracle-cluster-1 admin]$主库：节点二
[oracle@oracle-cluster-2 ~]$ cd $ORACLE_HOME/network/admin
[oracle@oracle-cluster-2 admin]$ ls
endpoints_listener.ora listener.ora samples shrept.lst tnsnames.ora
[oracle@oracle-cluster-2 admin]$
[oracle@oracle-cluster-2 admin]$ cat listener.ora
LISTENER_ORACLE=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_ORACLE)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_ORACLE=ON # line added by Agent
# -------------
ADR_BASE_LISTENER = /u01/app/oracle
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = lenka)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = lenka2)
)
)
[oracle@oracle-cluster-2 admin]$备库：
[oracle@oracle-cluster-3 admin]$ pwd
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin
[oracle@oracle-cluster-3 admin]$
[oracle@oracle-cluster-3 admin]$ ls -ltr
total 16
-rw-r--r--. 1 oracle oinstall 381 Dec 17 2012 shrept.lst
drwxr-xr-x. 2 oracle oinstall 61 Mar 22 16:00 samples
-rw-r--r-- 1 oracle oinstall 381 Mar 23 14:52 listener.ora_orig_20170323
-rw-r--r-- 1 oracle oinstall 547 Mar 23 15:09 listener.ora
-rw-r--r-- 1 oracle oinstall 1607 Mar 23 15:25 tnsnames.ora
[oracle@oracle-cluster-3 admin]$
[oracle@oracle-cluster-3 admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle-cluster-3)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = lenkadg)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = lenka)
)
)
[oracle@oracle-cluster-3 admin]$然后就可以启动备库的DG了：
alter database recover managed standby database disconnect from session;
按照上面的配置，… 最后 RAC + DG 可以正确的配起来。
—————————————————————————
最后，关于主备库的参数文件的差异，统计了一下：
| 参数 | 主库端 | 备库端 |
| db_name | orcl | orcl |
| db_unique_name | orcl | orcldg |
| log_archive_config | dg_config=(orcl,orcldg) | dg_config=(orcl,orcldg) |
| log_archive_dest_1 | location=/u01/archivelog valid_for=(all_logfiles,all_roles) db_unique_name=orcl | location=/u01/archivelog valid_for=(all_logfiles,all_roles) db_unique_name=orcldg |
| log_archive_dest_2 | service=lenkadg reopen=120 lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=lenkadg | service=orcl reopen=120 lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=orcl |
| log_archive_dest_state_1 | enable | enable |
| log_archive_dest_state_2 | enable | enable |
| standby_file_management | auto | auto |
| fal_server | orcldg | orcl |
| fal_client | orcl | orcldg |
| log_file_name_convert | ‘/u01/app/oracle/oradata/orcl’,’/u01/app/oracle/oradata/orcl_standby’ | |
| data_file_name_convert | ‘/u01/app/oracle/oradata/orcl’,’/u01/app/oracle/oradata/orcl_standby’ |
对于集群环境，主库修改参数的时候，类似下面这样，可以在所有的节点上都变化参数：
alter system set log_archive_config='dg_config=(lenka,lenkadg)' scope=both sid='*'; alter system set log_archive_dest_1='location=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch valid_for=(all_logfiles,all_roles) db_unique_name=lenka' scope=both sid='*'; alter system set log_archive_dest_2='service=lenkadg lgwr sync affirm valid_for=(online_logfiles,primary_role) db_unique_name=lenkadg' scope=both sid='*'; alter system set fal_server='orcldg' scope=both sid='*'; alter system set fal_client='orcl' scope=both sid='*';
如果数据库使用的监听器不是默认端口，可能还需要关注以下两个参数：
local_listener
remote_listener
主：
[oracle@oracle-cluster-1 admin]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Mar 23 16:05:32 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> show parameter listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=
10.158.1.94)(PORT=1521))
remote_listener string scan1:1521
SQL>
备：
[oracle@oracle-cluster-3 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Mar 23 16:05:51 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string
remote_listener string
SQL>————————————
Done。