Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › oms 10g 创建 dataguard failed
发新帖
fengyunsen

12

积分

0

好友

1

主题

oms 10g 创建 dataguard failed

1#
发表于 2012-2-1 15:25:32 | 查看: 8413| 回复: 10
Step: Create Standby Database


SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 1 11:09:57 2012

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

SQL> SQL> Connected.
SQL> SQL> SQL> ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 1 11:10:14 2012

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

SQL> SQL> Connected to an idle instance.
SQL> SQL> ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area  603979776 bytes
Fixed Size                    1220820 bytes
Variable Size                  163581740 bytes
Database Buffers          436207616 bytes
Redo Buffers                    2969600 bytes
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 1 11:10:16 2012

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

SQL> Connected.
SQL> SQL>   2    3    4    5    6    7    8    9   10   11   12   13   14   15   16   17   18   19   20   21   22  
PL/SQL procedure successfully completed.

SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 1 11:10:20 2012

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

SQL> SQL> Connected.
SQL> SQL> SQL> ORA-01507: database not mounted


ORACLE instance shut down.
SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 1 11:10:26 2012

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

SQL> SQL> Connected to an idle instance.
SQL> SQL> ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area  603979776 bytes
Fixed Size                    1220820 bytes
Variable Size                  163581740 bytes
Database Buffers          436207616 bytes
Redo Buffers                    2969600 bytes
Database mounted.
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 1 11:10:33 2012

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

SQL> SQL> Connected.
SQL> SQL> SQL> ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 1 11:10:50 2012

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

