Routine Management of Oracle databases-data backup, recovery and Migration (Lecture 8)

Hello, the following is the eighth lecture address of my oracle series training courses. This lecture mainly describes how to migrate databases across platforms!

The main content involved is:

1: describes and demonstrates how to migrate a database on a windows operating system to a linux server, and convert the data file storage from the original NTFS file system to the storage on the ASM disk.

2: Describes the final work of the series after the migration is completed!

If you have any questions or suggestions during viewing, you can leave a message in the comment area of this article!

Video address: http://edu.51cto.com/lession/id-11376.html mutual learning, progress together!

Attach the dbconsole reconstruction process:

[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 "/>

This article is from the "Bo Yue" blog and will not be reproduced!