oracle报请发送文件,启动oracle时提示ora-00227,说控制文件有损怀,那位知道如何创建控制文件,在线等待,...

给你个格式吧,你按照这个格式去修改吧

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE "ORCL9" NORESETLOGS  NOARCHIVELOG

--  SET STANDBY TO MAXIMIZE PERFORMANCE

MAXLOGFILES 5

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 1

MAXLOGHISTORY 907

LOGFILE

GROUP 1 'D:\ORACLE9I\ORA92\ORADATA\ORCL9\REDO01.LOG'  SIZE 1M,

GROUP 2 'D:\ORACLE9I\ORA92\ORADATA\ORCL9\REDO02.LOG'  SIZE 1M,

GROUP 3 'D:\ORACLE9I\ORA92\ORADATA\ORCL9\REDO03.LOG'  SIZE 1M

-- STANDBY LOGFILE

DATAFILE

'D:\ORACLE9I\ORA92\ORADATA\ORCL9\SYSTEM01.DBF',

'D:\ORACLE9I\ORA92\ORADATA\ORCL9\UNDOTBS01.DBF'

CHARACTER SET ZHS16GBK

;

# Recovery is required if any of the datafiles are restored backups,

# or if the last shutdown was not normal or immediate.

RECOVER DATABASE

# Database can now be opened normally.

ALTER DATABASE OPEN;

# Commands to add tempfiles to temporary tablespaces.

# Online tempfiles have complete space information.

# Other tempfiles may require adjustment.

ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\ORACLE9I\ORA92\ORADATA\ORCL9\TEMP01.DBF'

SIZE 52428800  REUSE AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M;

# End of tempfile additions.

#

#     Set #2. RESETLOGS case

#

# The following commands will create a new control file and use it

# to open the database.

# The contents of online logs will be lost and all backups will

# be invalidated. Use this only if online logs are damaged.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值