Oracle 設定指定DBID

設定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。

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/23071790/viewspace-701492/，如需轉載，請註明出處，否則將追究法律責任。