搭建Data Guard的详细实验过程

最新推荐文章于 2023-11-28 22:49:18 发布
最新推荐文章于 2023-11-28 22:49:18 发布
阅读量92 收藏 1
点赞数

 

1

主库：ENMO11G

备库：SBDB

查看两台机子的IP地址：

[root@enmo11g ~]# ifconfig

[root@sbdb ~]# ifconfig

 

[root@enmo11g ~]# vi /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.70.12    enmo11g

192.168.70.22    sbdb

~                                                                              

~

[root@sbdb ~]# vi /etc/hosts                 

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.70.12    enmo11g

192.168.70.22    sbdb

~                                                                              

~    

 

2.

创建监听：

 

[oracle@enmo11g ~]$ netca

 listener.ora

 tnsname.ora

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

备库同样的创建方法：在此就不截图了!

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

 

两台机子互相ping通，包括主机名

[oracle@sbdb ~]$ tnsping enmo11g

 

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 14-JAN-2016 16:58:43

 

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

 

Used parameter files:

 

 

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = enmo11g)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = enmo11g)))

OK (0 msec)

[oracle@sbdb ~]$ tnsping sbdb

 

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 14-JAN-2016 16:59:29

 

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

 

Used parameter files:

 

 

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sbdb)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = sbdb)))

OK (10 msec)

[oracle@enmo11g Desktop]$ tnsping enmo11g

 

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 14-JAN-2016 16:59:44

 

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

 

Used parameter files:

 

 

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = enmo11g)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = enmo11g)))

OK (0 msec)

[oracle@enmo11g Desktop]$ tnsping sbdb

 

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 14-JAN-2016 16:59:50

 

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

 

Used parameter files:

 

 

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sbdb)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = sbdb)))

OK (0 msec)

 

3

配置监听：

主库：

[oracle@enmo11g product]$ cd /u01/app/oracle/product/11.2.0/db_1/network/admin/

[oracle@enmo11g admin]$ ls

listener1601144PM3155.bak  listener.ora  samples  shrept.lst  tnsnames.ora

[oracle@enmo11g admin]$ vi listener.ora

 

[oracle@enmo11g admin]$ vi tnsnames.ora

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

备库：

[oracle@sbdb Desktop]$  cd /u01/app/oracle/product/11.2.0/db_1/network/admin/

[oracle@sbdb admin]$ ls

listener.ora  samples  shrept.lst  tnsnames.ora

[oracle@sbdb admin]$ vi listener.ora

 

[oracle@sbdb admin]$ vi tnsnames.ora

 

4.

查看监听的状态：

主库：

[oracle@enmo11g admin]$ lsnrctl start

 

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-JAN-2016 18:43:08

 

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

 

Starting /u01/app/oracle/product/11.2.0/db_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/db_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/diag/tnslsnr/enmo11g/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=enmo11g)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=enmo11g)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date                14-JAN-2016 18:43:10

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/db_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/diag/tnslsnr/enmo11g/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=enmo11g)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Services Summary...

Service "ENMO11G" has 1 instance(s).

  Instance "ENMO11G", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

[oracle@enmo11g admin]$ lsnrctl status

 

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-JAN-2016 18:43:19

 

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=enmo11g)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date                14-JAN-2016 18:43:10

Uptime                    0 days 0 hr. 0 min. 8 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/diag/tnslsnr/enmo11g/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=enmo11g)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Services Summary...

Service "ENMO11G" has 1 instance(s).

  Instance "ENMO11G", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

备库：

[oracle@sbdb admin]$ lsnrctl start

 

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-JAN-2016 18:42:09

 

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

 

Starting /u01/app/oracle/product/11.2.0/db_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/db_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/diag/tnslsnr/sbdb/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sbdb)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sbdb)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date                14-JAN-2016 18:42:11

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/db_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/diag/tnslsnr/sbdb/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sbdb)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Services Summary...

Service "SBDB" has 1 instance(s).

  Instance "SBDB", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

[oracle@sbdb admin]$ lsnrctl status

 

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-JAN-2016 18:42:20

 

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sbdb)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date                14-JAN-2016 18:42:11

Uptime                    0 days 0 hr. 0 min. 9 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/diag/tnslsnr/sbdb/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sbdb)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Services Summary...

