Prerequisites: Backup before file loss, including ControlFile backup ********************************************* *************************************************** SQL> Archive log list; Database log mode Archive ModeAutomatic archival DisabledArchive destination F: / oracle / ora92 / RDBMSOldest online log sequence 0Next log sequence to archive 1Current log sequence 1SQL> shutdown immediateORA-01109: database not open to delete all three control files and data files backup.dbf, analog damage At this time, STARTUP will definitely report the error correct; at this time, the backup of the controlfile and backup.dbf file restorestartup mount; success; alter database open; error, saying the control file is too old, the shutdown immediate; Startup Nomount ; SQL> ALTER DATABASE Backup ControlFile to TRACE;
Database altered. (A current backup of the database structure) to the next udump oracas_ora_3096.trc directory to find the file, the contents of which can be edited, re-write the file to generate control the pace CREATE CONTROLFILE REUSE DATABASE "ORACAS" NORESETLOGS ARCHIVELOG MAXLOGFILES 50 MAXLOGMEMBERS 5 MAXDATAFILES 100 MaxInstances 1 MaxLoghistory 113logfile Group 1 'f: /oracle/oradata/racas/redo01.log' size 100m, Group 2 'f: /oracle/oradata/oracas/redo02.log' size 100m, Group 3 'f: / Oracle / ORADATA/ORACAS/redo03.log 'size 100mdatafile' f: /oracle/oradata/oracas/system01.dbf ',' f: /oracle/oradata/oracas/undotbs01.dbf ',' f: / Oracle / ORADATA / ORACAS /Drsys01.dbf ',' f: /oracle/oradata/racas/example01.dbf ',' f: /oracle/oradata/racas/indx01.dbf ',' f: /oracle/oradata/oracas/odm01.dbf ' , 'F: /oracle/oradata/oracas/tools01.dbf', 'f: /oacle/oradata/racas/Users01.dbf', 'f: /oracle/oradata/oracas/xdb01.dbf', 'f: / Oracle / ORADATA / ORACAS / OEM_REPOSTORY.DBF ',' F: /oracle/oradata/racas/backup.dbf'character set zhs16gbk; control file created. Start database SQL> ALTABASE OPEN 2; Alter Database Open 2; ALTER DATABASE OPEN * Error At line 1: ORA-01113: File 11 Needs Media Recoveryora-01110: Data file 11: f: /oracle/oradata/racas/backup.dbf'SQL> Recover Database; Media Recovery Complete.SQL> ALTER DATABASE OPEN Database altered.
SQL> SELECT * from Backup;
