数据库|mysql教程
跨平台,oracle,数据库迁移,视频课程
数据库-mysql教程
时时彩平台源码大全,vscode 一键编译,ubuntu 新系统,tomcat如何查询日志,封装python爬虫,php 微商城 开源,seo培训免费课程网销,旅游网站aspnet下载,全屏滚动模板lzw
大家好,以下是我的oracle系列培训课程的第八讲观看地址,本讲主要介绍如何实现跨平台迁移数据库!主要涉及内容有:1:介绍和演示如何将windows操作系统上的数据
安卓 题库 源码,双系统ubuntu空间,tomcat部署项目如何访问,吸血草爬虫,mac上开发php推荐,青羊区seolzw
jquery源码正则表达式,ubuntu 启动无反应,jee配置tomcat7,爬虫程序手机,歌词查询php接口源码,seo池子lzw
大家好,以下是我的oracle系列培训课程的第八讲观看地址,本讲主要介绍如何实现跨平台迁移数据库!
主要涉及内容有:
1:介绍和演示如何将windows操作系统上的数据库迁移至linux服务器上,并将数据文件存储由原来的NTFS文件系统转成存储在ASM磁盘组上
2:介绍迁移完成后的系列收尾工作!
大家在观看过程中有任何疑问或者建议,都可以在本文的评论区留言!
视频地址: 相互学习,服务器空间,共同进步!
附上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 recreate
STARTED EMCA at Aug 14, 10:26:07 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) , , Oracle. All rights reserved.
Enter the following information:
Database SID: win2
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]: /u01/app/oracle/product/11.2.0/db_1
Password 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/grid
ASM SID [ +ASM ]:
ASM port [ 1521 ]:
ASM username [ ASMSNMP ]:
ASM user password:
—————————————————————–
You have specified the following settings
Database ORACLE_HOME ……………. /u01/app/oracle/product/11.2.0/db_1
Local hostname ……………. vm1
Listener ORACLE_HOME ……………. /u01/app/oracle/product/11.2.0/db_1
Listener port number ……………. 1521
Database SID ……………. win2
Email address for notifications ……………
Outgoing Mail (SMTP) server for notifications ……………
ASM ORACLE_HOME ……………. /u01/app/11.2.0/grid
ASM SID ……………. +ASM
ASM port ……………. 1521
ASM user role ……………. SYSDBA
ASM username ……………. ASMSNMP
—————————————————————–
———————————————————————-
WARNING : While repository is dropped the database will be put in quiesce mode.
———————————————————————-
Do you wish to continue? [yes(Y)/no(N)]: y
Aug 14, 10:27:30 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/win2/emca__08_14_22_26_07.log.
Aug 14, 10:27:31 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) …
Aug 14, 10:27:32 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Aug 14, 10:27:32 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) …
Aug 14, 10:41:03 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Aug 14, 10:41:24 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) …
Aug 14, 10:42:22 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Aug 14, 10:42:23 PM oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener for vm1
Aug 14, 10:42:24 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) …
Aug 14, 10:42:31 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Aug 14, 10:42:31 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) …
Aug 14, 10:43:50 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Aug 14, 10:43:50 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://vm1:5500/em <<<<<<<<<<<Aug 14, 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, 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, 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
本文出自 “斩月” 博客,谢绝转载!
,香港虚拟主机,香港服务器
如果觉得《Oracle数据库日常管理之数据备份 恢复及迁移 (第八讲 )》对你有帮助,请点赞、收藏,并留下你的观点哦!