Service "SBDB" has 1 instance(s).

  Instance "SBDB", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

 

5

添加重做日志组：

SQL> select member from v$logfile;

 

MEMBER

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/ENMO11G/redo01.log

/u01/app/oracle/oradata/ENMO11G/redo02.log

/u01/app/oracle/oradata/ENMO11G/redo03.log

 

SQL> alter database add standby logfile group 4 '/u01/app/oracle/oradata/ENMO11G/standby_redo04.log' size 50M;

 

Database altered.

 

SQL> alter database add standby logfile group 5 '/u01/app/oracle/oradata/ENMO11G/standby_redo05.log' size 50M;

 

Database altered.

 

SQL> alter database add standby logfile group 6 '/u01/app/oracle/oradata/ENMO11G/standby_redo06.log' size 50M;

 

Database altered.

 

SQL> alter database add standby logfile group 7 '/u01/app/oracle/oradata/ENMO11G/standby_redo07.log'  size 50M;

 

Database altered.

 

删除一个重做日志组：

SQL> alter database drop standby logfile group 8;

 

Database altered.

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

查看当前有多少个重做日志组：

SQL> select member from v$logfile;

 

MEMBER

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/ENMO11G/redo01.log

/u01/app/oracle/oradata/ENMO11G/redo02.log

/u01/app/oracle/oradata/ENMO11G/redo03.log

/u01/app/oracle/oradata/ENMO11G/standby_redo04.log

/u01/app/oracle/oradata/ENMO11G/standby_redo05.log

/u01/app/oracle/oradata/ENMO11G/standby_redo06.log

/u01/app/oracle/oradata/ENMO11G/standby_redo07.log

 

7 rows selected.

 

 

6

以spfile来创建pfile

SQL> create pfile from spfile;

 

File created.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

 

Total System Global Area  830930944 bytes

Fixed Size                    2257800 bytes

Variable Size                  536874104 bytes

Database Buffers          285212672 bytes

Redo Buffers                    6586368 bytes

Database mounted.

Database opened.

SQL> show parameter pfile

 

NAME                                     TYPE         VALUE

------------------------------------ ----------- ------------------------------

spfile                                     string

 

mv掉spfile，以验证pfile是否修改成功

mv spfileENMO11G.ora spfileENMO11G.ora.bak

7

修改主库参数文件

ENMO11G.__db_cache_size=348127232

ENMO11G.__java_pool_size=4194304

ENMO11G.__large_pool_size=8388608

ENMO11G.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

ENMO11G.__pga_aggregate_target=335544320

ENMO11G.__sga_target=499122176

ENMO11G.__shared_io_pool_size=0

ENMO11G.__shared_pool_size=125829120

ENMO11G.__streams_pool_size=0

*.audit_file_dest='/u01/app/oracle/admin/ENMO11G/adump'

*.audit_trail='db'

*.compble='11.2.0.4.0'

*.control_files='/u01/app/oracle/oradata/ENMO11G/control01.ctl','/u01/app/oracle/fast_recovery_area/ENMO11G/control02.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='ENMO11G'

*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'

*.db_recovery_file_dest_size=5218762752

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=ENMO11GXDB)'

*.memory_target=833617920

*.open_cursors=300

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.undo_tablespace='UNDOTBS1'

 

DB_UNIQUE_NAME=ENMO11G

LOG_ARCHIVE_CONFIG='DG_CONFIG=(ENMO11G,SBDB)'

LOG_ARCHIVE_DEST_1=

 'LOCATION=/u01/app/oracle/fast_recovery_area

  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)

  DB_UNIQUE_NAME=ENMO11G'

LOG_ARCHIVE_DEST_2=

 'SERVICE=SBDB ASYNC

  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)

  DB_UNIQUE_NAME=SBDB'

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=SBDB

DB_FILE_NAME_CONVERT='SBDB','ENMO11G'

LOG_FILE_NAME_CONVERT='SBDB','ENMO11G'

STANDBY_FILE_MANAGEMENT=AUTO

 

8

