OCM_Session8_2_Step-by-Step Instructions for Creating a Physical Standby Database

最新推荐文章于 2021-10-14 17:21:46 发布
最新推荐文章于 2021-10-14 17:21:46 发布
阅读量2.4k 收藏 1
点赞数
分类专栏： OCM experiment
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/rlhua/article/details/22049531
版权

 

  • 2.Step-by-Step Instructions for Creating a Physical Standby Database

准备工作：
创建转储目录

[oracle@ocm2 dbs]$ mkdir -p /u01/app/oracle/admin/PRODSTD/adump
[oracle@ocm2 dbs]$ mkdir -p /u01/app/oracle/admin/PRODSTD/bdump
[oracle@ocm2 dbs]$ mkdir -p /u01/app/oracle/admin/PRODSTD/cdump
[oracle@ocm2 dbs]$ mkdir -p /u01/app/oracle/admin/PRODSTD/udump   


  • 2.1.Create a Backup Copy of the Primary Database Datafiles
冷备份主库

SYS@PROD>!
[oracle@ocm1 ~]$ cd /u01/app/oracle/oradata/
[oracle@ocm1 oradata]$ ll
total 4
drwxr-xr-x 7 oracle oinstall 4096 Mar 19 13:16 PROD
[oracle@ocm1 oradata]$   tar -czvf PROD.tar.gz PROD
PROD/
PROD/Disk1/
PROD/Disk1/temp01.dbf
PROD/Disk1/standby07.log
PROD/Disk1/standby11.log
PROD/Disk1/redo03.log
PROD/Disk1/standby10.log
PROD/Disk1/standby09.log
PROD/Disk1/system01.dbf
PROD/Disk1/redo01.log
PROD/Disk1/standby08.log
PROD/Disk1/standby06.log
PROD/Disk1/control01.ctl
PROD/Disk1/users01.dbf
PROD/Disk1/sysaux01.dbf
PROD/Disk1/example01.dbf
PROD/Disk1/redo02.log
PROD/Disk1/redo05.log
PROD/Disk1/redo04.log
PROD/Disk1/undotbs01.dbf
PROD/Disk2/
PROD/Disk2/standby07_1.log
PROD/Disk2/standby06_1.log
PROD/Disk2/redo03_1.log
PROD/Disk2/standby09_1.log
PROD/Disk2/standby08_1.log
PROD/Disk2/control02.ctl
PROD/Disk2/redo05_1.log
PROD/Disk2/redo02_1.log
PROD/Disk2/redo01_1.log
PROD/Disk2/redo04_1.log
PROD/Disk2/standby10_1.log
PROD/Disk2/standby11_1.log
PROD/Disk2/arch/
PROD/Disk2/arch/arc_05p3jeqe_1_1.bak
PROD/Disk3/
PROD/Disk3/control03.ctl
PROD/Disk4/
PROD/Disk5/
PROD/Disk5/bak/
PROD/Disk5/bak/PROD_04p3jeq8_1_1.bak
PROD/Disk5/bak/PROD_03p3jemu_1_1.bak
[oracle@ocm1 oradata]$ exit
exit

  • 2.2.Create a Control File for the Standby Database
成备库的控制文件

SYS@PROD>startup mount
ORACLE instance started.

Total System Global Area  524288000 bytes
Fixed Size                  1220360 bytes
Variable Size             171966712 bytes
Database Buffers          348127232 bytes
Redo Buffers                2973696 bytes
Database mounted.
SYS@PROD>
SYS@PROD> ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/home/oracle/control01.ctl'; 

Database altered.

SYS@PROD> ALTER DATABASE OPEN;

Database altered.

  • 2.3.Prepare an Initialization Parameter File for the Standby Database

准备备库的参数文件 initPRODSTD.ora