SQL> SQL> Connected to an idle instance.
SQL> SQL> ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area  603979776 bytes
Fixed Size                    1220820 bytes
Variable Size                  163581740 bytes
Database Buffers          436207616 bytes
Redo Buffers                    2969600 bytes
Database mounted.
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
dgcreate.DGrenameFiles: ALTER DATABASE RENAME FILE '/usr/local/oracle/oradata/orcl/system01.dbf' to '/datamount/system01.dbf'
dgcreate.DGrenameFiles: SELECT STATUS FROM V$DATAFILE WHERE NAME = '/usr/local/oracle/oradata/orcl/system01.dbf'
dgcreate.DGrenameFiles: ALTER DATABASE RENAME FILE '/usr/local/oracle/oradata/orcl/undotbs01.dbf' to '/datamount/undotbs01.dbf'
dgcreate.DGrenameFiles: SELECT STATUS FROM V$DATAFILE WHERE NAME = '/usr/local/oracle/oradata/orcl/undotbs01.dbf'
dgcreate.DGrenameFiles: ALTER DATABASE RENAME FILE '/usr/local/oracle/oradata/orcl/sysaux01.dbf' to '/datamount/sysaux01.dbf'
dgcreate.DGrenameFiles: SELECT STATUS FROM V$DATAFILE WHERE NAME = '/usr/local/oracle/oradata/orcl/sysaux01.dbf'
dgcreate.DGrenameFiles: ALTER DATABASE RENAME FILE '/usr/local/oracle/oradata/orcl/users01.dbf' to '/datamount/users01.dbf'
dgcreate.DGrenameFiles: SELECT STATUS FROM V$DATAFILE WHERE NAME = '/usr/local/oracle/oradata/orcl/users01.dbf'
dgcreate.DGrenameFiles: ALTER DATABASE RENAME FILE '/usr/local/oracle/oradata/orcl/example01.dbf' to '/datamount/example01.dbf'
dgcreate.DGrenameFiles: SELECT STATUS FROM V$DATAFILE WHERE NAME = '/usr/local/oracle/oradata/orcl/example01.dbf'
dgcreate.DGrenameFiles: ALTER DATABASE RENAME FILE '/usr/local/oracle/oradata/orcl/memberstore.dbf' to '/datamount/memberstore.dbf'
dgcreate.DGrenameFiles: SELECT STATUS FROM V$DATAFILE WHERE NAME = '/usr/local/oracle/oradata/orcl/memberstore.dbf'
dgcreate.DGrenameFiles: ALTER DATABASE RENAME FILE '/usr/local/oracle/oradata/orcl/membertest.dbf' to '/datamount/membertest.dbf'
dgcreate.DGrenameFiles: SELECT STATUS FROM V$DATAFILE WHERE NAME = '/usr/local/oracle/oradata/orcl/membertest.dbf'
dgcreate.DGrenameFiles: ALTER DATABASE RENAME FILE '/usr/local/oracle/oradata/orcl/redo01.log' to '/datamount/redo01.log'
dgcreate.DGrenameFiles: ALTER DATABASE RENAME FILE '/usr/local/oracle/oradata/orcl/redo02.log' to '/datamount/redo02.log'
dgcreate.DGrenameFiles: ALTER DATABASE RENAME FILE '/usr/local/oracle/oradata/orcl/redo03.log' to '/datamount/redo03.log'
dgcreate.DGrenameFiles: ALTER DATABASE RENAME FILE '/usr/local/oracle/oradata/orcl/redo04.log' to '/datamount/redo04.log'
dgcreate.DGrenameFiles: ALTER DATABASE RENAME FILE '/usr/local/oracle/oradata/orcl/redo05.log' to '/datamount/redo05.log'
dgcreate.DGrenameFiles: ALTER DATABASE RENAME FILE '/usr/local/oracle/oradata/orcl/redo06.log' to '/datamount/redo06.log'
dgcreate.DGrenameFiles: ALTER DATABASE RENAME FILE '/usr/local/oracle/oradata/orcl/redo07.log' to '/datamount/redo07.log'
dgcreate.DGrenameFiles: ALTER DATABASE CLEAR LOGFILE GROUP 1
dgcreate.DGrenameFiles: ALTER DATABASE CLEAR LOGFILE GROUP 2
dgcreate.DGrenameFiles: ALTER DATABASE CLEAR LOGFILE GROUP 3
dgcreate.DGrenameFiles: ALTER DATABASE CLEAR LOGFILE GROUP 4
dgcreate.DGrenameFiles: ALTER DATABASE CLEAR LOGFILE GROUP 5
dgcreate.DGrenameFiles: ALTER DATABASE CLEAR LOGFILE GROUP 6
dgcreate.DGrenameFiles: ALTER DATABASE CLEAR LOGFILE GROUP 7
dgcreate.DGgetRecoverySCN: SELECT MAX(NEXT_CHANGE#) FROM V$ARCHIVED_LOG
dgcreate.DGcreateSpfile: CREATE SPFILE FROM PFILE='/opt/oracle/product/10.2.0/db_1/dbs/initrac1.ora'

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 1 11:11:44 2012

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

SQL> SQL> Connected.
SQL> SQL> SQL> ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 1 11:12:01 2012

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

SQL> SQL> Connected to an idle instance.
SQL> SQL> ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area  603979776 bytes
Fixed Size                    1220820 bytes
Variable Size                  163581740 bytes
Database Buffers          436207616 bytes
Redo Buffers                    2969600 bytes
Database mounted.
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Use of uninitialized value in substitution (s///) at - line 6280.

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Feb 1 11:12:09 2012

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

RMAN>
connected to target database: ORCL (DBID=1294124620, not open)
using target database control file instead of recovery catalog

RMAN>
echo set on


RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
new RMAN configuration parameters are successfully stored
exit;

Recovery Manager complete.
ORA-16796: one or more properties could not be imported from the database

[ 本帖最后由 fengyunsen 于 2012-2-1 15:27 编辑 ]
2#
发表于 2012-2-1 17:22:05
没有一句 事实描述， 请参考的 提问的艺术

回复 只看该作者 道具 举报

3#
发表于 2012-2-2 18:08:18

回复 2# 的帖子

***3台服务器，一台做grid control，另外两台做数据库，这个两台中其中一个做主库(主机名字:memberstore-host)一个做备库(主机名字:rac2),memberstore-host安装了redhat6和oracle10g，
rac2上面安装了redhat5和oracle10g,只是linux系统版本不同，数据库都一样;
****使用grid control创建dataguard，memberstore-host主库，rac2备库,memberstor-host开启了归档模式,rac2没有开归档;
一开始很顺利都到达第33步，但是一到34步Step: Create Standby Database的时候就弹出faild,查过备库上面的日志：

DG 2012-02-02-17:25:54        0 2 0 DMON: Error opening /opt/oracle/product/10.2.0/db_1/dbs/dr2orclstan.dat, error = ORA-16572
DG 2012-02-02-17:25:54        0 2 0 DMON: cannot open configuration file "/opt/oracle/product/10.2.0/db_1/dbs/dr2orclstan.dat"
DG 2012-02-02-17:25:54        0 2 0   ORA-27037: unable to obtain file status
DG 2012-02-02-17:25:54        0 2 0   Linux Error: 2: No such file or directory

只是为什么？

回复 只看该作者 道具 举报

4#
发表于 2012-2-2 18:56:03
DG 2012-02-02-17:25:54        0 2 0 DMON: Error opening /opt/oracle/product/10.2.0/db_1/dbs/dr2orclstan.dat, error = ORA-16572

DMON 后台进程要求访问 dg broker 配置文件， 但是你的 dr2orclstan.dat存在问题

oerr ora 16572
16572, 00000, "Data Guard configuration file not found"
// *Cause:  The Data Guard broker configuration file was either unavailable or
//          did not exist.
// *Action: Verify that the configuration file was successfully created.
//          If the dg_broker_config_file[1|2] parameter was changed, ensure
//          the filename on disk and the parameter value match, there is
//          space on the device, and you have the right permissions.


说明你在使用OMS 创建DG 时  勾选了 Use DataGuard Broker 的选项， 把这个选项 取消掉试试

回复 只看该作者 道具 举报

5#
发表于 2012-2-3 09:26:07
时间证明了，我没有选 Use DataGuard Broker 的选项，结果还是一样，又卡在 Create Standby Database

日志：

DG 2012-02-02-23:00:11        0 2 0 DMON: cannot open configuration file "/opt/oracle/product/10.2.0/db_1/dbs/dr2orcls.dat"
DG 2012-02-02-23:00:11        0 2 0   ORA-27037: unable to obtain file status
DG 2012-02-02-23:00:11        0 2 0   Linux Error: 2: No such file or directory
DG 2012-02-02-23:00:11        0 2 0   Additional information: 3
DG 2012-02-02-23:00:11        0 2 0 DMON: cannot open configuration file "/opt/oracle/product/10.2.0/db_1/dbs/dr2orcls.dat"
DG 2012-02-02-23:00:11        0 2 0   ORA-27037: unable to obtain file status
DG 2012-02-02-23:00:11        0 2 0   Linux Error: 2: No such file or directory
DG 2012-02-02-23:00:11        0 2 0   Additional information: 3
DG 2012-02-02-23:00:11        0 2 0 DMON: Configuration does not exist, server ready.
DG 2012-02-02-23:00:11        0 2 0 DMON: Entered rfm_release_chief_lock for CTL_BOOTSTRAP
DG 2012-02-02-23:01:06        0 2 0 #### NSV network timeout value set to 0 seconds by USER
DG 2012-02-02-23:02:52        0 2 774226972 DMON: MON_PROPERTY operation completed
DG 2012-02-02-23:02:52        0 2 774226973 DMON: CTL_GET_STATUS operation completed
DG 2012-02-02-23:07:56        0 2 774226974 DMON: MON_PROPERTY operation completed
DG 2012-02-02-23:07:57        0 2 774226975 DMON: CTL_GET_STATUS operation completed
DG 2012-02-02-23:12:52        0 2 774226976 DMON: MON_PROPERTY operation completed
DG 2012-02-02-23:12:52        0 2 774226977 DMON: CTL_GET_STATUS operation completed
DG 2012-02-02-23:17:51        0 2 774226978 DMON: MON_PROPERTY operation completed
DG 2012-02-02-23:17:52        0 2 774226979 DMON: CTL_GET_STATUS operation completed
DG 2012-02-02-23:22:51        0 2 774226980 DMON: MON_PROPERTY operation completed
DG 2012-02-02-23:22:52        0 2 774226981 DMON: CTL_GET_STATUS operation completed
DG 2012-02-02-23:31:14        0 2 0 DMON: Data Guard Broker shutting down
DG 2012-02-02-23:31:14        0 2 0 DMON: Terminating RSM processes
DG 2012-02-02-23:31:14        0 2 0 DMON: Terminating NetSlave processes
DG 2012-02-02-23:31:14        0 2 0 DMON: Terminating Instance Slave process
DG 2012-02-02-23:31:14        0 2 0 DMON: Zeroing metadata root pointer
DG 2012-02-02-23:31:14        0 2 0 DMON: Clearing Primary State
DG 2012-02-02-23:31:14        0 2 0 DMON: Freeing Broker SGA heap
DG 2012-02-02-23:31:14        0 2 0 DMON: Freeing PGA heap
DG 2012-02-02-23:31:14        0 2 0 DMON: Removing DMON's state object
DG 2012-02-02-23:31:14        0 2 0 DMON: Resetting DMON context structure
DG 2012-02-02-23:31:14        0 2 0 DMON: >> DMON Process Shutdown <<
DG 2012-02-02-23:31:24        0 2 0 DMON: Data Guard Broker shutting down
DG 2012-02-02-23:31:24        0 2 0 DMON: >> DMON Process Shutdown <<
DG 2012-02-02-23:31:30        0 2 0 DMON: Data Guard Broker shutting down
DG 2012-02-02-23:31:30        0 2 0 DMON: >> DMON Process Shutdown <<

回复 只看该作者 道具 举报

6#
发表于 2012-2-3 10:30:57
再查看alert.log(以上都是在standby database上面的日志)

Thu Feb  2 23:31:34 2012
ALTER DATABASE   MOUNT
Thu Feb  2 23:31:34 2012
ORA-00202: control file: '/oraclebackup/control01.ctl'
ORA-27086: unable to lock file - already in use
Linux Error: 11: Resource temporarily unavailable
Additional information: 8
Additional information: 29204
Thu Feb  2 23:31:34 2012
ORA-205 signalled during: ALTER DATABASE   MOUNT...
Thu Feb  2 23:31:34 2012
ALTER DATABASE RENAME FILE '/usr/local/oracle/oradata/orcl/system01.dbf' to '/oraclebackup/system01.dbf'
ORA-1507 signalled during: ALTER DATABASE RENAME FILE '/usr/local/oracle/oradata/orcl/system01.dbf' to '/oraclebackup/system01.dbf'...

回复 只看该作者 道具 举报

7#
发表于 2012-2-3 10:41:35
尝试关闭standby database
sql>shutdown immediate;

ORA-00600: internal error code, arguments: [2141], [1301972890], [0], [], [], [], [], []

回复 只看该作者 道具 举报

8#
发表于 2012-2-3 15:29:32
ODM data:

ORA-16796: one or more properties could not be imported from the database
  1. ORA-16796: one or more properties could not be imported from the database [ID 358040.1]
  2. Applies to:
  3. Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 - Release: 10.2 to 10.2
  4. Information in this document applies to any platform.
  5. ***Checked for relevance on 15-APR-2011***
  6. Symptoms



  10. $ dgmgrl
  11. DGMGRL for Linux: Version 10.2.0.1.0 - Production

  13. Copyright (c) 2000, 2005, Oracle. All rights reserved.

  15. Welcome to DGMGRL, type "help" for information.
  16. DGMGRL> connect sys/<Password>
  17. Connected.
  18. DGMGRL> remove configuration
  19. Removed configuration

  21. DGMGRL> create configuration 'SHRUB' as
  22. > primary database is 'SHRUB'
  23. > connect identifier is 'SHRUB';
  24. Configuration "SHRUB" created with primary database "SHRUB"

  26. DGMGRL> add database 'WAGTAIL' as
  27. > connect identifier is wagtail
  28. > maintained as physical;
  29. Error: ORA-16796: one or more properties could not be imported from the database

  31. Failed.



  35. Following error reported in the standby dataguard broker log


  38. DG 2006-02-14-22:16:08 0 2 0 DMON: cannot open configuration file "/oracle/product/10.2.0/dbs/dr2wagtail.dat"



  42. Cause

  44. Noticed following file was not exists at standby server.


  47. DG 2006-02-14-22:16:08 0 2 0 DMON: cannot open configuration file "/oracle/product/10.2.0/dbs/dr2wagtail.dat"
  48. Solution

  50. 1) Stop the Data Guard Broker on both, the Primary and Standby Database using following Command:


  53. SQL> alter system set dg_broker_start=false scope=both;



  57. 2) Remove the old Data Guard Broker Configuration Files specified by the Initialization Parameter 'DG_BROKER_CONFIG_FILE1|2' from Primary and Standby Site.

  59. 3)  Start the Data Guard Broker on both Sites again:


  62. SQL> alter system set dg_broker_start = true scope=both;



  66. 4) Recreate the Data Guard Broker Configuration