传输参数文件和口令文件(安全考虑，用oracle用户传输会需要验证密码）

[oracle@enmo11g dbs]$ scp initENMO11G.ora 192.168.70.22:/u01/app/oracle/product/11.2.0/db_1/dbs/initSBDB.ora

oracle@192.168.70.22's password:

initENMO11G.ora                               100% 1506     1.5KB/s   00:00   

[oracle@enmo11g dbs]$ scp initENMO11G.ora 192.168.70.22:/u01/app/oracle/product/11.2.0/db_1/dbs/orapwSBDB.ora

oracle@192.168.70.22's password:

initENMO11G.ora                               100% 1506     1.5KB/s   00:00   

在备库中查看从主库中传过去的参数文件与口令文件：

[oracle@sbdb dbs]$ ls

hc_SBDB.dat  init.ora  initSBDB.ora  lkSBDB

[oracle@sbdb dbs]$ ls

hc_SBDB.dat  init.ora  initSBDB.ora  lkSBDB  orapwSBDB.ora

 

9

修改备库参数文件

SBDB.__db_cache_size=348127232

SBDB.__java_pool_size=4194304

SBDB.__large_pool_size=8388608

SBDB.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

SBDB.__pga_aggregate_target=335544320

SBDB.__sga_target=499122176

SBDB.__shared_io_pool_size=0

SBDB.__shared_pool_size=125829120

SBDB.__streams_pool_size=0

*.audit_file_dest='/u01/app/oracle/admin/SBDB/adump'

*.audit_trail='db'

*.compatible='11.2.0.4.0'

*.control_files='/u01/app/oracle/oradata/SBDB/control01.ctl','/u01/app/oracle/fast_recovery_area/SBDB/control02.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='ENMO11G'

*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'

*.db_recovery_file_dest_size=5218762752

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=SBDBXDB)'

*.memory_target=833617920

*.open_cursors=300

 

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.undo_tablespace='UNDOTBS1'

 

DB_UNIQUE_NAME=SBDB

LOG_ARCHIVE_CONFIG='DG_CONFIG=(SBDB,ENMO11G)'

LOG_ARCHIVE_DEST_1=

 'LOCATION=/u01/app/oracle/fast_recovery_area

  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)

  DB_UNIQUE_NAME=SBDB'

LOG_ARCHIVE_DEST_2=

 'SERVICE=ENMO11G ASYNC

  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)

  DB_UNIQUE_NAME=ENMO11G'

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=ENMO11G

DB_FILE_NAME_CONVERT='ENMO11G','SBDB'

LOG_FILE_NAME_CONVERT='ENMO11G','SBDB'

STANDBY_FILE_MANAGEMENT=AUTO

           

 

10

 新建几个参数文件中的目录

mkdir -p /u01/app/oracle/admin/SBDB/adump

mkdir -p /u01/app/oracle/oradata/SBDB

mkdir -p /u01/app/oracle/fast_recovery_area/SBDB

 

11

备库启动数据库到nomount状态

startup nomount

12

 启动rman(主库）

使用duplicate命令生成standby备库

 

[oracle@enmoD11g admin]$ rman target / auxiliary sys/oracle@SBDB

 

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Jan 15 01:20:44 2016

 

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

 

connected to target database: ENMO11G (DBID=1575790731, not open)

connected to auxiliary database: ENMO11G (not mounted)

 

--------------------------------------------------------------------------------------------------------------------

RMAN> duplicate target database for standby from active database;

 

 

Starting Duplicate Db at 2016-01-15 01:21:07

using target database control file instead of recovery catalog

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=133 device type=DISK

 

contents of Memory Script:

{

   backup as copy reuse

   targetfile  '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwENMO11G' auxiliary format

 '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwSBDB'   ;

}

executing Memory Script

 

Starting backup at 2016-01-15 01:21:07

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=10 device type=DISK

Finished backup at 2016-01-15 01:21:08

 

contents of Memory Script:

{

   backup as copy current controlfile for standby auxiliary format  '/u01/app/oracle/oradata/SBDB/control01.ctl';

   restore clone controlfile to  '/u01/app/oracle/fast_recovery_area/SBDB/control02.ctl' from

 '/u01/app/oracle/oradata/SBDB/control01.ctl';

}

executing Memory Script

 

Starting backup at 2016-01-15 01:21:09

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/db_1/dbs/snapcf_ENMO11G.f tag=TAG20160115T012109 RECID=1 STAMP=901156870

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03

Finished backup at 2016-01-15 01:21:12

 

Starting restore at 2016-01-15 01:21:12

using channel ORA_AUX_DISK_1

 

channel ORA_AUX_DISK_1: copied control file copy

Finished restore at 2016-01-15 01:21:13

 

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/SBDB/temp01.dbf";

   switch clone tempfile all;

   set newname for datafile  1 to

 "/u01/app/oracle/oradata/SBDB/system01.dbf";

   set newname for datafile  2 to

 "/u01/app/oracle/oradata/SBDB/sysaux01.dbf";

   set newname for datafile  3 to

 "/u01/app/oracle/oradata/SBDB/undotbs01.dbf";

   set newname for datafile  4 to

 "/u01/app/oracle/oradata/SBDB/users01.dbf";

   backup as copy reuse

   datafile  1 auxiliary format

 "/u01/app/oracle/oradata/SBDB/system01.dbf"   datafile

 2 auxiliary format

 "/u01/app/oracle/oradata/SBDB/sysaux01.dbf"   datafile

 3 auxiliary format

 "/u01/app/oracle/oradata/SBDB/undotbs01.dbf"   datafile

 4 auxiliary format

 "/u01/app/oracle/oradata/SBDB/users01.dbf"   ;

}

