Oracle 11g 搭建DG(ADG方式)
1.准备工作
系统版本: Red Hat Enterprise Linux 6.5(64位)
软件版本:Oracle Database 11g Release 2 (11.2.0.4)
首先得准备两个能够PING通,并且装了Oracle软件且已经建库的Linux虚拟机。操作系统不限,至少有一个虚拟机已经建好库,最好两个都建好相同SID的库,这样少很多创建目录的麻烦,这里库的SID都是orcl,Linux严格区分大小写,所以SID的大小写得注意。
我这里有两个名为PD和ST的Linux虚拟机。
PD:192.168.56.42(主库)
ST:192.168.56.43(备库)
2.在主库进行操作
2.1强制force logging
- SQL> shutdown immediate
- Database closed.
- Database dismounted.
- ORACLE instance shut down.
- SQL> startup mount
- ORACLE instance started.
- Total System Global Area 1653518336 bytes
- Fixed Size 2253784 bytes
- Variable Size 1006636072 bytes
- Database Buffers 637534208 bytes
- Redo Buffers 7094272 bytes
- Database mounted.
- SQL> alter database force logging; --修改数据库为强制记日志,这是必须的操作,主库的每一步操作都得记录到日志中去。
- Database altered.
2.2开启主库的归档模式
- SQL> alter database archivelog; --修改数据库为归档模式,因为dg是通过传送归档日志到备库然后应用来保证主备库一致的。
- Database altered.
2.3创建standby redo log
- SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 ('/u01/app/oracle/oradata/orcl/redo04.log') size 50M;
- Database altered.
- SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 5 ('/u01/app/oracle/oradata/orcl/redo05.log') size 50M;
- Database altered.
- SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 6 ('/u01/app/oracle/oradata/orcl/redo06.log') size 50M;
- Database altered.
- SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 7 ('/u01/app/oracle/oradata/orcl/redo07.log') size 50M;
- Database altered.
- SQL> select group#,type,member from v$logfile;
- GROUP# TYPE MEMBER
- ---------- ------- --------------------------------------------------
- 3 ONLINE /u01/app/oracle/oradata/orcl/redo03.log
- 2 ONLINE /u01/app/oracle/oradata/orcl/redo02.log
- 1 ONLINE /u01/app/oracle/oradata/orcl/redo01.log
- 4 STANDBY /u01/app/oracle/oradata/orcl/redo04.log
- 5 STANDBY /u01/app/oracle/oradata/orcl/redo05.log
- 6 STANDBY /u01/app/oracle/oradata/orcl/redo06.log
- 7 STANDBY /u01/app/oracle/oradata/orcl/redo07.log
2.4创建pfile
- SQL> create pfile from spfile;--这里创建pfile是为了做一些主库参数的配置,并且还得拷贝到备库再次修改成备库的配置。
- File created.
- SQL> shutdown immediate
- Database closed.
- Database dismounted.
- ORACLE instance shut down.
2.5创建主库归档目录
- [oracle@PD orcl]$ mkdir archivelog --建立这个目录是为了存放主库的归档日志文件,并且这个目录会和其他数据文件等等一起拷贝到备库。
- [oracle@PD orcl]$ cd archivelog/
- [oracle@PD archivelog]$ ls
- [oracle@PD archivelog]$ pwd
- /u01/app/oracle/oradata/orcl/archivelog
2.6在主备库同时创建静态监听listener和tnsname
建议用net manager建立
主库orcl_pd:192.168.56.42
- [oracle@PD 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.
- SID_LIST_LISTENER =
- (SID_LIST =
- (SID_DESC =
- (GLOBAL_DBNAME = orcl)
- (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
- (SID_NAME = orcl)
- )
- )
- LISTENER =
- (DESCRIPTION_LIST =
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
- )
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
- )
- )
- ADR_BASE_LISTENER = /u01/app/oracle
- [oracle@PD admin]$ cat tnsnames.ora
- # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
- # Generated by Oracle configuration tools.
- ORCL_ST =
- (DESCRIPTION =
- (ADDRESS_LIST =
- (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.43)(PORT = 1521))
- )
- (CONNECT_DATA =
- (SERVICE_NAME = orcl)
- )
- )
- ORCL =
- (DESCRIPTION =
- (ADDRESS_LIST =
- (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
- )
- (CONNECT_DATA =
- (SERVER = DEDICATED)
- (SERVICE_NAME = orcl)
- )
- )
- ORCL_PD =
- (DESCRIPTION =
- (ADDRESS_LIST =
- (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.42)(PORT = 1521))
- )
- (CONNECT_DATA =
- (SERVICE_NAME = orcl)
- )
- )
- [oracle@PD orcl]$ lsnrctl
- LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 21-MAR-2016 00:59:09
- Copyright (c) 1991, 2013, Oracle. All rights reserved.
- Welcome to LSNRCTL, type "help" for information.
- LSNRCTL> status
- Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
- TNS-12541: TNS:no listener
- TNS-12560: TNS:protocol adapter error
- TNS-00511: No listener
- Linux Error: 111: Connection refused
- Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
- TNS-12541: TNS:no listener
- TNS-12560: TNS:protocol adapter error
- TNS-00511: No listener
- Linux Error: 111: Connection refused
- LSNRCTL> start
- Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
- TNSLSNR for Linux: Version 11.2.0.4.0 - Production
- System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
- Log messages written to /u01/app/oracle/diag/tnslsnr/PD/listener/alert/log.xml
- Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
- Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PD)(PORT=1521)))
- Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
- STATUS of the LISTENER
- ------------------------
- Alias LISTENER
- Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
- Start Date 21-MAR-2016 00:59:16
- 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/11.2.0/dbhome_1/network/admin/listener.ora
- Listener Log File /u01/app/oracle/diag/tnslsnr/PD/listener/alert/log.xml
- Listening Endpoints Summary...
- (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
- (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PD)(PORT=1521)))
- Services Summary...
- Service "orcl" has 1 instance(s).
- Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
- The command completed successfully
- LSNRCTL> exit
备库orcl_pd:192.168.56.43
- [oracle@ST 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.
- SID_LIST_LISTENER =
- (SID_LIST =
- (SID_DESC =
- (GLOBAL_DBNAME = orcl)
- (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
- (SID_NAME = orcl)
- )
- )
- LISTENER =
- (DESCRIPTION_LIST =
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
- )
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
- )
- )
- ADR_BASE_LISTENER = /u01/app/oracle
- [oracle@ST admin]$ cat tnsnames.ora
- # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
- # Generated by Oracle configuration tools.
- ORCL_ST =
- (DESCRIPTION =
- (ADDRESS_LIST =
- (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.43)(PORT = 1521))
- )
- (CONNECT_DATA =
- (SERVICE_NAME = orcl)
- )
- )
- ORCL =
- (DESCRIPTION =
- (ADDRESS_LIST =
- (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
- )
- (CONNECT_DATA =
- (SERVER = DEDICATED)
- (SERVICE_NAME = orcl)
- )
- )
- ORCL_PD =
- (DESCRIPTION =
- (ADDRESS_LIST =
- (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.42)(PORT = 1521))
- )
- (CONNECT_DATA =
- (SERVICE_NAME = orcl)
- )
- )
- [oracle@ST dbs]$ lsnrctl
- LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 19-MAR-2016 21:10:49
- Copyright (c) 1991, 2013, Oracle. All rights reserved.
- Welcome to LSNRCTL, type "help" for information.
- LSNRCTL> status
- Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
- TNS-12541: TNS:no listener
- TNS-12560: TNS:protocol adapter error
- TNS-00511: No listener
- Linux Error: 2: No such file or directory
- Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
- TNS-12541: TNS:no listener
- TNS-12560: TNS:protocol adapter error
- TNS-00511: No listener
- Linux Error: 111: Connection refused
- LSNRCTL> start
- Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
- TNSLSNR for Linux: Version 11.2.0.4.0 - Production
- System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
- Log messages written to /u01/app/oracle/diag/tnslsnr/ST/listener/alert/log.xml
- Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
- Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ST)(PORT=1521)))
- Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
- STATUS of the LISTENER
- ------------------------
- Alias LISTENER
- Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
- Start Date 19-MAR-2016 21:10:53
- 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/11.2.0/dbhome_1/network/admin/listener.ora
- Listener Log File /u01/app/oracle/diag/tnslsnr/ST/listener/alert/log.xml
- Listening Endpoints Summary...
- (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
- (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ST)(PORT=1521)))
- Services Summary...
- Service "orcl" has 1 instance(s).
- Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
- The command completed successfully
2.7修改主库pfile文件
- [oracle@PD dbs]$ vi initorcl.ora
- orcl.__db_cache_size=637534208
- orcl.__java_pool_size=16777216
- orcl.__large_pool_size=83886080
- orcl.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
- orcl.__pga_aggregate_target=671088640
- orcl.__sga_target=989855744
- orcl.__shared_io_pool_size=0
- orcl.__shared_pool_size=234881024
- orcl.__streams_pool_size=0
- *.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
- *.audit_trail='db'
- *.compatible='11.2.0.4.0'
- *.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/fast_recovery_area/orcl/control02.ctl'
- *.db_block_size=8192
- *.db_domain=''
- *.db_name='orcl'
- *.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
- *.db_recovery_file_dest_size=4385144832
- *.diagnostic_dest='/u01/app/oracle'
- *.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
- *.memory_target=1657798656
- *.open_cursors=300
- *.processes=150
- *.remote_login_passwordfile='EXCLUSIVE'
- *.undo_tablespace='UNDOTBS1'
- --下面这个是为了搭建DG添加的配置参数,主备库是有区分的,请注意
- DB_UNIQUE_NAME=orcl_pd
- LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl_pd,orcl_st)'
- LOG_ARCHIVE_DEST_1=
- 'LOCATION=/u01/app/oracle/oradata/orcl/archivelog
- VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
- DB_UNIQUE_NAME=orcl_pd'
- LOG_ARCHIVE_DEST_2=
- 'SERVICE=orcl_st ASYNC
- VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
- DB_UNIQUE_NAME=orcl_st'
- LOG_ARCHIVE_DEST_STATE_1=ENABLE
- LOG_ARCHIVE_DEST_STATE_2=ENABLE
- REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
- LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
- FAL_SERVER=orcl_st
- STANDBY_FILE_MANAGEMENT=AUTO
2.8用pfile启动主库,并创建spfile
- SQL> shutdown immediate
- ORA-01109: database not open
- Database dismounted.
- ORACLE instance shut down.
- SQL> startup nomount pfile='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora'
- ORACLE instance started.
- Total System Global Area 1653518336 bytes
- Fixed Size 2253784 bytes
- Variable Size 1006636072 bytes
- Database Buffers 637534208 bytes
- Redo Buffers 7094272 bytes
- SQL> create spfile from pfile;
- File created.
2.9创建主备库的备份目录
主库
- [oracle@PD orcl]$ mkdir /u01/app/oracle/oradata/orcl/backup
- [oracle@PD orcl]$ mkdir /u01/app/oracle/oradata/orcl/backup
2.10将口令验证文件和pfile发送到备库
- <pre name="code" class="sql">[oracle@PD dbs]$ pwd
- /u01/app/oracle/product/11.2.0/dbhome_1/dbs
- [oracle@PD dbs]$ scp orapworcl 192.168.56.43:/u01/app/oracle/product/11.2.0/dbhome_1/dbs/
- oracle@192.168.56.43's password:
- orapworcl 100% 1536 1.5KB/s 00:00
- [oracle@PD dbs]$ scp initorcl.ora 192.168.56.43:/u01/app/oracle/product/11.2.0/dbhome_1/dbs/
- oracle@192.168.56.43's password:
- initorcl.ora 100% 1408 1.4KB/s 00:00
3.在主库做一些操作
3.1在备库修改从主库拷贝来的pfile
- [oracle@ST dbs]$ cat initorcl.ora
- orcl.__db_cache_size=637534208
- orcl.__java_pool_size=16777216
- orcl.__large_pool_size=83886080
- orcl.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
- orcl.__pga_aggregate_target=671088640
- orcl.__sga_target=989855744
- orcl.__shared_io_pool_size=0
- orcl.__shared_pool_size=234881024
- orcl.__streams_pool_size=0
- *.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
- *.audit_trail='db'
- *.compatible='11.2.0.4.0'
- *.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/fast_recovery_area/orcl/control02.ctl'
- *.db_block_size=8192
- *.db_domain=''
- *.db_name='orcl'
- *.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
- *.db_recovery_file_dest_size=4385144832
- *.diagnostic_dest='/u01/app/oracle'
- *.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
- *.memory_target=1657798656
- *.open_cursors=300
- *.processes=150
- *.remote_login_passwordfile='EXCLUSIVE'
- *.undo_tablespace='UNDOTBS1'
- DB_UNIQUE_NAME=orcl_st
- LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl_pd,orcl_st)'
- LOG_ARCHIVE_DEST_1=
- 'LOCATION=/u01/app/oracle/oradata/orcl/archivelog
- VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
- DB_UNIQUE_NAME=orcl_st'
- LOG_ARCHIVE_DEST_2=
- 'SERVICE=orcl_pd ASYNC
- VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
- DB_UNIQUE_NAME=orcl_pd'
- LOG_ARCHIVE_DEST_STATE_1=ENABLE
- LOG_ARCHIVE_DEST_STATE_2=ENABLE
- REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
- LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
- FAL_SERVER=orcl_pd
- STANDBY_FILE_MANAGEMENT=AUTO
3.2启动备库到nomount
- [oracle@ST dbs]$ sqlplus / as sysdba
- SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 23 16:52:07 2016
- Copyright (c) 1982, 2013, Oracle. All rights reserved.
- Connected to an idle instance.
- SQL> startup nomount
- ORACLE instance started.
- Total System Global Area 1653518336 bytes
- Fixed Size 2253784 bytes
- Variable Size 1006636072 bytes
- Database Buffers 637534208 bytes
- Redo Buffers 7094272 bytes
- SQL>
3.3开始使用RMAN进行ADG
- [oracle@ST dbs]$ sqlplus / as sysdba
- SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 23 17:26:13 2016
- Copyright (c) 1982, 2013, Oracle. All rights reserved.
- Connected to an idle instance.
- SQL> startup nomount
- ORACLE instance started.
- Total System Global Area 1653518336 bytes
- Fixed Size 2253784 bytes
- Variable Size 1006636072 bytes
- Database Buffers 637534208 bytes
- Redo Buffers 7094272 bytes
- 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@ST dbs]$ rman target sys/sys@orcl_pd auxiliary sys/sys@orcl_st
- Recovery Manager: Release 11.2.0.4.0 - Production on Wed Mar 23 17:26:33 2016
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1434698509)
- connected to auxiliary database: ORCL (not mounted)
- RMAN> duplicate target database for standby from active database nofilenamecheck;
- Starting Duplicate Db at 23-MAR-16
- using target database control file instead of recovery catalog
- allocated channel: ORA_AUX_DISK_1
- channel ORA_AUX_DISK_1: SID=19 device type=DISK
- contents of Memory Script:
- {
- backup as copy reuse
- targetfile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapworcl' auxiliary format
- '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapworcl' ;
- }
- executing Memory Script
- Starting backup at 23-MAR-16
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=40 device type=DISK
- Finished backup at 23-MAR-16
- contents of Memory Script:
- {
- backup as copy current controlfile for standby auxiliary format '/u01/app/oracle/oradata/orcl/control01.ctl';
- restore clone controlfile to '/u01/app/oracle/fast_recovery_area/orcl/control02.ctl' from
- '/u01/app/oracle/oradata/orcl/control01.ctl';
- }
- executing Memory Script
- Starting backup at 23-MAR-16
- using channel ORA_DISK_1
- channel ORA_DISK_1: starting datafile copy
- copying standby control file
- output file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f tag=TAG20160323T172644 RECID=4 STAMP=907262805
- channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
- Finished backup at 23-MAR-16
- Starting restore at 23-MAR-16
- using channel ORA_AUX_DISK_1
- channel ORA_AUX_DISK_1: copied control file copy
- Finished restore at 23-MAR-16
- contents of Memory Script:
- {
- sql clone 'alter database mount standby database';
- }
- executing Memory Script
- sql statement: alter database mount standby database
- contents of Memory Script:
- {
- set newname for tempfile 1 to
- "/u01/app/oracle/oradata/orcl/temp01.dbf";
- switch clone tempfile all;
- set newname for datafile 1 to
- "/u01/app/oracle/oradata/orcl/system01.dbf";
- set newname for datafile 2 to
- "/u01/app/oracle/oradata/orcl/sysaux01.dbf";
- set newname for datafile 3 to
- "/u01/app/oracle/oradata/orcl/undotbs01.dbf";
- set newname for datafile 4 to
- "/u01/app/oracle/oradata/orcl/users01.dbf";
- set newname for datafile 5 to
- "/u01/app/oracle/oradata/orcl/example01.dbf";
- backup as copy reuse
- datafile 1 auxiliary format
- "/u01/app/oracle/oradata/orcl/system01.dbf" datafile
- 2 auxiliary format
- "/u01/app/oracle/oradata/orcl/sysaux01.dbf" datafile
- 3 auxiliary format
- "/u01/app/oracle/oradata/orcl/undotbs01.dbf" datafile
- 4 auxiliary format
- "/u01/app/oracle/oradata/orcl/users01.dbf" datafile
- 5 auxiliary format
- "/u01/app/oracle/oradata/orcl/example01.dbf" ;
- sql 'alter system archive log current';
- }
- executing Memory Script
- executing command: SET NEWNAME
- renamed tempfile 1 to /u01/app/oracle/oradata/orcl/temp01.dbf in control file
- executing command: SET NEWNAME
- executing command: SET NEWNAME
- executing command: SET NEWNAME
- executing command: SET NEWNAME
- executing command: SET NEWNAME
- Starting backup at 23-MAR-16
- using channel ORA_DISK_1
- channel ORA_DISK_1: starting datafile copy
- input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
- output file name=/u01/app/oracle/oradata/orcl/system01.dbf tag=TAG20160323T172653
- channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
- channel ORA_DISK_1: starting datafile copy
- input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
- output file name=/u01/app/oracle/oradata/orcl/sysaux01.dbf tag=TAG20160323T172653
- channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
- channel ORA_DISK_1: starting datafile copy
- input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
- output file name=/u01/app/oracle/oradata/orcl/example01.dbf tag=TAG20160323T172653
- channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
- channel ORA_DISK_1: starting datafile copy
- input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
- output file name=/u01/app/oracle/oradata/orcl/undotbs01.dbf tag=TAG20160323T172653
- channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
- channel ORA_DISK_1: starting datafile copy
- input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
- output file name=/u01/app/oracle/oradata/orcl/users01.dbf tag=TAG20160323T172653
- channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
- Finished backup at 23-MAR-16
- sql statement: alter system archive log current
- contents of Memory Script:
- {
- switch clone datafile all;
- }
- executing Memory Script
- datafile 1 switched to datafile copy
- input datafile copy RECID=4 STAMP=907262888 file name=/u01/app/oracle/oradata/orcl/system01.dbf
- datafile 2 switched to datafile copy
- input datafile copy RECID=5 STAMP=907262888 file name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
- datafile 3 switched to datafile copy
- input datafile copy RECID=6 STAMP=907262888 file name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
- datafile 4 switched to datafile copy
- input datafile copy RECID=7 STAMP=907262888 file name=/u01/app/oracle/oradata/orcl/users01.dbf
- datafile 5 switched to datafile copy
- input datafile copy RECID=8 STAMP=907262888 file name=/u01/app/oracle/oradata/orcl/example01.dbf
- Finished Duplicate Db at 23-MAR-16
- RMAN>
3.3打开备库并开启apply service
- [oracle@ST dbs]$ sqlplus / as sysdba
- SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 23 17:48:47 2016
- 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> alter database open;
- Database altered.
- SQL> select open_mode from v$database;
- OPEN_MODE
- --------------------
- READ ONLY
- SQL> alter database recover managed standby database disconnect from session;
- Database altered.
4.检验是否成功
主库
- SQL> create table Csong(id number(10),name varchar2(20));
- Table created.
- SQL> insert into Csong values(1,'Csong');
- 1 row created.
- SQL> insert into Csong values(2,'Lyuanyuan');
- 1 row created.
- SQL> commit;
- Commit complete.
- SQL> alter system switch logfile;
- System altered.
- SQL>
- SQL> desc Csong
- Name Null? Type
- ----------------------------------------- -------- ----------------------------
- ID NUMBER(10)
- NAME VARCHAR2(20)
- SQL> select * from Csong;
- ID NAME
- ---------- --------------------
- 1 Csong
- 2 Lyuanyuan