①在主库中将主库的pfile文件传输到备库中
[oracle@ocm1 ~]$ cd /u01/app/oracle/product/10.2.0/db_1/dbs
[oracle@ocm1 dbs]$ ll
total 6744
-rw-rw---- 1 oracle oinstall    1544 Mar 25 09:59 hc_PROD.dat
-rw-r----- 1 oracle oinstall   12920 May  3  2001 initdw.ora
-rw-r----- 1 oracle oinstall    8385 Sep 11  1998 init.ora
-rw-r--r-- 1 oracle oinstall    1827 Mar 25 09:39 initPROD.ora
-rw-rw---- 1 oracle oinstall      24 Mar 18 10:18 lkPROD
-rw-r----- 1 oracle oinstall    5120 Mar 18 09:54 orapwPROD
-rw-r--r-- 1 oracle oinstall     318 Mar 17 20:37 pfile.ora
-rw-r----- 1 oracle oinstall 6832128 Mar 19 19:51 snapcf_PROD.f
-rw-r----- 1 oracle oinstall    4608 Mar 25 09:57 spfilePROD.ora
[oracle@ocm1 dbs]$ scp initPROD.ora ocm2.localdomain:/u01/app/oracle/product/10.2.0/db_1/dbs
The authenticity of host 'ocm2.localdomain (192.168.1.156)' can't be established.
RSA key fingerprint is de:2a:4c:d0:b2:20:88:4c:a2:72:24:11:50:4b:d6:74.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'ocm2.localdomain,192.168.1.156' (RSA) to the list of known hosts.
oracle@ocm2.localdomain's password: 
initPROD.ora                                                                                                                         100% 1827     1.8KB/s   00:00    
[oracle@ocm1 dbs]$ 

②，在备库中修改pfile

[oracle@ocm2 ~]$ cd /u01/app/oracle/product/10.2.0/db_1/dbs
[oracle@ocm2 dbs]$ ll
total 48
-rw-rw---- 1 oracle oinstall  1544 Mar 24 14:10 hc_EMREP.dat
-rw-r----- 1 oracle oinstall 12920 May  3  2001 initdw.ora
-rw-r----- 1 oracle oinstall  8385 Sep 11  1998 init.ora
-rw-r--r-- 1 oracle oinstall  1827 Mar 25 10:08 initPROD.ora
-rw-rw---- 1 oracle oinstall    24 Mar 20 15:14 lkEMREP
-rw-r----- 1 oracle oinstall  1536 Mar 20 16:16 orapwEMREP
-rw-r----- 1 oracle oinstall  2560 Mar 24 14:10 spfileEMREP.ora
[oracle@ocm2 dbs]$ mv initPROD.ora initPRODSTD.ora
[oracle@ocm2 dbs]$ vi initPRODSTD.ora

修改内容如下：

PRODSTD.__db_cache_size=331350016
PRODSTD.__java_pool_size=4194304
PRODSTD.__large_pool_size=4194304
PRODSTD.__shared_pool_size=180355072
PRODSTD.__streams_pool_size=0
*.BACKGROUND_DUMP_DEST='/u01/app/oracle/admin/ PRODSTD/bdump'
*.control_files='/u01/app/oracle/oradata/ PRODSTD/Disk1/control01.ctl','/u01/app/oracle/oradata/ PRODSTD/Disk2/control02.ctl','/u01/app/oracle/oradata/ PRODSTD/Disk3/control03.ctl'
*.CORE_DUMP_DEST='/u01/app/oracle/admin/ PRODSTD/cdump'
*.DB_BLOCK_SIZE=8192
*.DB_CREATE_FILE_DEST='/u01/app/oracle/oradata/ PRODSTD/Disk1'
*.DB_CREATE_ONLINE_LOG_DEST_1='/u01/app/oracle/oradata/ PRODSTD/Disk1'
*.DB_NAME=' PROD'
*.db_recovery_file_dest_size=4294967296
*.db_recovery_file_dest='/home/oracle/flash'
*.job_queue_processes=15
*.max_dispatchers=10
*.max_shared_servers=30
*.processes=135
*.sessions=300
*.SGA_TARGET=500M
*.shared_server_sessions=200
*.shared_servers=10
*.UNDO_MANAGEMENT='auto'
*.undo_retention=5400
*.UNDO_TABLESPACE='undotbs1'
*.USER_DUMP_DEST='/u01/app/oracle/admin/ PRODSTD/udump'
*.utl_file_dir='/home/oracle','/home/oracle/temp','/home/oracle/scripts'

