ITPub博客

首页 > Linux操作系统 > Linux操作系统 > using same primary image copy and standby datafile

using same primary image copy and standby datafile

原创 Linux操作系统 作者:wisdomone1 时间:2010-02-02 01:25:27 0 删除 编辑

To create a standby database when the copies and standby datafiles have the same names:

  1. After connecting to the primary database, and if desired, the recovery catalog database, mount but do not open the primary database and ensure the database was closed cleanly before mounting. For example, enter:

    RMAN> STARTUP MOUNT PFILE=init.ora;
  2. Make sure that you set DB_FILE_NAME_CONVERT in the standby initialization parameter file so that standby datafile file names are translated from the primary datafile file names. For example:

    DB_FILE_NAME_CONVERT = '/oracle/dbs', '/dsk2/oracle'
  3. Copy all of the datafiles and the standby control file. For example, enter:

    COPY 
    DATAFILE 1 TO '/dsk2/oracle/df_1.f',
    DATAFILE 2 TO '/dsk2/oracle/df_2.f',
    DATAFILE 3 TO '/dsk2/oracle/df_3.f',
    DATAFILE 4 to '/dsk2/oracle/df_4.f',
    DATAFILE 5 TO '/dsk2/oracle/df_5.f',
    DATAFILE 6 TO '/dsk2/oracle/df_6.f',
    DATAFILE 7 TO '/dsk2/oracle/df_7.f',
    DATAFILE 8 to '/dsk2/oracle/df_8.f',
    DATAFILE 9 TO '/dsk2/oracle/df_9.f',
    DATAFILE 10 TO '/dsk2/oracle/df_10.f',
    DATAFILE 11 TO '/dsk2/oracle/df_11.f',
    DATAFILE 12 to '/dsk2/oracle/df_12.f',
    CURRENT CONTROLFILE FOR STANDBY TO '/dsk2/oracle/cf.f';
  4. Start the standby instance and mount the standby control file. For example, start SQL*Plus and enter:

    SQL> STARTUP NOMOUNT PFILE=/dsk2/oracle/dbs/initSTANDBY1.ora
    SQL> ALTER DATABASE MOUNT;

上面这种情况,我没有明白,有何作用,后期再看官方文档,再测试下,
我mount备库后,一开mrp,就提示如下错误,摘录以纪
Sun Jan 31 07:56:24 2010
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
Sun Jan 31 07:56:24 2010
Attempt to start background Managed Standby Recovery process (rhel)
MRP0 started with pid=18, OS id=26807
Sun Jan 31 07:56:24 2010
MRP0: Background Managed Standby Recovery process started (rhel)
Managed Standby Recovery not using Real Time Apply
Sun Jan 31 07:56:29 2010
Errors in file /oracle/admin/centos/bdump/rhel_dbw0_26771.trc:
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '/oracle/rmancopy/users01.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
MRP0: Background Media Recovery terminated with error 1110
Sun Jan 31 07:56:29 2010
Errors in file /oracle/admin/centos/bdump/rhel_mrp0_26807.trc:
ORA-01110: data file 4: '/oracle/rmancopy/users01.dbf'
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '/oracle/rmancopy/users01.dbf'
Sun Jan 31 07:56:29 2010
Errors in file /oracle/admin/centos/bdump/rhel_mrp0_26807.trc:
ORA-01110: data file 4: '/oracle/rmancopy/users01.dbf'
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '/oracle/rmancopy/users01.dbf'
Sun Jan 31 07:56:29 2010
MRP0: Background Media Recovery process shutdown (rhel)

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

请登录后发表评论 登录
全部评论
提供针对oracle初学者及进阶的数据库培训,欢迎大家咨询: 微信: wisdomone 微信公众号: lovedb 工作经历: 中国普天 北京科蓝 北京云和恩墨 北京神州新桥

注册时间:2008-04-04

  • 博文量
    2189
  • 访问量
    12689910