next time remember to backup your control file If you plan to take a control file backup using the ALTER DATABASE statement with the BACKUP CONTROLFILE TO 'filename' option, save a list of all datafiles and online redo log files with the control file backup.
删除数据文件后,链接报错,重新启动,报\oradata\dbfile1.ora不存在。哎呀,郁闷啊不知到怎么才能恢复正常
1:直接alter database create datafile,然后
alter database recover datafile就可以。
2:麻烦一些,需要关闭数据库,然后恢复自动备份的控制文件,
sql>alter database mount;
sql>alter database backup controlfile to trace;
sql>shutdown abort;
sql>startup nomount;
sql>运行trace 中的第一种noresetlogs方式的脚本“
呵呵
搞定了,没来得及上来回话