• 设置DBID


    查询源数据库的DBID,用rman登陆数据库或者select dbid from v$database;。

    源DBID=392820279。
    登陆到目标数据库,查看DBID

    C:/>rman target /

    Recovery Manager: Release 10.2.0.1.0 - Production on Tue Apr 14 00:27:31 2009

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

    connected to target database: MICHAEL (DBID=393099115)

    RMAN>

    设置DBID

    C:/Documents and Settings/Administrator>sqlplus sys/123@michael as sysdba

    SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 14 00:33:28 2009

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

    Connected to:

    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

    With the Partitioning, OLAP and Data Mining options

    SQL> select dbid from v$database;

    DBID

    ----------

    393099115

    SQL> show parameter db_name

    NAME TYPE VALUE

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

    db_name string michael

    SQL> exec dbms_backup_restore.nidbegin('michael','MICHAEL','392820279', 393099115,0,0,10)

    PL/SQL procedure successfully completed.

    SQL> select dbid from v$database;

    DBID

    ----------

    393099115

    SQL> variable a number;

    SQL> variable b number;

    SQL> variable c number;

    SQL> exec dbms_backup_restore.nidprocessdf(0,0,:a,:b,:c);

    PL/SQL procedure successfully completed.

    SQL> print :a

    A

    ----------

    0

    SQL> print :b

    B

    ----------

    1

    SQL> print :c

    C

    ----------

    1

    SQL> exec dbms_backup_restore.nidprocesscf(:a,:b);

    PL/SQL procedure successfully completed.

    SQL> print :a

    A

    ----------

    1

    SQL> print :b

    B

    ----------

    1

    SQL> exec dbms_backup_restore.nidend;

    PL/SQL procedure successfully completed.

    SQL> select dbid from v$database;

    DBID

    ----------

    392820279

    代码说明:

    show parameter db_name

    NAME TYPE VALUE

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

    db_name string testing

    SQL> exec dbms_backup_restore.nidbegin('michael','MICHAEL','392820279', 393099115,0,0,10)

    Param 1:目标数据库的实例名,即VALUE。

    Param 2:为更改后的实例名,必须大写。

    Param 3:为更改后的DBID。

    Param 4:为原来的DBID。

  • 相关阅读:
    20171017/20171018
    BZOJ[3193] [JLOI2013]地形生成
    BZOJ[1009] [HNOI2008]GT考试
    BZOJ[4767] 两双手
    BZOJ[4013] [HNOI2015]实验比较
    BZOJ[1925] [Sdoi2010]地精部落
    20171015 杂题
    20171015
    20171014
    USACO 2015 December Contest, Gold Problem 3. Bessie's Dream
  • 原文地址:https://www.cnblogs.com/liuyou/p/2618483.html
Copyright © 2020-2023  润新知