##parameter for Primary Database
DB_NAME= PROD 
DB_UNIQUE_NAME= PRODSTD
LOG_ARCHIVE_CONFIG='DG_CONFIG=(PROD,PRODSTD)'
CONTROL_FILES='/u01/app/oracle/oradata/ PRODSTD/Disk1/control01.ctl','/u01/app/oracle/oradata/ PRODSTD/Disk2/control02.ctl','/u01/app/oracle/oradata/ PRODSTD/Disk3/control03.ctl' 
LOG_ARCHIVE_DEST_1='location=/u01/app/oracle/oradata/ PRODSTD/Disk2/arch  VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME= PRODSTD'
LOG_ARCHIVE_DEST_2='SERVICE= PROD LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME= PROD'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30
##parameter for Standby Database    
FAL_SERVER= PROD
FAL_CLIENT= PRODSTD
DB_FILE_NAME_CONVERT=' PROD',' PRODSTD'
LOG_FILE_NAME_CONVERT=' PROD',' PRODSTD'
STANDBY_FILE_MANAGEMENT=AUTO


Note：
此处需注意参数文件里的路径必须存在

[oracle@ocm2 dbs]$  mkdir /home/oracle/flash
[oracle@ocm2 dbs]$  mkdir /home/oracle/temp
[oracle@ocm2 dbs]$ mkdir /home/oracle/scripts

  • 2.4.Copy Files from the Primary System to the Standby System
从主库拷贝文件到备库

①password parameter file created in 1.2

[oracle@ocm2 ~]$ cd /u01/app/oracle/product/10.2.0/db_1/dbs
[oracle@ocm1 dbs]$ scp orapwPROD ocm2.localdomain:/u01/app/oracle/product/10.2.0/db_1/dbs
oracle@ocm2.localdomain's password: 
orapwPROD                                                                                                                            100% 5120     5.0KB/s   00:01    
[oracle@ocm1 dbs]$ 

在备库中修改密码文件名称
[oracle@ocm2 ~]$ cd /u01/app/oracle/product/10.2.0/db_1/dbs
[oracle@ocm2 dbs]$ ll
total 56
-rw-rw---- 1 oracle oinstall  1544 Mar 24 14:10 hc_EMREP.dat
-rw-r----- 1 oracle oinstall 12920 May  3  2001 initdw.ora
-rw-r----- 1 oracle oinstall  8385 Sep 11  1998 init.ora
-rw-r--r-- 1 oracle oinstall  1960 Mar 25 10:13 initPRODSTD.ora
-rw-rw---- 1 oracle oinstall    24 Mar 20 15:14 lkEMREP
-rw-r----- 1 oracle oinstall  1536 Mar 20 16:16 orapwEMREP
-rw-r----- 1 oracle oinstall  5120 Mar 25 10:17 orapwPROD
-rw-r----- 1 oracle oinstall  2560 Mar 24 14:10 spfileEMREP.ora
[oracle@ocm2 dbs]$   mv orapwPROD orapwPRODSTD



②Backup datafiles created in Section 2.1 

[oracle@ocm1 dbs]$  scp /u01/app/oracle/oradata/PROD.tar.gz ocm2.localdomain:/u01/app/oracle/oradata/
oracle@ocm2.localdomain's password: 
PROD.tar.gz                                                                                                                          100%  225MB   2.8MB/s   01:20    
[oracle@ocm1 dbs]$ 

在备库中恢复

