實驗平台:REDHATlinux4.7+oracle10g
目标庫資訊:
ORACLE_BASE:/u01/app/oracle
ORACLE_HOME:/u01/app/oracle/product/10.2.0/db_1
ORACLE_SID:orcl
IP:192.168.1.20
輔助庫資訊:
IP:192.168.1.21
我們以執行個體名相同的為例,執行個體名不同也一樣,在pfile裡修改對應參數就可以了。
步驟如下:
(1)建構輔助資料庫目錄結構
(2)建立pfile,并複制到輔助資料庫,修改相關内容
(3)建立輔助執行個體密碼檔案
(4)RMAN備份源庫
(5)添加配置監聽
(6)将源庫備份檔案拷貝到輔助庫相同位置
(7)用pfile檔案,将輔助資料庫啟動到nomount狀态
(8)執行RMANduplicate指令複制資料庫
(9)建立spfile檔案
(10)在錄音帶上恢複備份
(11)使用DBNEWID程式生成新的DBID
一.建構輔助資料庫目錄結構
1.1Oracledata目錄
[oracle@localhostoracle]$mkdiroradata
[oracle@localhostoracle]$ls
oradataoraInventoryproduct
[oracle@localhostoracle]$cdoradata/
[oracle@localhostoracle]$mkdirorcl
1.2其他目錄
[oracle@localhostoracle]$pwd
/u01/app/oracle
[oracle@localhostoracle]$mkdiradmin
adminoradataoraInventoryproduct
[oracle@localhostoracle]$cdadmin
[oracle@localhostadmin]$ls
[oracle@localhostadmin]$mkdirorcl
orcl
[oracle@localhostadmin]$cdorcl
[oracle@localhostorcl]$mkdiradump
[oracle@localhostorcl]$mkdirbdump
[oracle@localhostorcl]$mkdircdump
[oracle@localhostorcl]$mkdirdpdump
[oracle@localhostorcl]$mkdirpfile
[oracle@localhostorcl]$mkdirudump
[oracle@localhostorcl]$ls
adumpbdumpcdumpdpdumppfileudump
二.建立pfile,複制到輔助資料庫,并修改相關參數
2.1在源庫上建立pfile檔案
SQL>connsys/admin@orclassysdba;
Connected.
SQL>createpfilefromspfile;
Filecreated.
2.2用scp指令将pfile檔案傳到輔助庫。要放在$ORACLE_HOME/dbs目錄下,不然ORACLE不識别。
[oracle@db1orcl]$cd/u01/app/oracle/product/10.2.0/db_1/dbs
[oracle@db1dbs]$ls
hc_DAVE.datinitdw.oralkDAVEorapworclspfileorcl.ora
hc_orcl.datinit.oralkORCLsnapcf_orcl.f
initDAVE.orainitorcl.oraorapwDAVEspfileDAVE.ora
[oracle@db1dbs]$scpinitorcl.ora192.168.1.21:/$ORACLE_HOME/dbs
Theauthenticityofhost'192.168.1.21(192.168.1.21)'can'tbeestablished.
RSAkeyfingerprintis1a:20:7a:05:bd:e0:ac:04:21:02:b1:72:01:69:40:d6.
Areyousureyouwanttocontinueconnecting(yes/no)?yes
Warning:Permanentlyadded'192.168.1.21'(RSA)tothelistofknownhosts.
[email protected]'spassword:
initorcl.ora100%11081.1KB/s00:00
2.3在輔助庫上确認檔案是否傳送過來
[oracle@localhostorcl]$cd$ORACLE_HOME/dbs
[oracle@localhostdbs]$ls
initdw.orainit.orainitorcl.ora
2.4在輔助庫上修改pfile參數
[oracle@localhostdbs]$moreinitorcl.ora
orcl.__db_cache_size=167772160
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__shared_pool_size=62914560
orcl.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.background_dump_dest='/u01/app/oracle/admin/orcl/bdump'
*.compatible='10.2.0.1.0'
*.control_file_record_keep_time=14
*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/or
adata/orcl/control02.ctl','/u01/app/oracle/oradata/orcl/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/orcl/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='orcl'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP)(SERVICE=orclXDB)'
*.job_queue_processes=10
*.log_archive_dest_1='location=/u01/archivelog'
*.open_cursors=300
*.pga_aggregate_target=81788928
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=246415360
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/orcl/udump'
說明,在這裡我沒有做修改,因為我異機複制執行個體名相同,存儲位置也相同。如果說你複制的不同的話,就需要修改相關的執行個體名。如果存儲位置不同的話,還需要添加以下參數,對資料檔案位置進行轉換。
db_file_name_convert=('/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/DAVE')
三.建立輔助執行個體ORCL的密碼檔案
[oracle@localhostdbs]$cd$ORACLE_HOME/bin
[oracle@localhostbin]$orapwdfile=$ORACLE_HOME/dbs/orapworclpassword=admin
[oracle@localhostbin]$cd$ORACLE_HOME/dbs
initdw.orainit.orainitorcl.oraorapworcl
windows下oracle預設的位置是$ORACLE_HOME/database目錄,檔案名格式是pwdSID.ora。
linux下oracle預設的位置是$ORACLE_HOME/dbs目錄,檔案名格式是orapwSID。
建立完後,資料庫需要重新開機動,新的密碼檔案才能生效。
關于密碼檔案建立,詳細内容參考blog:
OracleOS認證密碼檔案密碼丢失處理
<a href="http://blog.csdn.net/tianlesoftware/archive/2009/10/20/4698293.aspx" target="_blank">http://blog.csdn.net/tianlesoftware/archive/2009/10/20/4698293.aspx</a>
四.RMAN備份源庫(orcl)
[oracle@db1backup]$rmantargetsys/admin@orcl
RecoveryManager:Release10.2.0.1.0-ProductiononSunJul1818:26:162010
Copyright(c)1982,2005,Oracle.Allrightsreserved.
connectedtotargetdatabase:ORCL(DBID=1248423599)
RMAN>RUN{
allocatechannelc1typedisk;
allocatechannelc2typedisk;
BACKUPFORMAT'/u02/backup/orcl_%U_%T'skipinaccessiblefilesperset5DATABASETAGorcl_hot_db_bk;
sql'altersystemarchivelogcurrent';
BACKUPFORMAT'/u02/backup/arch_%U_%T'skipinaccessiblefilesperset5ARCHIVELOGALLDELETEINPUT;
backupcurrentcontrolfiletag='bak_ctlfile'format='/u02/backup/ctl_file_%U_%T';
backupspfiletag='spfile'format='/u02/backup/ORCL_spfile_%U_%T';
releasechannelc2;
releasechannelc1;
}
五.添加,配置監聽
5.1在輔助庫的Listener.ora檔案中,添加如下内容
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=PLSExtProc)
(ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1)
(PROGRAM=extproc)
)
(GLOBAL_DBNAME=orcl)
(SID_NAME=orcl)
5.2修改輔助庫的tnsnames.ora檔案,添加如下内容
TARGETORCL=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.20)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=orcl)
ORCL=
(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))
5.3修改源庫的tnsnames.ora檔案,添加如下内容:
AUXORCL=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.21)(PORT=1521))
(SERVER=DEDICATED)
<a href="http://blog.csdn.net/tianlesoftware/archive/2010/04/30/5543166.aspx" target="_blank"></a>
六.将源庫的備份拷貝到輔助資料庫的相同位置
這裡有兩種方法,一種直接在輔助庫上建相同的目錄結構,在用SCP指令把這些備份檔案copy過去,但是這樣會占用大量的網絡資源。還有一種就是建好目錄結構後用NFS直接Mount上去。在這裡我們用後面一種方法試一下。
6.1在輔助庫上建相同的備份目錄結構
因為我們在源庫上備份是備份到/u02/backup目錄中的,是以我們在輔助庫上也建這個目錄
[root@localhost/]#mkdir-p/u02/backup
[root@localhost/]#chownoracle/u02
[root@localhost/]#chmod777/u02
6.2将源庫的備份挂載到輔助庫上
6.2.1在源庫上将/u02/backup目錄添加到共享
[root@db1~]#more/etc/exports
/u02/backup192.168.1.21(rw,async,anonuid=65534,anongid=65534)
[root@db1~]#servicenfsstart
6.2.2在輔助庫上挂載源庫的目錄,注意,mount指令必須以root使用者執行
[root@localhost/]#mount-tnfs-orw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0
10.85.10.1:/u02/backup/u02/backup
--注意:在挂載NFS的時候,一定要加上-t-o參數,不然在RMAN複制的時候會報錯:
--ORA-27054:NFSfilesystemwherethefileiscreatedorresidesisnotmountedwithcorrectoptions
[root@localhost/]#cd/u02/backup/
[root@localhostbackup]#ls
arch_3klj4676_1_1_20100718orcl_3hlj45vf_1_1_20100718
arch_3llj4676_1_1_20100718orcl_3ilj465c_1_1_20100718
ctl_file_3mlj467h_1_1_20100718orcl_3jlj4661_1_1_20100718
orcl_3glj45vf_1_1_20100718ORCL_spfile_3nlj467k_1_1_20100718
七.啟動輔助庫至nomount狀态,注意使用pfile參數啟動
[oracle@localhostdbs]$sqlplus/nolog
SQL*Plus:Release10.2.0.1.0-ProductiononTueJul2003:53:532010
SQL>conn/assysdba
Connectedtoanidleinstance.
SQL>startupnomountpfile=?/dbs/initorcl.ora
ORACLEinstancestarted.
TotalSystemGlobalArea247463936bytes
FixedSize1218772bytes
VariableSize79693612bytes
DatabaseBuffers163577856bytes
RedoBuffers2973696bytes
SQL>exit--啟動後就退出session,因為在duplicata的時候不能有session連接配接
DisconnectedfromOracleDatabase10gEnterpriseEditionRelease10.2.0.1.0-Production
WiththePartitioning,OLAPandDataMiningoptions
八.RMAN連接配接到目标執行個體和輔助執行個體,運作duplicate指令複制資料庫
[oracle@db1~]$rmantargetsys/admin@orclauxiliarysys/admin@auxorcl;
RecoveryManager:Release10.2.0.1.0-ProductiononSunJul1820:41:192010
connectedtoauxiliarydatabase:ORCL(notmounted)
RMAN>duplicatetargetdatabasetoORCLnofilenamecheck
2>logfile
3>'/u01/app/oracle/oradata/orcl/redo01.dbf'size50m,
4>'/u01/app/oracle/oradata/orcl/redo02.dbf'size50m,
5>'/u01/app/oracle/oradata/orcl/redo03.dbf'size50m;
注:這個地方有2個地方需要說明:
(1)Nofilenamecheck參數:
如果在複制時,位置不同時,我們會用參數db_file_name_convert對檔案位置進行轉換。但是在這個複制示例中我們用的是相同的位置。是以這裡必須加上nofilenamecheck參數。該參數通知複制操作不必在執行還原操作前确認檔案名是不同的。如果沒有指定nofilenamecheck參數,rman會給出如下錯誤:
RMAN-05001:auxiliaryfilename/u01/app/oracle/oradata/orcl/example01.dbfconflictswithafileusedbythetargetdatabase
RMAN-05001:auxiliaryfilename/u01/app/oracle/oradata/orcl/users01.dbfconflictswithafileusedbythetargetdatabase
(2)logfile參數:
在完成複制程序并執行最有一條openresetlogs指令時,RMAN必須為輔助資料庫建構全新的日志檔案。如上面指令所示,我們可以在duplicate指令中指定logfile參數,并指定使用的日志檔案的大小,數目和位置。
還可以在pfile裡指定log_file_name_convert參數來進行轉換。這種方法相對而言要簡單一點。但因為我們在RMAN同機複制資料庫的例子中用的就是這種方法,是以就換種方法來測試。
StartingDuplicateDbat18-JUL-10
usingtargetdatabasecontrolfileinsteadofrecoverycatalog
allocatedchannel:ORA_AUX_DISK_1
channelORA_AUX_DISK_1:sid=155devtype=DISK
contentsofMemoryScript:
{
setuntilscn733545;
setnewnamefordatafile1to"/u01/app/oracle/oradata/orcl/system01.dbf";
setnewnamefordatafile2to"/u01/app/oracle/oradata/orcl/undotbs01.dbf";
setnewnamefordatafile3to"/u01/app/oracle/oradata/orcl/sysaux01.dbf";
setnewnamefordatafile4to"/u01/app/oracle/oradata/orcl/users01.dbf";
setnewnamefordatafile5to"/u01/app/oracle/oradata/orcl/example01.dbf";
restore
checkreadonly
clonedatabase;
executingMemoryScript
executingcommand:SETuntilclause
executingcommand:SETNEWNAME
Startingrestoreat18-JUL-10
usingchannelORA_AUX_DISK_1
channelORA_AUX_DISK_1:startingdatafilebackupsetrestore--開始restore資料檔案
channelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupset
restoringdatafile00002to/u01/app/oracle/oradata/orcl/undotbs01.dbf
restoringdatafile00003to/u01/app/oracle/oradata/orcl/sysaux01.dbf
restoringdatafile00005to/u01/app/oracle/oradata/orcl/example01.dbf
channelORA_AUX_DISK_1:readingfrombackuppiece/u02/backup/orcl_3plj4ejl_1_1_20100718
channelORA_AUX_DISK_1:restoredbackuppiece1
piecehandle=/u02/backup/orcl_3plj4ejl_1_1_20100718tag=ORCL_HOT_DB_BK
channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:01:48
channelORA_AUX_DISK_1:startingdatafilebackupsetrestore
restoringdatafile00001to/u01/app/oracle/oradata/orcl/system01.dbf
restoringdatafile00004to/u01/app/oracle/oradata/orcl/users01.dbf
channelORA_AUX_DISK_1:readingfrombackuppiece/u02/backup/orcl_3olj4ejk_1_1_20100718
piecehandle=/u02/backup/orcl_3olj4ejk_1_1_20100718tag=ORCL_HOT_DB_BK
channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:01:14
Finishedrestoreat18-JUL-10
sqlstatement:CREATECONTROLFILEREUSESETDATABASE"ORCL"RESETLOGSARCHIVELOG
--建立源庫的控制檔案,然後根據這個檔案進行相關的恢複
MAXLOGFILES16
MAXLOGMEMBERS3
MAXDATAFILES100
MAXINSTANCES8
MAXLOGHISTORY292
LOGFILE
GROUP1'/u01/app/oracle/oradata/orcl/redo01.dbf'SIZE50M,
GROUP2'/u01/app/oracle/oradata/orcl/redo02.dbf'SIZE50M,
GROUP3'/u01/app/oracle/oradata/orcl/redo03.dbf'SIZE50M
DATAFILE
'/u01/app/oracle/oradata/orcl/system01.dbf'
CHARACTERSETWE8ISO8859P1
switchclonedatafileall;
releasedchannel:ORA_AUX_DISK_1
datafile2switchedtodatafilecopy
inputdatafilecopyrecid=1stamp=724831148filename=/u01/app/oracle/oradata/orcl/undotbs01.dbf
datafile3switchedtodatafilecopy
inputdatafilecopyrecid=2stamp=724831148filename=/u01/app/oracle/oradata/orcl/sysaux01.dbf
datafile4switchedtodatafilecopy
inputdatafilecopyrecid=3stamp=724831148filename=/u01/app/oracle/oradata/orcl/users01.dbf
datafile5switchedtodatafilecopy
inputdatafilecopyrecid=4stamp=724831148filename=/u01/app/oracle/oradata/orcl/example01.dbf
recover
clonedatabase
deletearchivelog;
Startingrecoverat18-JUL-10
startingmediarecovery
channelORA_AUX_DISK_1:startingarchivelogrestoretodefaultdestination
channelORA_AUX_DISK_1:restoringarchivelog
archivelogthread=1sequence=46
channelORA_AUX_DISK_1:readingfrombackuppiece/u02/backup/arch_3tlj4er7_1_1_20100718
piecehandle=/u02/backup/arch_3tlj4er7_1_1_20100718tag=TAG20100718T205809
channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:01
archivelogthread=1sequence=45
channelORA_AUX_DISK_1:readingfrombackuppiece/u02/backup/arch_3slj4er7_1_1_20100718
piecehandle=/u02/backup/arch_3slj4er7_1_1_20100718tag=TAG20100718T205809
channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:02
archivelogfilename=/u01/archivelog/1_45_720642866.dbfthread=1sequence=45
channelclone_default:deletingarchivelog(s)
archivelogfilename=/u01/archivelog/1_45_720642866.dbfrecid=2stamp=724831155
archivelogfilename=/u01/archivelog/1_46_720642866.dbfthread=1sequence=46
archivelogfilename=/u01/archivelog/1_46_720642866.dbfrecid=1stamp=724831153
mediarecoverycomplete,elapsedtime:00:00:02
Finishedrecoverat18-JUL-10
shutdownclone;
startupclonenomount;
--如果此時,輔助執行個體上有session連在上面,将一直等到session退出才能執行,如果等了很長時間還沒有執行,不妨檢查一下,有沒有session連在資料庫上。
databasedismounted
Oracleinstanceshutdown
connectedtoauxiliarydatabase(notstarted)
Oracleinstancestarted
--建立新的控制檔案
setnewnamefortempfile1to
"/u01/app/oracle/oradata/orcl/temp01.dbf";
switchclonetempfileall;
catalogclonedatafilecopy"/u01/app/oracle/oradata/orcl/undotbs01.dbf";
catalogclonedatafilecopy"/u01/app/oracle/oradata/orcl/sysaux01.dbf";
catalogclonedatafilecopy"/u01/app/oracle/oradata/orcl/users01.dbf";
catalogclonedatafilecopy"/u01/app/oracle/oradata/orcl/example01.dbf";
renamedtemporaryfile1to/u01/app/oracle/oradata/orcl/temp01.dbfincontrolfile
catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/orcl/undotbs01.dbfrecid=1stamp=724831185
catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/orcl/sysaux01.dbfrecid=2stamp=724831186
catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/orcl/users01.dbfrecid=3stamp=724831186
catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/orcl/example01.dbfrecid=4stamp=724831186
inputdatafilecopyrecid=1stamp=724831185filename=/u01/app/oracle/oradata/orcl/undotbs01.dbf
inputdatafilecopyrecid=2stamp=724831186filename=/u01/app/oracle/oradata/orcl/sysaux01.dbf
inputdatafilecopyrecid=3stamp=724831186filename=/u01/app/oracle/oradata/orcl/users01.dbf
inputdatafilecopyrecid=4stamp=724831186filename=/u01/app/oracle/oradata/orcl/example01.dbf
Alterclonedatabaseopenresetlogs;
databaseopened
FinishedDuplicateDbat18-JUL-10
九.建立spfile,并驗證資料庫
通過上面8步的操作,複制操作已經完成。我們現在建立一個spfile。
SQL>createspfilefrompfile='/u01/app/oracle/product/10.2.0/db_1/dbs/initorcl.ora';
SQL>selectnamefromv$database;
NAME
---------
ORCL
SQL>selecttablespace_name,file_namefromdba_data_files;
TABLESPACE_NAMEFILE_NAME
-------------------------------------------------------------------------------
SYSTEM/u01/app/oracle/oradata/orcl/system01.dbf
UNDOTBS1/u01/app/oracle/oradata/orcl/undotbs01.dbf
SYSAUX/u01/app/oracle/oradata/orcl/sysaux01.dbf
USERS/u01/app/oracle/oradata/orcl/users01.dbf
EXAMPLE/u01/app/oracle/oradata/orcl/example01.dbf
十.在遠端伺服器上複制錄音帶備份
如果在遠端伺服器上複制錄音帶備份,必須配置輔助通道,以反映媒體管理器的需求。除了指定媒體管理器和用于正常通道的類或池外,還必須指定目标用戶端名稱,如下所示:
RMAN>configureauxiliarychannel1devicetypesbtparms="env=(nb_ora_serv=db1,nb_ora_client=db2)";
十一.使用DBNEWID适用程式的不完全複制
複制時最令人不滿意的一點是不存在"可重新開機的複制",也就是說,如果在執行還原所有檔案的步驟(複制程序中最常出錯)時出錯。比如在恢複操作期間出錯,就必須再次重新開機複制程序并重新還原檔案。我們無法修複複制程序(如使丢失的歸檔日志可用),隻能重新開始整個過程。
将resoteoptimization選項設定為on,rman就不會在還原位置中再次還原具有相同資料檔案頭SCN資訊檔案。這也适合用于複制操作。如果複制操作還原一個檔案,然後重新啟動該複制操作,RMAN将不會再次還原該檔案。然後,如果将一個歸檔日志應用于該檔案,則會再次還原該歸檔日志。
在Oracle10g中,使用DBNEWID使用程式可以部分修複恢複程序,這個使用程式以安全和可控的方式為複制的資料庫指定新的DBID。我們可以手工恢複複制的資料庫,準備所有元素,然後再次運作DBNEWID實用程式完成由複制操作啟動的程序。這就允許我們至少可以手工完成複制操作。
DBNEWID使用程式的用法很簡單。首先,必須确認在使用實用程式前生成了有效的備份,盡管要執行驗證備份的程序,但是在修改DBID期間仍然可能會遇到不可恢複的錯誤。确認備份有效後,還必須在一緻的狀态中關閉資料庫,然後将資料庫切換回加載狀态。
使用示例如下:
SQL>shutdownimmediate
Databaseclosed.
Databasedismounted.
ORACLEinstanceshutdown.
SQL>startupmount;
Databasemounted.
SQL>!
[oracle@localhostu01]$nidtarget=/
DBNEWID:Release10.2.0.1.0-ProductiononTueJul2007:20:372010
ConnectedtodatabaseORCL(DBID=1252611919)
Connectedtoserverversion10.2.0
ControlFilesindatabase:
/u01/app/oracle/oradata/orcl/control01.ctl
/u01/app/oracle/oradata/orcl/control02.ctl
/u01/app/oracle/oradata/orcl/control03.ctl
ChangedatabaseIDofdatabaseORCL?(Y/[N])=>y
Proceedingwithoperation
ChangingdatabaseIDfrom1252611919to1252672326
ControlFile/u01/app/oracle/oradata/orcl/control01.ctl-modified
ControlFile/u01/app/oracle/oradata/orcl/control02.ctl-modified
ControlFile/u01/app/oracle/oradata/orcl/control03.ctl-modified
Datafile/u01/app/oracle/oradata/orcl/system01.dbf-dbidchanged
Datafile/u01/app/oracle/oradata/orcl/undotbs01.dbf-dbidchanged
Datafile/u01/app/oracle/oradata/orcl/sysaux01.dbf-dbidchanged
Datafile/u01/app/oracle/oradata/orcl/users01.dbf-dbidchanged
Datafile/u01/app/oracle/oradata/orcl/example01.dbf-dbidchanged
Datafile/u01/app/oracle/oradata/orcl/temp01.dbf-dbidchanged
ControlFile/u01/app/oracle/oradata/orcl/control01.ctl-dbidchanged
ControlFile/u01/app/oracle/oradata/orcl/control02.ctl-dbidchanged
ControlFile/u01/app/oracle/oradata/orcl/control03.ctl-dbidchanged
Instanceshutdown
DatabaseIDfordatabaseORCLchangedto1252672326.
Allpreviousbackupsandarchivedredologsforthisdatabaseareunusable.
DatabaseisnotawareofpreviousbackupsandarchivedlogsinRecoveryArea.
Databasehasbeenshutdown,opendatabasewithRESETLOGSoption.
SuccesfullychangeddatabaseID.
DBNEWID-Completedsuccesfully.
本文轉自東方之子736651CTO部落格,原文連結: http://blog.51cto.com/ecloud/1323027,如需轉載請自行聯系原作者