【NinGoo】Oracle10gR2 Logical Standby(四)轉換邏輯備庫的過程

關於Oracle10gR2邏輯備庫，之前寫過幾篇：
Oracle10gR2 Logical Standby(一)概念與原理
Oracle10gR2 Logical Standby(二)配置前需要考慮的問題
Oracle10gR2 Logical Standby(三)配置邏輯備庫

這裡記錄一下Oracle10gR2物理備庫轉換為邏輯備庫的過程中，Oracle都做了哪些操作。從alert中可以獲得很多有用的資訊：當執行alter database recover to logical standby xxxx的命令後，首先啟動基於SCN的不完全恢復(Oracle10g會自動開啟並行恢復，這個例子中啟動了15個並行恢復程式)。然後clear online redo logfile，但是Oracle10g在將備庫置於manged standby狀態的時候就提前將這個clear的動作做了，所以這裡記錄的是previously cleared，然後將備庫啟用，呼叫nid修改資料庫的DBID。

alter database recover to logical standby shtest
Thu Jun 5 14:02:55 2008
Media Recovery Start: Managed Standby Recovery (shtest)
Thu Jun 5 14:02:55 2008
Managed Standby Recovery not using Real Time Apply
parallel recovery started with 15 processes
Media Recovery Log /oradata/archive/shtest/1_2274_655399684.arc
Media Recovery Log /oradata/archive/shtest/1_2275_655399684.arc
Media Recovery Log /oradata/archive/shtest/1_2276_655399684.arc
Media Recovery Log /oradata/archive/shtest/1_2277_655399684.arc
Thu Jun 5 14:02:56 2008
Incomplete Recovery applied until change 20447678
Thu Jun 5 14:02:56 2008
Media Recovery Complete (shtest)
RESETLOGS after incomplete recovery UNTIL CHANGE 20447678
Resetting resetlogs activation ID 54725959 (0×3430d47)
Online log /oradata/shtest/redo01_01.dbf: Thread 1 Group 1 was previously cleared
Online log /oradata/shtest/redo01_02.dbf: Thread 1 Group 1 was previously cleared
Online log /oradata/shtest/redo02_01.dbf: Thread 1 Group 2 was previously cleared
Online log /oradata/shtest/redo02_02.dbf: Thread 1 Group 2 was previously cleared
Online log /oradata/shtest/redo03_01.dbf: Thread 1 Group 3 was previously cleared
Online log /oradata/shtest/redo03_02.dbf: Thread 1 Group 3 was previously cleared
Standby became primary SCN: 20447676
Thu Jun 5 14:03:01 2008
Setting recovery target incarnation to 2
Thu Jun 5 14:03:01 2008
Converting standby mount to primary mount.
Thu Jun 5 14:03:01 2008
ACTIVATE STANDBY: Complete - Database mounted as primary (shtest)
*** DBNEWID utility started ***
DBID will be changed from 54167428 to new DBID of 55371925 for database SHTEST
DBNAME will be changed from SHTEST to new DBNAME of SHTEST
Starting datafile conversion
Setting recovery target incarnation to 1
Datafile conversion complete
Database name changed to SHTEST.
Modify parameter file and generate a new password file before restarting.
Database ID for database SHTEST changed to 55371925.
All previous backups and archived redo logs for this database are unusable.
Database has been shutdown, open with RESETLOGS option.
Succesfully changed database name and ID.
*** DBNEWID utility finished succesfully ***
Thu Jun 5 14:03:03 2008
ARC1: Archival disabled due to instance shutdown
Shutting down archive processes
Archiving is disabled
Thu Jun 5 14:03:03 2008
Completed: alter database recover to logical standby shtest

http://www.ningoo.net/html/2008/oracle10gr2_convert_to_logical_standby_database.html

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