复制代码
检查一下Primary上的 dg_broker_start 参数

回复 只看该作者 道具 举报

9#
发表于 2012-2-3 15:35:05
关于你说的 ”时间证明了，我没有选 Use DataGuard Broker 的选项，结果还是一样，又卡在 Create Standby Database“

可能是因为OMS 10.2.0.1的bug引起的， 具体的bug#目前没有找到。

如果希望使用Grid Control OMS 10g配置 Data Guard的话 建议至少升级到10.2.0.5, 10.2.0.1 创建DG成功的概率很低。

文档Implement or Extend HA with Oracle Database 11g and Oracle Data Guard using Grid Control [ID 872352.1] 介绍了 OMS创建DG 必要的补丁包


Abstract
This white paper provides a step-by-step walkthrough of the tasks and processes involved in using Oracle Enterprise Manager Grid Control Release 10.2.0.5 to configure a complete Oracle Maximum Availability Architecture (MAA) implementation on Oracle Database 11g release 11.1.0.7.
Document History
Create Date 11-08-2009
Update Date 03-01-2012
Expire Date 02-01-2013
Implement or Extend HA with Oracle Database 11g and Oracle Data Guard using Grid Control
Required Patches:
Install the following patches to insure the procedures will work as documented in the paper:

Patch: 8518005 – Bundle patch for Deployment Procedure with Grid Control 10.2.0.5

