STARTUP NOMOUNT
CREATE CONTROLFILE set DATABASE "sid" NORESETLOGS NOARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 'D:\ORACLE\ORADATA\DMSVR\REDO01.LOG' SIZE 100M,
GROUP 2 'D:\ORACLE\ORADATA\DMSVR\REDO02.LOG' SIZE 100M,
GROUP 3 'D:\ORACLE\ORADATA\DMSVR\REDO03.LOG' SIZE 100M
-- STANDBY LOGFILE
DATAFILE
'D:\ORACLE\ORADATA\DMSVR\SYSTEM01.DBF',
'D:\ORACLE\ORADATA\DMSVR\UNDOTBS01.DBF',
'D:\ORACLE\ORADATA\DMSVR\CWMLITE01.DBF',
'D:\ORACLE\ORADATA\DMSVR\DRSYS01.DBF',
'D:\ORACLE\ORADATA\DMSVR\EXAMPLE01.DBF',
'D:\ORACLE\ORADATA\DMSVR\INDX01.DBF',
'D:\ORACLE\ORADATA\DMSVR\ODM01.DBF',
'D:\ORACLE\ORADATA\DMSVR\TOOLS01.DBF',
'D:\ORACLE\ORADATA\DMSVR\USERS01.DBF',
'D:\ORACLE\ORADATA\DMSVR\XDB01.DBF'
CHARACTER SET AL32UTF8
;ALTER DATABASE OPEN;ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\ORACLE\ORADATA\DMSVR\TEMP01.DBF'
SIZE 41943040 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;
CREATE CONTROLFILE set DATABASE "sid" NORESETLOGS NOARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 'D:\ORACLE\ORADATA\DMSVR\REDO01.LOG' SIZE 100M,
GROUP 2 'D:\ORACLE\ORADATA\DMSVR\REDO02.LOG' SIZE 100M,
GROUP 3 'D:\ORACLE\ORADATA\DMSVR\REDO03.LOG' SIZE 100M
-- STANDBY LOGFILE
DATAFILE
'D:\ORACLE\ORADATA\DMSVR\SYSTEM01.DBF',
'D:\ORACLE\ORADATA\DMSVR\UNDOTBS01.DBF',
'D:\ORACLE\ORADATA\DMSVR\CWMLITE01.DBF',
'D:\ORACLE\ORADATA\DMSVR\DRSYS01.DBF',
'D:\ORACLE\ORADATA\DMSVR\EXAMPLE01.DBF',
'D:\ORACLE\ORADATA\DMSVR\INDX01.DBF',
'D:\ORACLE\ORADATA\DMSVR\ODM01.DBF',
'D:\ORACLE\ORADATA\DMSVR\TOOLS01.DBF',
'D:\ORACLE\ORADATA\DMSVR\USERS01.DBF',
'D:\ORACLE\ORADATA\DMSVR\XDB01.DBF'
CHARACTER SET AL32UTF8
;ALTER DATABASE OPEN;ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\ORACLE\ORADATA\DMSVR\TEMP01.DBF'
SIZE 41943040 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;
解决方案 »
- redhat linux 6.3 下安装oracle10G
- delete 与 delete from 有区别吗
- 救急:ORA-12560:TNS:协议适配器错误
- 关于使用oracle817的exp命令
- SQL Plus 如何执行 begin end 之中的语句
- GoldenGate的Data Pump进程问题
- ORA-16009: remote archive log destination must be a STANDBY database
- 有无办法实现批量压缩照片字段的大小?
- ******这条SQL为什么不能执行,解决立即给分*****
- 程序包问题
- 重做日志(Redolog)被删掉,通过什么方法才能恢复!
- 提取表的结构
因为我在win2000下,打开控制文件是乱码,我想可能是加密的?
是不是除了修改控制文件,还要修改 init.ora??
alter database backup controlfile to trace;
生成创建控制文件和恢复数据库的脚本
然后修改其中数据到新的位置,把文件保存为sql文件
在新的数据库中启动到nomount下
运行该文件
init.ora文件中对控制文件的路径也需要修改
alter database backup controlfile to trace;
生成创建控制文件和恢复数据库的脚本
--------------------------------------------------执行成功,在什么地方找到这些脚本文件?