executing Memory Script

 

executing command: SET NEWNAME

 

renamed tempfile 1 to /u01/app/oracle/oradata/SBDB/temp01.dbf in control file

 

executing command: SET NEWNAME

 

executing command: SET NEWNAME

 

executing command: SET NEWNAME

 

executing command: SET NEWNAME

 

Starting backup at 2016-01-15 01:21:20

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile copy

input datafile file number=00003 name=/u01/app/oracle/oradata/ENMO11G/undotbs01.dbf

output file name=/u01/app/oracle/oradata/SBDB/undotbs01.dbf tag=TAG20160115T012120

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:06

channel ORA_DISK_1: starting datafile copy

input datafile file number=00001 name=/u01/app/oracle/oradata/ENMO11G/system01.dbf

output file name=/u01/app/oracle/oradata/SBDB/system01.dbf tag=TAG20160115T012120

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:05

channel ORA_DISK_1: starting datafile copy

input datafile file number=00002 name=/u01/app/oracle/oradata/ENMO11G/sysaux01.dbf

output file name=/u01/app/oracle/oradata/SBDB/sysaux01.dbf tag=TAG20160115T012120

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35

channel ORA_DISK_1: starting datafile copy

input datafile file number=00004 name=/u01/app/oracle/oradata/ENMO11G/users01.dbf

output file name=/u01/app/oracle/oradata/SBDB/users01.dbf tag=TAG20160115T012120

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01

Finished backup at 2016-01-15 01:26:07

 

contents of Memory Script:

{

   switch clone datafile all;

}

executing Memory Script

 

datafile 1 switched to datafile copy

input datafile copy RECID=1 STAMP=901157168 file name=/u01/app/oracle/oradata/SBDB/system01.dbf

datafile 2 switched to datafile copy

input datafile copy RECID=2 STAMP=901157168 file name=/u01/app/oracle/oradata/SBDB/sysaux01.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=3 STAMP=901157168 file name=/u01/app/oracle/oradata/SBDB/undotbs01.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=4 STAMP=901157168 file name=/u01/app/oracle/oradata/SBDB/users01.dbf

Finished Duplicate Db at 2016-01-15 01:26:19

 

 

13

[oracle@sbdb dbs]$ sqlplus /nolog

 

SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 14 17:56:17 2016

 

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

 

SQL> conn / as sysdba

Connected to an idle instance.

SQL> startup nomount

ORACLE instance started.

 

Total System Global Area  830930944 bytes

Fixed Size                    2257800 bytes

Variable Size                  536874104 bytes

Database Buffers          285212672 bytes

Redo Buffers                    6586368 bytes
 

SQL> alter database mount;

 

Database altered.

SQL> select status from v$instance;

 

STATUS

------------

MOUNTED

14

查看此时的状态：
主库：

SQL> select database_role from v$database;

 

DATABASE_ROLE

----------------

PRIMARY

 

SQL> alter database open;

 

Database altered.

 

 

SQL> select open_mode from v$database;

 

OPEN_MODE

--------------------

READ WRITE

 

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

