Oracle資料庫日常管理之資料備份，恢複及遷移 （第八講 )

大家好，以下是我的oracle系列培訓課程的第八講觀看地址，本講主要介紹如何?跨平台遷移資料庫！

主要涉及內容有：

1：介紹和示範如何將windows作業系統上的資料庫遷移至linux伺服器上，並將資料檔案儲存由原來的NTFS檔案系統轉成儲存在ASM磁碟組上

2：介紹遷移完成後的系列收尾工作！

大家在觀看過程中有任何疑問或者建議，都可以在本文的評論區留言！

視頻地址：http://edu.51cto.com/lession/id-11376.html 相互學習，共同進步！

附上dbconsole重建過程：

[oracle@vm1 bak]$ emca -deconfig dbcontrol db -repos drop -silent -PORT 1521 -SID win2  -SYS_PWD  123456 -DBSNMP_PWD 123456 -SYSMAN_PWD 123456[oracle@vm1 bak]$ emca -config dbcontrol db -repos recreateSTARTED EMCA at Aug 14, 2013 10:26:07 PMEM Configuration Assistant, Version 11.2.0.3.0 ProductionCopyright (c) 2003, 2011, Oracle.  All rights reserved.Enter the following information:Database SID: win2Listener port number: 1521Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]: /u01/app/oracle/product/11.2.0/db_1Password for SYS user:Password for DBSNMP user:Password for SYSMAN user:Email address for notifications (optional):Outgoing Mail (SMTP) server for notifications (optional):ASM ORACLE_HOME [ /u01/app/11.2.0/grid ]: /u01/app/11.2.0/gridASM SID [ +ASM ]:ASM port [ 1521 ]:ASM username [ ASMSNMP ]:ASM user password:-----------------------------------------------------------------You have specified the following settingsDatabase ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db_1Local hostname ................ vm1Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db_1Listener port number ................ 1521Database SID ................ win2Email address for notifications ...............Outgoing Mail (SMTP) server for notifications ...............ASM ORACLE_HOME ................ /u01/app/11.2.0/gridASM SID ................ +ASMASM port ................ 1521ASM user role ................ SYSDBAASM username ................ ASMSNMP---------------------------------------------------------------------------------------------------------------------------------------WARNING : While repository is dropped the database will be put in quiesce mode.----------------------------------------------------------------------Do you wish to continue? [yes(Y)/no(N)]: yAug 14, 2013 10:27:30 PM oracle.sysman.emcp.EMConfig performINFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/win2/emca_2013_08_14_22_26_07.log.Aug 14, 2013 10:27:31 PM oracle.sysman.emcp.EMReposConfig invokeINFO: Dropping the EM repository (this may take a while) ...Aug 14, 2013 10:27:32 PM oracle.sysman.emcp.EMReposConfig invokeINFO: Repository successfully droppedAug 14, 2013 10:27:32 PM oracle.sysman.emcp.EMReposConfig createRepositoryINFO: Creating the EM repository (this may take a while) ...Aug 14, 2013 10:41:03 PM oracle.sysman.emcp.EMReposConfig invokeINFO: Repository successfully createdAug 14, 2013 10:41:24 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepositoryINFO: Uploading configuration data to EM repository (this may take a while) ...Aug 14, 2013 10:42:22 PM oracle.sysman.emcp.EMReposConfig invokeINFO: Uploaded configuration data successfullyAug 14, 2013 10:42:23 PM oracle.sysman.emcp.ParamsManager getLocalListenerWARNING: Error retrieving listener for vm1Aug 14, 2013 10:42:24 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsoleINFO: Securing Database Control (this may take a while) ...Aug 14, 2013 10:42:31 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsoleINFO: Database Control secured successfully.Aug 14, 2013 10:42:31 PM oracle.sysman.emcp.util.DBControlUtil startOMSINFO: Starting Database Control (this may take a while) ...Aug 14, 2013 10:43:50 PM oracle.sysman.emcp.EMDBPostConfig performConfigurationINFO: Database Control started successfullyAug 14, 2013 10:43:50 PM oracle.sysman.emcp.EMDBPostConfig performConfigurationINFO: >>>>>>>>>>> The Database Control URL is https://vm1:5500/em <<<<<<<<<<<Aug 14, 2013 10:43:52 PM oracle.sysman.emcp.EMDBPostConfig invokeWARNING:************************  WARNING  ************************Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file: /u01/app/oracle/product/11.2.0/db_1/vm1_win2/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost.***********************************************************Enterprise Manager configuration completed successfullyFINISHED EMCA at Aug 14, 2013 10:43:52 PM[oracle@vm1 bak]$ emctl status dbconsoleperl: warning: Setting locale failed.perl: warning: Please check that your locale settings:        LANGUAGE = (unset),        LC_ALL = (unset),        LANG = "en_us.UTF-8"    are supported and installed on your system.perl: warning: Falling back to the standard locale ("C").Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.https://vm1:5500/em/console/aboutApplicationOracle Enterprise Manager 11g is running.------------------------------------------------------------------Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/vm1_win2/sysman/log

650) this.width=650;" src="http://www.bkjia.com/uploads/allimg/131228/2200095528-0.jpg" title="QQ20130814225104.jpg" />

本文出自 “斬月” 部落格，謝絕轉載！