startup migrate、startup upgrade區別以及Oracle打補丁集文件(轉)

startup migrate

=> Used to upgrade a database till 9i.

See the step 11 from the 9.2 manual upgrade guide :

=> Used to downgrade a database till 9i.

See the step 5 from the 9.2 downgrade guide :

=> Used to downgrade a database since 10g.

See the step 18 from the 10.2 downgrade guide :

startup upgrade

=> Used to upgrade a database since 10g.

See the step 7 from the 10.2 manual upgrade guide :

startup migrate、startup upgrade 區別

you can downgrade db using startup migrate since 10g.

you can upgrade db using startup upgrade since 10g.

you can upgrade/downgrade db using startup migrate till 9i.

在9i，無論升級/降級 資料庫都是startup migrate

10g後增加了upgrade引數，升級可直接用startup upgrade，降級仍是startup migrate.

--打完patch(OUI升級，中間需要用root執行一個指令碼)後，重建資料字典檢視指令碼catpatch.sql

為了保證系統的的資料詞典的完整性和有效性，最好的打patch後在migrate狀態下執行catpatch.sql

sql> shutdown immediate

sql> startup migrate (10g為startup upgrade)

sql> @?/rdbms/admin/catpatch.sql （10g為@?/rdbms/admin/catupgrd.sql )

sql> shutdown immediate

sql> startup

為加快速度，可臨時調大這２個引數：

show parameter shared_pool_size

show parameter large_pool_size

重建完資料字典檢視後的提示

DOC>#######################################################################

DOC>#######################################################################

DOC>

DOC>   The above PL/SQL lists the SERVER components in the upgraded

DOC>   database, along with their current version and status.

DOC>

DOC>   Please review the status and version columns and look for

DOC>   any errors in the spool log file. If there are errors in the spool

DOC>   file, or any components are not VALID or not the current version,

DOC>   consult the Oracle Database Upgrade Guide for troubleshooting

DOC>   recommendations.

DOC>

DOC>   Next shutdown immediate, restart for normal operation, and then

DOC>   run utlrp.sql to recompile any invalid application objects.

DOC>

DOC>#######################################################################

DOC>#######################################################################

--執行完catpatch.sql，沒有錯誤後，重啟資料庫，再編譯無效物件，指令碼utlrp.sql

$ sqlplus '/as sysdba' @?/rdbms/admin/utlrp.sql

utlrp.sql指令碼可以在資料庫執行的狀態下執行以編譯、資料庫中的invalid物件.

oracle建議在對資料庫進行遷移、升級、降級後都執行一遍utlrp.sql以編譯無效物件。