Oracle数据文件迁移知多少?
本人以前整理的数据库文件迁移过程,希望能够对大家有所帮助
1、sqlplus "sys/sys@服务名 as sysdba"
2、修改控制文件:
alter system set control_files='E:\oracle\oradata\myOracle_1\control01.ctl',
'E:\oracle\oradata\myOracle_1\control02.ctl','E:\oracle\oradata\myOracle_1\control03.ctl'
scope=spfile;
3、备份控制文件
alter database backup controlfile to 'E:\oracle\oradata\testdb.ctl' reuse;
4、备份到跟踪文件, 方便重建控制文件
alter database backup controlfile to trace;
6、查看存放路径
show parameter user_dump_dest
6、数据文件拷贝到对应的目录:
7、到对应的ORACLE的数据目录 user_dump_des,找到对应的最新的TRACE文件,拷贝对应的数据出来:
内容如下:
1、重做日志文件可用的情况
STARTUP NOMOUNT;
CREATE CONTROLFILE REUSE DATABASE "MYORACLE" NORESETLOGS NOARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 3
MAXLOGMEMBERS 3
MAXDATAFILES 20
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 'E:\ORACLE\ORADATA\MYORACLE_1\REDO01.LOG' SIZE 30M,
GROUP 2 'E:\ORACLE\ORADATA\MYORACLE_1\REDO02.LOG' SIZE 30M,
GROUP 3 'E:\ORACLE\ORADATA\MYORACLE_1\REDO03.LOG' SIZE 30M
-- STANDBY LOGFILE
DATAFILE
'E:\ORACLE\ORADATA\MYORACLE_1\SYSTEM01.DBF',
'E:\ORACLE\ORADATA\MYORACLE_1\UNDOTBS01.DBF',
'E:\ORACLE\ORADATA\MYORACLE_1\DRSYS01.DBF',
'E:\ORACLE\ORADATA\MYORACLE_1\INDX01.DBF',
'E:\ORACLE\ORADATA\MYORACLE_1\TOOLS01.DBF',
'E:\ORACLE\ORADATA\MYORACLE_1\USERS01.DBF',
'E:\ORACLE\ORADATA\MYORACLE_1\XDB01.DBF',
'E:\ORACLE\ORADATA\MYORACLE_1\PERFSTAT.ORA'
CHARACTER SET ZHS16GBK;
alter database rename file 'E:\ORACL
相关文档:
Fedora10 上的 Oracle 10.2.0.1 手工建库全过程
NOTE:
(1)记着要在oracle用户下而不是root下执行这些操作,否则因为权限的问题会带来无穷无尽的麻烦
(2)要检查过程中所有出现的目录名都是对应正确且有效的,否则几乎没有可用的错误信息来查找这种错误
(3)要 ......
Oracle and Sun
http://www.oracle.com/events/productstrategy/index.html
Oracle + Sun: Java Strategy
http://oracle.com.edgesuite.net/ivt/4000/8104/9236/12630/lobby_external_flash_clean_480x360/default.htm
Oracle + Sun: Java Strategy
......
Oracle Flashback Technology
Oracle Flashback Technology reduces recovery time from hours to minutes.
from: http://www.oracle.com/technology/deploy/availability/htdocs/Flashback_Overview.htm
According to many studies, 40% of application outages are caused by operator or user errors. Part of be ......
oracle补丁下载
关键字: oracle
9.2.0.4 = 3095277
9.2.0.5 = 3501955
9.2.0.6 = 3948480
9.2.0.7 = 4163445
9.2.0.8 = 4547809(9i最终)
10.1.0.3 = 3761843
10.1.0.4 = 4163362
10.1.0.5 = 4505133
10.2.0.2 = 4547817
10.2.0.3 = 5337014
10.2.0.4 = 6810189 ......
基本要求
win 7的版本是旗舰版,oracle 10g(Oracle10g第2版10.2.0.3-10.2.0.410203vistaw2k8x86productiondb)迅雷有下载
(搜索“oracle 10g vista”,760MB)
具体过程
1.配置一个虚拟的IP:在安装ORACLE 10g前系统会检测安装的一些前提条件是否满足,
往往会提示说:将Microsoft LoopBack Adapter配置为 ......