备库：

SQL> select database_role from v$database;

 

DATABASE_ROLE

----------------

PHYSICAL STANDBY


 

SQL> alter database open;

 

Database altered.

 

SQL> select open_mode from v$database;

 

OPEN_MODE

--------------------

READ ONLY


 

启动实时应用

首先需要做的是查看一下DG环境中的启动模式，SQL实时应用支持在最高性能和最大可用模式，不支持在最大保护模式的环境中；因为最大保护模式为确保不丢失任何数据，primary上的事务在commit前必须确认REDO已经传递到至少一个standby上。

SQL> set sqlprompt 'PRIMARY>'

PRIMARY>select name,database_role,protection_mode,protection_level from v$database;

 

NAME          DATABASE_ROLE    PROTECTION_MODE        PROTECTION_LEVEL

--------- ---------------- -------------------- --------------------

ENMO11G   PRIMARY           MAXIMUM PERFORMANCE        MAXIMUM PERFORMANCE

 

当前的为模式MAXIMUM AVAILABILITY（最大可用模式），无需修改，若发现为MAXIMIZE PROTECTION（最大保护模式），需启动数据库到mount状态修改一下数据库的模式：

 

PRIMARY > alter database set standby database to maximize availability;

Database altered.

最大性能模式对应的是maximize performance

查看日志传输方式：确保由LGWR传输日志至STANDBY

PRIMARY > select DEST_NAME,STATUS,TYPE,ARCHIVER from v$archive_dest;

SQL> select dest_name,status,type,archiver from v$archive_dest;

 

DEST_NAME

--------------------------------------------------------------------------------

STATUS          TYPE          ARCHIVER

--------- ------- ----------

LOG_ARCHIVE_DEST_1

VALID          PUBLIC  FOREGROUND

 

LOG_ARCHIVE_DEST_2

VALID          PUBLIC  LGWR

 

LOG_ARCHIVE_DEST_3

INACTIVE  PUBLIC  FOREGROUND

 

 

DEST_NAME

--------------------------------------------------------------------------------

STATUS          TYPE          ARCHIVER

--------- ------- ----------

LOG_ARCHIVE_DEST_4

INACTIVE  PUBLIC  FOREGROUND

 

LOG_ARCHIVE_DEST_5

INACTIVE  PUBLIC  FOREGROUND

 

LOG_ARCHIVE_DEST_6

INACTIVE  PUBLIC  FOREGROUND

 

 

DEST_NAME

--------------------------------------------------------------------------------

STATUS          TYPE          ARCHIVER

--------- ------- ----------

LOG_ARCHIVE_DEST_7

INACTIVE  PUBLIC  FOREGROUND

 

LOG_ARCHIVE_DEST_8

INACTIVE  PUBLIC  FOREGROUND

 

LOG_ARCHIVE_DEST_9

INACTIVE  PUBLIC  FOREGROUND

 

 

DEST_NAME

--------------------------------------------------------------------------------

STATUS          TYPE          ARCHIVER

--------- ------- ----------

LOG_ARCHIVE_DEST_10

INACTIVE  PUBLIC  FOREGROUND

 

LOG_ARCHIVE_DEST_11

INACTIVE  PUBLIC  FOREGROUND

 

LOG_ARCHIVE_DEST_12

INACTIVE  PUBLIC  FOREGROUND

 

 

DEST_NAME

--------------------------------------------------------------------------------

STATUS          TYPE          ARCHIVER

--------- ------- ----------

LOG_ARCHIVE_DEST_13

INACTIVE  PUBLIC  FOREGROUND

 

LOG_ARCHIVE_DEST_14

INACTIVE  PUBLIC  FOREGROUND

 

LOG_ARCHIVE_DEST_15

INACTIVE  PUBLIC  FOREGROUND

 

 

DEST_NAME

--------------------------------------------------------------------------------

STATUS          TYPE          ARCHIVER

--------- ------- ----------

LOG_ARCHIVE_DEST_16

INACTIVE  PUBLIC  FOREGROUND

 

LOG_ARCHIVE_DEST_17

INACTIVE  PUBLIC  FOREGROUND

 

LOG_ARCHIVE_DEST_18

INACTIVE  PUBLIC  FOREGROUND

 

 

DEST_NAME