Watch for availability of unpublished BUG: 7569643 – Bundle patch for Database 11.1.0.7

回复 只看该作者 道具 举报

10#
发表于 2012-2-3 16:08:17
Oracle Enterprise Manager 10g Release 5 Grid Control 10.2.0.5.0.  
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version     : 10.2.0.5.0
OMS Version       : 10.2.0.5.0
Protocol Version  : 10.2.0.5.0
Agent Home        : /opt/oracle/OracleHomes/agent10g
Agent binaries    : /opt/oracle/OracleHomes/agent10g
Agent Process ID  : 20987
Parent Process ID : 20965
Agent URL         : https://rac2:1831/emd/main/
Repository URL    : https://samfeng:1159/em/upload
Started at        : 2012-02-02 20:36:21
Started by user   : oracle
Last Reload       : 2012-02-03 14:17:30
Last successful upload                       : 2012-02-03 16:03:43
Total Megabytes of XML files uploaded so far :    18.75
Number of XML files pending upload           :        0
Size of XML files pending upload(MB)         :     0.00
Available disk space on upload filesystem    :    60.00%
Last successful heartbeat to OMS             : 2012-02-03 16:04:24

我使用的 oms version是10.2.0.5.0～～～

回复 只看该作者 道具 举报

11#
发表于 2012-11-28 10:41:01
我也碰到类似问题，环境是 oel5.5 32位 + oracle 10.2.0.1 + grid 10.2.0.1
出现类似的如下错误：
DG 2006-02-14-22:16:08 0 2 0 DMON: cannot open configuration file "/oracle/product/10.2.0/dbs/dr2wagtail.dat"
似乎gc一个bug,无法自己创建dr2Sid.dat
正常的选择是升级到新版本再试；

但如果从学术角度， 请教下，如果是你，还会有思路诊断下去吗？

回复 只看该作者 道具 举报

返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-16 04:22 , Processed in 0.057383 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569