[oracle@ocm2 ~]$ cd /u01/app/oracle/oradata/
[oracle@ocm2 oradata]$ ll
total 230872
drwxr-x--- 2 oracle oinstall      4096 Mar 20 15:16 EMREP
-rw-r--r-- 1 oracle oinstall 236170241 Mar 25 10:21 PROD.tar.gz
[oracle@ocm2 oradata]$ tar -xzvf  PROD.tar.gz
PROD/
PROD/Disk1/
PROD/Disk1/temp01.dbf
PROD/Disk1/standby07.log
PROD/Disk1/standby11.log
PROD/Disk1/redo03.log
PROD/Disk1/standby10.log
PROD/Disk1/standby09.log
PROD/Disk1/system01.dbf
PROD/Disk1/redo01.log
PROD/Disk1/standby08.log
PROD/Disk1/standby06.log
PROD/Disk1/control01.ctl
PROD/Disk1/users01.dbf
PROD/Disk1/sysaux01.dbf
PROD/Disk1/example01.dbf
PROD/Disk1/redo02.log
PROD/Disk1/redo05.log
PROD/Disk1/redo04.log
PROD/Disk1/undotbs01.dbf
PROD/Disk2/
PROD/Disk2/standby07_1.log
PROD/Disk2/standby06_1.log
PROD/Disk2/redo03_1.log
PROD/Disk2/standby09_1.log
PROD/Disk2/standby08_1.log
PROD/Disk2/control02.ctl
PROD/Disk2/redo05_1.log
PROD/Disk2/redo02_1.log
PROD/Disk2/redo01_1.log
PROD/Disk2/redo04_1.log
PROD/Disk2/standby10_1.log
PROD/Disk2/standby11_1.log
PROD/Disk2/arch/
PROD/Disk2/arch/arc_05p3jeqe_1_1.bak
PROD/Disk3/
PROD/Disk3/control03.ctl
PROD/Disk4/
PROD/Disk5/
PROD/Disk5/bak/
PROD/Disk5/bak/PROD_04p3jeq8_1_1.bak
PROD/Disk5/bak/PROD_03p3jemu_1_1.bak
[oracle@ocm2 oradata]$ 
[oracle@ocm2 oradata]$ ll
total 230876
drwxr-x--- 2 oracle oinstall      4096 Mar 20 15:16 EMREP
drwxr-xr-x 7 oracle oinstall      4096 Mar 19 13:16 PROD
-rw-r--r-- 1 oracle oinstall 236170241 Mar 25 10:21 PROD.tar.gz
[oracle@ocm2 oradata]$ mv PROD PRODSTD
[oracle@ocm2 oradata]$ ll
total 230876
drwxr-x--- 2 oracle oinstall      4096 Mar 20 15:16 EMREP
drwxr-xr-x 7 oracle oinstall      4096 Mar 19 13:16 PRODSTD
-rw-r--r-- 1 oracle oinstall 236170241 Mar 25 10:21 PROD.tar.gz
[oracle@ocm2 oradata]$ rm -rf PROD.tar.gz 
[oracle@ocm2 oradata]$ ll
total 8
drwxr-x--- 2 oracle oinstall 4096 Mar 20 15:16 EMREP
drwxr-xr-x 7 oracle oinstall 4096 Mar 19 13:16   PRODSTD-路径和PROD的路径一致

删除PRODSTD中原主库控制文件
[oracle@ocm2 oradata]$ pwd
/u01/app/oracle/oradata
[oracle@ocm2 oradata]$ rm -rf PRODSTD/Disk1/control01.ctl 
[oracle@ocm2 oradata]$ rm -rf PRODSTD/Disk2/control02.ctl 
[oracle@ocm2 oradata]$ rm -rf PRODSTD/Disk3/control03.ctl 

③Standby control file created in Section2.2 

[oracle@ocm1 dbs]$  scp /home/oracle/control01.ctl ocm2.localdomain:/u01/app/oracle/oradata/PRODSTD/Disk1
oracle@ocm2.localdomain's password: 
control01.ctl                                                                                                                        100% 6672KB   3.3MB/s   00:02    
[oracle@ocm1 dbs]$ 


④Initialization parameter file created in Section2.3，已经拷贝

  • 2.5 Set Up the Environment to Support the Standby Database

Step 1   Create a Windows-based service.-linux操作下面不用操作这一步
Step 2   Create a password file. 2.4.1已经创建
Step 3   Configure listeners for the primary and standby databases.
Step 4   Create Oracle Net service names.


ocm1
[oracle@ocm1 dbs]$ cd /u01/app/oracle/product/10.2.0/db_1/network/admin/
[oracle@ocm1 admin]$ ll
total 20
-rw-r--r-- 1 oracle oinstall  712 Mar 18 12:30 listener.ora
drwxr-x--- 2 oracle oinstall 4096 Mar 16 19:17 samples
-rw-r----- 1 oracle oinstall  172 Dec 26  2003 shrept.lst
-rw-r--r-- 1 oracle oinstall   41 Mar 18 13:38 sqlnet.ora
-rw-r--r-- 1 oracle oinstall  589 Mar 18 18:47 tnsnames.ora