--------------------------------------------------------------------------------

STATUS          TYPE          ARCHIVER

--------- ------- ----------

LOG_ARCHIVE_DEST_19

INACTIVE  PUBLIC  FOREGROUND

 

LOG_ARCHIVE_DEST_20

INACTIVE  PUBLIC  FOREGROUND

 

LOG_ARCHIVE_DEST_21

INACTIVE  PUBLIC  FOREGROUND

 

 

DEST_NAME

--------------------------------------------------------------------------------

STATUS          TYPE          ARCHIVER

--------- ------- ----------

LOG_ARCHIVE_DEST_22

INACTIVE  PUBLIC  FOREGROUND

 

LOG_ARCHIVE_DEST_23

INACTIVE  PUBLIC  FOREGROUND

 

LOG_ARCHIVE_DEST_24

INACTIVE  PUBLIC  FOREGROUND

 

 

DEST_NAME

--------------------------------------------------------------------------------

STATUS          TYPE          ARCHIVER

--------- ------- ----------

LOG_ARCHIVE_DEST_25

INACTIVE  PUBLIC  FOREGROUND

 

LOG_ARCHIVE_DEST_26

INACTIVE  PUBLIC  FOREGROUND

 

LOG_ARCHIVE_DEST_27

INACTIVE  PUBLIC  FOREGROUND

 

 

DEST_NAME

--------------------------------------------------------------------------------

STATUS          TYPE          ARCHIVER

--------- ------- ----------

LOG_ARCHIVE_DEST_28

INACTIVE  PUBLIC  FOREGROUND

 

LOG_ARCHIVE_DEST_29

INACTIVE  PUBLIC  FOREGROUND

 

LOG_ARCHIVE_DEST_30

INACTIVE  PUBLIC  FOREGROUND

 

 

DEST_NAME

--------------------------------------------------------------------------------

STATUS          TYPE          ARCHIVER

--------- ------- ----------

LOG_ARCHIVE_DEST_31

INACTIVE  PUBLIC  FOREGROUND

 

 

31 rows selected.

如发现不是LGWR，而是ARCH传输，需修改一下日志传输方式：

 

SQL> alter system set log_archive_dest_2='service=orcl_s_tns lgwr valid_for=(online_logfiles,primary_role) db_unique_name=enmo11g';

 

System altered.

 

 

启动实时应用：（备库）----alter database mount;

SQL> alter database recover managed standby database using current logfile disconnect from session;（从redo log发送的）

Database altered.

 

SQL> SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG;

 

 SEQUENCE# APPLIED

---------- ---------

76 YES

77 YES

78 IN-MEMORY

----------------------------------------------------------------------------------------------------------------------------

Open physical standby 数据库时，不能看到primay数据库上的修改！

如果想看到primary数据库上的修改，必须得启动redo应用.

启动redo应用：

SQL>alter database recover managed standby database disconnect from session；

 

暂停redo应用：

 

此时只是暂时redo应用，并不是停止物理standby数据库，standby仍会保持收，只不过不会再应用接收到的归档，知道你再次启动redo应用为止。

SQL>alter database recover managed standby database cancel;

例子：我在主库中创建了一个表t3:

SQL> create table t3 as select * from dba_objects;

 

Table created.

而此时在备库中查看t3的信息会跟主库完全一样！

SQL> select  * from t3;

15

启用Switchover角色互换  

 

主库：

SQL> select switchover_status from v$database;     

 

SWITCHOVER_STATUS

--------------------

TO STANDBY

 

SQL> alter database commit to switchover to PHYSICAL STANDBY;

 

Database altered.

[oracle@enmo11g Desktop]$ sqlplus / as sysdba

 

SQL*Plus: Release 11.2.0.4.0 Production on Fri Jan 15 12:20:26 2016

 

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

 

Connected to an idle instance.

 

SQL> startup mount

ORACLE instance started.

 

Total System Global Area  830930944 bytes

Fixed Size                    2257800 bytes

Variable Size                  536874104 bytes

Database Buffers          285212672 bytes

Redo Buffers                    6586368 bytes

Database mounted.

SQL> select database_role from v$database;

 

DATABASE_ROLE

----------------

PHYSICAL STANDBY

 

 

备库：

SQL> select switchover_status from v$database;

 

SWITCHOVER_STATUS

--------------------

NOT ALLOWED

 

SQL> alter database recover managed standby database disconnect from session;

 

Database altered.

 

SQL> select switchover_status from v$database;

 

SWITCHOVER_STATUS

--------------------

TO PRIMARY

 

SQL> alter database commit to switchover to PRIMARY;

 

Database altered.

 

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> statup mount

SP2-0734: unknown command beginning "statup mou..." - rest of line ignored.

SQL> startup mount

ORACLE instance started.

 

Total System Global Area  830930944 bytes

Fixed Size                    2257800 bytes

Variable Size                  536874104 bytes

Database Buffers          285212672 bytes

Redo Buffers                    6586368 bytes

Database mounted.

SQL> select database_role from v$database;

 

DATABASE_ROLE

----------------

PRIMARY


来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30606702/viewspace-1980182/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30606702/viewspace-1980182/

congwei2855
关注
DataGuard最详细的实验过程，欢迎讨论
u010565072的博客
01-05 8029
Data Guard实验 实验环境 主库端 基于linux系统安装11.2.0.4版本Oracle数据库 有一个单实例数据库db_name=db_unique_name=wqdb 备库端 基于linux系统安装11.2.0.4版本Oracle数据库 未起数据库实例 注意事项 大小写不敏感，除密码外 路径结尾处是否有/是敏感的，同时末尾不要留有空格 注意每个参数路径存在且权限为oracle...
Oracle 高可用与容灾工具 Data Guard 搭建与运维
06-15
本课程介绍了Data Guard的原理、架构、搭建方法、主备库切换方式等Oracle Data Guard的完整知识体系，并通过现场实验演示的方式讲解课程，是Oracle DBA、数据库架构师、数据库运维工程师完整地学习掌握Data Guard的...
如何搭建一个 Data Guard 环境
ijavagos
02-20 100
在Blog里零零散散的讲了一些DB 维护的东西，比较杂，也比较散。 这里就Oracle Data Guard 这块做一个小结。 主要是流程上的东西。 做个参考，以后装DG，照这个流程走就ok了。 一. 服务器设置 1.1 硬盘的规划 根据自己的业务量来规划硬盘。 我上周搭建的DG,用了4块SAS 硬盘。 单盘300G，1.5w转/s。 这个IOPS 大概在150M/s。 是...
dataguard搭建实验
希望走上人生巅峰早日脱光的菜鸟
12-25 457
一开始只有主库安装了数据库，sid dgtest 数据库名 dgtest dg1 180.200.2.55  dgtest1 dg2 180.200.2.56  dgtest2 dg1 alter database force logging; cd $ORACLE_HOME/dbs/  orapwdfile=orapwdb1 password=1234
手工搭建Data Guard
bisal的专栏
02-23 4617
DATA Guard的搭建可以使用GC图形化安装，优缺点很明显，优点就是图形化操作，符合国人的习惯(据secooler介绍外国程序员能用图形化做的事就一定用图形做，因为boss看得懂，和国人正相反。。。)，缺点就是如同Windows一样，宛如黑盒，换句话说，要时刻祈祷不要出问题，否则有时很难知道他为什么挂了。。。
oracle data guard
有些事经历了才会懂
11-28 1437
最大保护模式为主数据库提供了最高水平的数据保护，从而确保一个全面的零数据丢失的灾难恢复解决方案。数据库是处于正常打开状态，当它接收到新的日志信息后，利用日志挖掘器的功能，把日志中记录的变更信息转换成具体的 SQL 语句，并在逻辑备用数据库上执行这些 SQL 语句，从而实现与生产数据库的数据同步。备份数据库处于 mount 状态下，直接利用数据恢复技术，把日志文件中记录的数据变更应用在备份数据库中，从而实现与生产数据库的数据同步，在进行数据同步的时候，物理备份数据库是不能打开的、也无法提供数据查询等服务；
oracle11gr2 active data guard,oracle 11gR2 搭建dataguard
weixin_33851180的博客
04-13 106
1、搭建环境主库 oracle11gR2 备库 oracle11gR2db_name orcl orcldb_unique_name orcl standby239配置host文件主库：primaryHost 备库：standbyHost准备库都置于归档模式。2、配置静态监听主备库都配置listener.oraSID_LIST_LISTENER...
主备库内存不一致的Data Guard环境搭建
weixin_43085475的博客
11-11 369
前言 前几天朋友问了我一个问题，一个单节点RAC，要做一套Data Guard，但是备库能给数据库的内存只有主库的一半左右，能不能成功。不知道，没做过，试试呗。 一．概况 1. 涉及的技术点 1）RAC作为primary database，nonRAC作为standby database 2）使用RMAN作为数据库的备份方式 3）使用duplicate database for standby创建...
搭建Active Data Guard环境
coolmsn8786的博客
11-10 70
Oracle 11G之前的Data Guard恢复模式不能查询,只读模式不能恢复. 在11G之后,增加了Active Data Guard的新特性.它可以兼顾查询和恢复. 实验将一个最大性能模式的物理StandBy转换成...
一点一滴讲解Data Guard前世今生
09-09
在Data Guard的学习和测试中，使用Virtualbox虚拟化软件来模拟不同环境下的Oracle数据库实例，可以方便地进行实验环境的搭建和测试。 在搭建物理备库的过程中，除了安装操作系统和数据库，还需要进行操作系统和网络...
Oracle 12c 部署Data Guard,Switchover和Failover
11-28
部署Data Guard涉及的步骤较为复杂，包括准备实验环境、搭建Active Data Guard、配置Broker等关键步骤。实验环境的准备需要确保主备数据库的OS和数据库版本信息相匹配，还需要在主备数据库的hosts文件中添加相关信息...
经济补偿金、赔偿金的核定及劳动合同解除后双方的义务.ppt
09-14
经济补偿金、赔偿金的核定及劳动合同解除后双方的义务.ppt
配电网分布式电源和储能选址定容 以配电网总成本最低为目标函数，其中包括年运行成本，设备维护折损成本、环境成本；以系统潮流运行为约
09-14
配电网分布式电源和储能选址定容 以配电网总成本最低为目标函数，其中包括年运行成本，设备维护折损成本、环境成本；以系统潮流运行为约束条件，采用粒子群算法求解，实现光伏、风电、储能设备的规划。 这是一个使用粒子群算法进行优化的程序。下面我将对程序进行详细的分析和解释。 首先，程序开始时加载了一些数据文件，包括光伏、风电和负荷的数据。然后，定义了一些参数，如蓄电池参数、迭代次数、种群大小、速度更新参数等。 接下来，程序进行了种群的初始化。使用随机数生成种群的初始位置，并初始化速度。然后，对种群中的每个个体进行潮流计算，并计算适应度。适应度的计算包括对电压、网损等进行评估，并考虑了一些约束条件，如储能容量、光伏容量等的限制。 接下来，程序进行了迭代优化过程。在每次迭代中，根据当前的速度和位置，更新粒子的速度和位置。然后，对更新后的粒子进行潮流计算，并计算适应度。如果个体的适应度优于个体历史最佳适应度，则更新个体历史最佳适应度和位置。如果个体的适应度优于全局最佳适应度，则更新全局最佳适应度和位置。 程序通过迭代优化过程不断更新粒子的速度和位置，直到达到指定的迭代次数。最后，程序输出优化结
Cpp-halcono-pencv互相转换
最新发布
09-14
Cpp_halcon_opencv互相转换 python halcon_opencv图像变量互相转换 C++ halcon 和opencv 图像变量互相转换 VS2022工程 无需配置环境即可 使用绝对路径 无需配置 无需配置 无需配置 下载即可编译生成 仅限交流学习使用;仅限交流学习使用;仅限交流学习使用;
××部20xx年人员裁员分流方案表.xlsx
09-14
××部20xx年人员裁员分流方案表.xlsx
『人事流程图新』会前准备工作管理流程图.docx
09-14
『人事流程图新』会前准备工作管理流程图.docx
遗传算法优化频率抽样法非零点插入_GeneA.zip
09-14
遗传算法优化频率抽样法非零点插入_GeneA
Oracle Data Guard详解：从零到精通
在Data Guard的实验环境中，作者讲解了如何搭建Physical Standby（物理备用库），这是Data Guard的一种常见模式，可以实现实时的数据同步和故障切换。Physical Standby通过redo应用来保持与Primary数据库的一致性，...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值