[oracle@ocm1 admin]$ cat listener.ora 
LISTENER=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1521))
      (ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))
SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=
      (GLOBAL_DBNAME=PROD)
      (ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1)
      (SID_NAME=PROD))
    (SID_DESC=
      (GLOBAL_DBNAME=PRODSTD)
      (ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1)----添加
      (SID_NAME=PRODSTD))
      (SID_DESC=
      (SID_NAME=plsextproc)
      (ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1)
      (PROGRAM=extproc)))

LSNR2=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1526))
      (ADDRESS=(PROTOCOL=ipc)(KEY=extproc1))))
[oracle@ocm1 admin]$ cat tnsnames.ora 
prod=
(DESCRIPTION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1521))
  (CONNECT_DATA=
   (SERVICE_NAME=PROD)
   (SERVER=dedicated)))

PRODSTD=
(DESCRIPTION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=ocm2.localdomain)(PORT=1521))-添加
  (CONNECT_DATA=
   (SERVICE_NAME=PRODSTD)
   (SERVER=dedicated)))
[oracle@ocm1 admin]$                                                                                                               

[oracle@ocm1 admin]$  lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 25-MAR-2014 10:48:36

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

Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                25-MAR-2014 10:48:38
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/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Services Summary...
Service "EMREP" has 1 instance(s).
  Instance "EMREP", status UNKNOWN, has 1 handler(s) for this service...
Service "PROD" has 1 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
Service "PRODSTD" has 1 instance(s).
  Instance "PRODSTD", status UNKNOWN, has 1 handler(s) for this service...
Service "plsextproc" has 1 instance(s).
  Instance "plsextproc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@ocm1 admin]$ 



ocm2：

[oracle@ocm2 admin]$ cat listener.ora 
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
  (SID_DESC=
      (GLOBAL_DBNAME=PROD)
      (ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1)
      (SID_NAME=PROD))  
  (SID_DESC=
      (GLOBAL_DBNAME=PRODSTD)
      (ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1) ----------添加
      (SID_NAME=PRODSTD))
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ocm2.localdomain)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )

[oracle@ocm2 admin]$ cat tnsnames.ora 
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
PROD =
  (description =
    (address=(protocol=tcp)(host=ocm1.localdomain)(port=1521))
    (connect_data=
        (server = dedicated)
        (service_name = PROD)
    )
  )

PRODSTD =
  (description =
    (address=(protocol=tcp)(host=ocm2.localdomain)(port=1521)) --添加
    (connect_data=
        (server = dedicated)
        (service_name = PRODSTD)
    )
  )

[oracle@ocm2 admin]$ 

[oracle@ocm2 admin]$   lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 25-MAR-2014 11:03:00

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

Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm2.localdomain)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ocm2.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                25-MAR-2014 11:03:02
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/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm2.localdomain)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PROD" has 1 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
Service "PRODSTD" has 1 instance(s).
  Instance "PRODSTD", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@ocm2 admin]$ 

Step 5   Create a server parameter file for the standby database.

[oracle@ocm2 ~]$ export ORACLE_SID=PRODSTD
[oracle@ocm2 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Mar 25 11:06:14 2014

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

Connected to an idle instance.

SYS@PRODSTD> create spfile from pfile;

File created.


  • 2.6.Start the Physical Standby Database
启动备库

Step 1   Start the physical standby database.

SYS@PRODSTD>startup mount
ORACLE instance started.

Total System Global Area  524288000 bytes
Fixed Size                  1220360 bytes
Variable Size             188743928 bytes
Database Buffers          331350016 bytes
Redo Buffers                2973696 bytes
Database mounted.
SYS@PRODSTD>
备库
SYS@PRODSTD>select database_role,switchover_status from v$database;

DATABASE_ROLE    SWITCHOVER_STATUS
---------------- --------------------
PHYSICAL STANDBY RECOVERY NEEDED
主库
SYS@PROD>select database_role,switchover_status from v$database;

DATABASE_ROLE    SWITCHOVER_STATUS
---------------- --------------------
PRIMARY          SESSIONS ACTIVE

Step 2   Start Redo Apply.

备库只有在mount状态的时候可以应用日志，read only状态不能应用日志
应用日志调用2个MRP进程启动LEO3库日志应用并后台运行
alter database recover managed standby database disconnect from session parallel 2;

备库
SYS@PRODSTD>alter database recover managed standby database disconnect from session parallel 2;

Database altered.

SYS@PRODSTD>select database_role,switchover_status from v$database;

DATABASE_ROLE    SWITCHOVER_STATUS
---------------- --------------------
PHYSICAL STANDBY SESSIONS ACTIVE

主库
SYS@PROD>select database_role,switchover_status from v$database;

DATABASE_ROLE    SWITCHOVER_STATUS
---------------- --------------------
PRIMARY          SESSIONS ACTIVE

Step 3   Test archival operations to the physical standby database.

SYS@PROD>alter system switch logfile;

System altered.


tail -f alert_PROD.log

LNS1 started with pid=59, OS id=9381
Tue Mar 25 11:23:53 2014
Thread 1 advanced to log sequence 13
  Current log# 5 seq# 13 mem# 0: /u01/app/oracle/oradata/PROD/Disk1/redo05.log
  Current log# 5 seq# 13 mem# 1: /u01/app/oracle/oradata/PROD/Disk2/redo05_1.log
Tue Mar 25 11:23:54 2014
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
LNS: Standby redo logfile selected for thread 1 sequence 13 for destination LOG_ARCHIVE_DEST_2
Tue Mar 25 11:23:55 2014
ARC4: Standby redo logfile selected for thread 1 sequence 12 for destination LOG_ARCHIVE_DEST_2

tail -f alert_PRODSTD.log

Tue Mar 25 11:23:54 2014
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[2]: Assigned to RFS process 4259
RFS[2]: Identified database type as 'physical standby'
Tue Mar 25 11:23:54 2014
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[3]: Assigned to RFS process 4257
RFS[3]: Identified database type as 'physical standby'
Primary database is in MAXIMUM PERFORMANCE mode
Primary database is in MAXIMUM PERFORMANCE mode
RFS[3]: Successfully opened standby log 6: '/u01/app/oracle/oradata/PRODSTD/Disk1/standby06.log'
Tue Mar 25 11:23:55 2014
RFS[2]: Successfully opened standby log 7: '/u01/app/oracle/oradata/PRODSTD/Disk1/standby07.log'
Tue Mar 25 11:23:58 2014
Media Recovery Log /u01/app/oracle/oradata/PRODSTD/Disk2/arch/1_12_842523531.arc
Media Recovery Waiting for thread 1 sequence 13 (in transit)
Tue Mar 25 11:24:30 2014
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[4]: Assigned to RFS process 4262
RFS[4]: Identified database type as 'physical standby'

  • 2.7 Verify the Physical Standby Database Is Performing Properly

Step 1   Identify the existing archived redo log files.

SYS@PRODSTD>SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME,applied from v$archived_log;

 SEQUENCE# FIRST_TIM NEXT_TIME APP
---------- --------- --------- ---
        11 25-MAR-14 25-MAR-14 YES
        12 25-MAR-14 25-MAR-14 YES


Step 2   Force a log switch to archive the current online redo log file.

SYS@PROD>ALTER SYSTEM SWITCH LOGFILE;

System altered.

tail -f alert_PROD.log
Tue Mar 25 11:32:49 2014
Thread 1 advanced to log sequence 14
  Current log# 1 seq# 14 mem# 0: /u01/app/oracle/oradata/PROD/Disk1/redo01.log
  Current log# 1 seq# 14 mem# 1: /u01/app/oracle/oradata/PROD/Disk2/redo01_1.log
Tue Mar 25 11:32:50 2014
LNS: Standby redo logfile selected for thread 1 sequence 14 for destination LOG_ARCHIVE_DEST_2

tail -f alert_PRODSTD.log
Tue Mar 25 11:32:50 2014
Primary database is in MAXIMUM PERFORMANCE mode
RFS[3]: Successfully opened standby log 7: '/u01/app/oracle/oradata/PRODSTD/Disk1/standby07.log'
Tue Mar 25 11:32:51 2014
Media Recovery Log /u01/app/oracle/oradata/PRODSTD/Disk2/arch/1_13_842523531.arc
Media Recovery Waiting for thread 1 sequence 14 (in transit)


Step 3   Verify the new redo data was archived on the standby database.
Step 4   Verify new archived redo log files were applied.

SYS@PRODSTD>SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME,applied from v$archived_log;

 SEQUENCE# FIRST_TIM NEXT_TIME APP
---------- --------- --------- ---
        11 25-MAR-14 25-MAR-14 YES
        12 25-MAR-14 25-MAR-14 YES
        13 25-MAR-14 25-MAR-14 YES

 

Riveore
关注
专栏目录
LCD.rar_OCM12864-9_ocm12864_visual c
09-23
标题中的“LCD.rar_OCM12864-9_ocm12864_visual c”揭示了这个压缩包文件的主要内容，它包含了与OCM12864 LCD显示模块相关的驱动程序，并且是使用Visual C++编写的。OCM12864是一种常见的128x64像素分辨率的液晶显示...
DataGuard - 一个关于Physical Standby中recover问题的解决方法
Kamus' Oracle World
08-15 4202
在Recover的过程中出现如下提示：Media Recovery Log /global/oradata/ctsdb/archive/arch1_2574.logIdentified end-of-REDO for thread 1 sequence 2574Identified end-of-REDO for thread 1 sequence 2574Media Recovery End
oracle reinstate,[转帖]DG BROKER 之 REINSTATE DATABASE (把旧主库恢复到备用库)_MySQL, Oracle及数据库讨论区_Weblogic技术|Tux...
weixin_39550258的博客
04-16 327
DGMGRL>connectsys/oracle@dbsalve;已连接。DGMGRL>showconfiguration;配置 - DG_BROKER_SALVE保护模式: MaxAvailability数据库:DBSALVE - 主数据库错误: ORA-16825: 检测到数据库的多个错误或警告, 包括与快速启动故障转移相关的错误或警告DBMAST - (*) 物理...
dg之主备切换
Qdblinxi的博客
10-14 432
主备切换前，一定要注意日志全都应用 主备切换报错，如何切换回去？ 现备库（原主库）切回主库 QL> select database_role,switchover_status from v$database; DATABASE_ROLE SWITCHOVER_STATUS PHYSICAL STANDBY SESSIONS ACTIVE SQL> alter database commit to switchover to primary with session shutdown; Da
SWITCHOVER主库出现LOG SWITCH GAP和RESOLVABLE GAP解决一例
guoliang
12-18 1635
SWITCHOVER主库出现LOG SWITCH GAP和RESOLVABLE GAP解决一例  switchover，环境是11.2.0.3+OEL5.7，开始时主备库状态都是正常的，符合直接切换条件： 主库： SQL> select open_mode,database_role,switchover_status from v$database; OPEN_MOD
oracle dg主备切换 更换ip,【DG】主备切换
weixin_33277215的博客
04-16 747
一：DG之主备切换(主切备、备切主)1)主切备：SYS@ORA11GR2>selectdatabase_role,switchover_status from v$database;DATABASE_ROLESWITCHOVER_STATUS---------------- --------------------PRIMARYSESSIONS ACTIVESYS@ORA11GR2>a...
ADS.rar_ocm12232_ucos_ucos ads_ucos-ii_ucos移植
09-23
在本文中，我们将深入探讨如何将嵌入式操作系统(uCOS-II)移植到OCM12232微控制器上，以及与之相关的广告显示系统(ADS)集成。移植过程通常涉及硬件接口适配、中断服务例程(ISRs)编写、内存管理优化等多个方面。下面...
yejin.rar_OCM12864-9_ks0107_lcd ks0107_ocm12864
09-14
《OCM12864液晶显示模块与KS0107控制器详解》 OCM12864液晶显示模块在嵌入式系统和工业设备中广泛应用，它以其高清晰度和灵活的显示能力而备受青睐。这个128×64像素的点阵型液晶显示器能够展示丰富的字符和图形...
ocm.cankaochengxu.rar_OCM12864-9_ocm12864_ocm12864-1_ocm12864-2
09-22
标题中的"ocm.cankaochengxu.rar_OCM12864-9_ocm12864_ocm12864-1_ocm12864-2"表明这是一个关于OCM12864的参考资料压缩包，其中包含了不同版本的OCM12864程序或模块。OCM12864通常指的是一个128x64像素的图形显示...
ocm4x8c.rar_4x8c_OCM12864-9_OCM4X8C_ocm128_ocm12864
09-23
《OCM12864液晶驱动程序详解》 OCM12864是一款常见的128x64像素点阵图形液晶显示器，广泛应用于各种嵌入式系统和工业控制设备中。其驱动程序是连接硬件与软件的重要桥梁，通过C语言编写的驱动程序，我们可以实现对...
switchover切换步骤及遇到问题
Fred、的窃窃私语
04-21 7304
在打开数据库时出现ora-12541错误，检查后发现原因为没有启动监听！ SQL>LSNRCTL START   启动后就恢复正常 在主备库连接之后，我发现其中主库中的临时表空间路径在使用rman恢复时没有更改，是个错误路径，所以我使用http://blog.chinaunix.net/uid-25557346-id-2998578.html http://blog.chinaun
单节点DG的switchover切换介绍
cijuxk357157的博客
07-11 499
本章主要介绍DG的switchover切换，当用方法论来统筹知识和经验的时候，操作笔记的价值并不大，不过新手可以借鉴 PRIMARY: 主库是处于open状态，有业务访问，v$database视图中的switchover_s...
EXP-00091和IMP-00010解决办法
热门推荐
一抹曦阳-Oracle
03-27 1万+
在session4的4小题需要用到SH.COUNTRIES表，而手工建库时，这个SH用户没有这个表，就想着将别处的这个表拷贝过来。 原来导出表的库：database ORACLE_SID=TEST0221 版本： 11.2.0.4 需要导进的库：database ORACLE_SID=PROD 版本：10.2.0.1 因为字符集的问题，出现了EXP-00091的错误 因为数据库版
OCM实验目录
一抹曦阳-Oracle
03-29 1万+
OCM实验目录     环境准备   http://blog.csdn.net/rlhua/article/details/21370431 session0   http://blog.csdn.net/rlhua/article/details/21475621 session1 1.Database
OCM_环境准备
一抹曦阳-Oracle
03-17 4918
虚拟机：VirtualBox-4.3.8 虚拟机里装的OS：OracleLinux-R5-U7-Server-i386 内存：1024MB 一、配置本地yum环境 1.创建介质装载目录/media/disk: [root@ocm1 /]# pwd / [root@ocm1 /]# mkdir /media/disk 2.插入OEL DVD光盘 3.
OCM_Session7_5_修改/etc/security/limits.conf和 /etc/pam.d/login和/etc/profile
一抹曦阳-Oracle
03-23 4762
五、修改/etc/security/limits.conf和 /etc/pam.d/login和/etc/profile   这个在OCM环境已经配置好。 参考官方文档：http://docs.oracle.com/cd/B19306_01/install.102/b14203/prelinux.htm To increase the shell limits:
OCM_Session1_1_Database Setup and Undo Management
一抹曦阳-Oracle
03-18 3989
TIMES: 45 minutes  1. Database Setup and Undo Management  1.1 Run the minimum required scripts to complete the basic configuration of the PROD database. 1.2 Set up automatic undo management in
OCM_session0手动建库实验
一抹曦阳-Oracle
03-18 3913
Section 0 :创建数据库(即手动建库) 1. Create a database the sid name is PROD 2. Don't run the Script catalog.sql and catproc.sql 参考联机文档： Reference ==> Basic Initialization Parameters http://docs.ora
OCM_Session4_3_Oracle_Loader External Tables
一抹曦阳-Oracle
03-27 3689
3. Oracle_Loader External Tables 3.1 In the scripts directory, you will find prod_master.dat and prod_master.ctl. Using the information found in these files, create an external table names PROD_MASTER
1Z0-043认证：10g Oracle数据库管理高效学习策略
DBA2_1Z0-043_10g_datalab_zj-445 是一份针对Oracle Database 10g Administration的认证考试分析材料，主要关注1Z0-043认证的应试技巧。该文档强调了归纳、平衡和循环学习法在备考中的关键作用。 1. **应试技巧：...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值