Oracle create control file again loss data file cause tragedy

Database initial failure
Thu Sep 25 09:27:26 2014
Mmon started with pid=15, OS id=1968
Starting up 1 Dispatcher (s) to network address ' (Address= (Partial=yes) (protocol=tcp)) ' ...
Starting up 1 Shared server (s) ...
Oracle_base from environment = F:\oracle
Thu Sep 25 09:27:26 2014
ALTER DATABASE MOUNT
Thu Sep 25 09:27:26 2014
MMNL started with pid=16, OS id=5976
Errors in file f:\oracle\diag\rdbms\orcl\orcl\trace\orcl_ora_4624.trc:
ORA-00202:????: ' F:\ORACLE\ORADATA\ORCL\CONTROL01.CTL
ORA-27070:???? /????
Osd-04006:readfile () failed, unable to read file
O/s-error: (OS 23) Data error (cyclic redundancy check).
Thu Sep 25 09:28:31 2014
ORA-204 signalled During:alter DATABASE MOUNT ...
The control file cannot be accessed properly because of hardware or system level issues

create control file again
Fri Sep 26 12:28:44 2014
Successful mount of Redo thread 1 with Mount ID 1387065723
Completed:create controlfile Reuse DATABASE "ORCL" Resetlogs Archivelog
Maxlogfiles 5
Maxlogmembers 3
Maxdatafiles 100
Maxinstances 2
Maxloghistory 226
LOGFILE
GROUP 1 ' F:\oracle\oradata\orcl\REDO01.LOG ' SIZE 50M,--redo LOG????
GROUP 2 ' F:\oracle\oradata\orcl\REDO02.LOG ' SIZE 50M,--redo LOG????
GROUP 3 ' F:\oracle\oradata\orcl\REDO03.LOG ' SIZE 50M--redo LOG????
--STANDBY LOGFILE
DataFile
' F:\oracle\oradata\orcl\SYSAUX01.DBF ',--sysaux???????
' F:\oracle\oradata\orcl\SYSTEM01.DBF ',
' F:\oracle\oradata\orcl\USERS01.DBF ',--user????????
' F:\oracle\oradata\orcl\UNDOTBS01.DBF '--undo???????
CHARACTER SET ZHS16GBK
Fri Sep 26 12:29:55 2014
ALTER DATABASE open Resetlogs
ORA-1194 signalled during:alter database open resetlogs ...
To bury the Thunder, create control file not all listed all data files

Try Resetlogs Library to discover redo exception for incomplete recovery
Fri Sep 26 14:13:24 2014
ALTER DATABASE MOUNT
Fri Sep 26 14:13:24 2014
MMNL started with pid=16, OS id=9024
Successful mount of Redo thread 1 with Mount ID 1387037444
Database mounted in Exclusive Mode
Lost Write protection disabled
Completed:alter DATABASE MOUNT
Fri Sep 26 14:14:08 2014
ALTER DATABASE open Resetlogs
Resetlogs is being done without consistancy checks. This could result
In a corrupted database. The database should be recreated.
Fri Sep 26 14:15:16 2014
Errors in file f:\oracle\diag\rdbms\orcl\orcl\trace\orcl_ora_3720.trc:
ORA-00333: Redo Log Read Block 2049 count 6143 error
ORA-00312: Online log 1 thread 1: ' F:\ORACLE\ORADATA\ORCL\REDO01.LOG '
ORA-27070: Asynchronous read/write failure
OSD-04016: An error occurred while waiting for an asynchronous I/O request.
O/s-error: (OS 23) Data error (cyclic redundancy check).
Fri Sep 26 14:16:24 2014
Errors in file f:\oracle\diag\rdbms\orcl\orcl\trace\orcl_ora_3720.trc:
ORA-00333: Redo Log Read Block 1 count 8191 error
ORA-00312: Online log 1 thread 1: ' F:\ORACLE\ORADATA\ORCL\REDO01.LOG '
ORA-27070: Asynchronous read/write failure
Osd-04006:readfile () failed, unable to read file
O/s-error: (OS 23) Data error (cyclic redundancy check).
Errors in file f:\oracle\diag\rdbms\orcl\orcl\trace\orcl_ora_3720.trc:
ORA-00333: Redo Log Read Block 1 count 8191 error
Arch:all Archive Destinations made inactive due to error 333
Try Raghu with hidden parameters, report ora-600[2662]
Fri Sep 26 14:16:45 2014
Smon:enabling Cache Recovery
Errors in File F:\oracle\diag\rdbms\orcl\orcl\trace\orcl_ora_3720.trc (incident=57761):
ORA-00600: Internal error code, parameters: [2662], [0], [38221304], [0], [38352371], [4194545], [], [], [], [], [], []
Incident Details IN:F:\ORACLE\DIAG\RDBMS\ORCL\ORCL\INCIDENT\INCDIR_57761\ORCL_ORA_3720_I57761.TRC
Fri Sep 26 14:16:45 2014
ARC3 started with pid=23, OS id=9692
Arc3:archival started
Arc0:starting ARCH Processes COMPLETE
Errors in file f:\oracle\diag\rdbms\orcl\orcl\trace\orcl_ora_3720.trc:
ORA-00704: Bootstrapper process failed
ORA-00704: Bootstrapper process failed
ORA-00600: Internal error code, parameters: [2662], [0], [38221304], [0], [38352371], [4194545], [], [], [], [], [], []
Errors in file f:\oracle\diag\rdbms\orcl\orcl\trace\orcl_ora_3720.trc:
ORA-00704: Bootstrapper process failed
ORA-00704: Bootstrapper process failed
ORA-00600: Internal error code, parameters: [2662], [0], [38221304], [0], [38352371], [4194545], [], [], [], [], [], []
Error 704 happened during DB Open, shutting down database
USER (ospid:3720): Terminating the instance due to error 704
Instance terminated by USER, PID = 3720
ORA-1092 signalled during:alter database open resetlogs ...
OPIODR aborting process unknown ospid (3720) as a result of ORA-1092
Database in the absence of all data files, the resetlogs operation, the nature of the tragedy has been doomed, my mistake is not to assess the good status quo, but also continue on the wrong road farther and further away.

I started taking over the library.
Database mounted in Exclusive Mode
Lost Write protection disabled
Completed:alter DATABASE MOUNT
Fri Sep 26 14:18:55 2014
ALTER DATABASE Open
Errors in file f:\oracle\diag\rdbms\orcl\orcl\trace\orcl_ora_8968.trc:
ORA-01113: File 1 Requires media recovery
ORA-01110: Data file 1: ' F:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF '
ORA-1113 signalled during:alter database open ...
Fri Sep 26 14:19:31 2014
ALTER DATABASE Open
Errors in file f:\oracle\diag\rdbms\orcl\orcl\trace\orcl_ora_8968.trc:
ORA-01113: File 1 Requires media recovery
ORA-01110: Data file 1: ' F:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF '
ORA-1113 signalled during:alter database open ...
Fri Sep 26 14:22:26 2014
ALTER Database RECOVER Database
Media Recovery Start
Started Logmerger process
Fri Sep 26 14:22:26 2014
Media Recovery failed with error 16433
Recovery Slave PR00 previously exited with exception 283
ORA-283 signalled during:alter database RECOVER database ...
Fri Sep 26 14:24:25 2014
ALTER DATABASE RECOVER datafile ' F:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF '
Media Recovery Start
Media Recovery failed with error 16433
ORA-283 signalled during:alter DATABASE RECOVER datafile ' F:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF ' ...
Fri Sep 26 14:28:47 2014
ALTER DATABASE Open Read Write
Errors in file f:\oracle\diag\rdbms\orcl\orcl\trace\orcl_ora_8968.trc:
ORA-01113: File 1 Requires media recovery
ORA-01110: Data file 1: ' F:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF '
ORA-1113 signalled during:alter database open Read write ...
Fri Sep 26 14:31:48 2014
ALTER DATABASE RECOVER datafile ' F:\oracle\oradata\orcl\SYSTEM01.DBF '
Media Recovery Start
Media Recovery failed with error 16433
ORA-283 signalled during:alter DATABASE RECOVER datafile ' F:\oracle\oradata\orcl\SYSTEM01.DBF ' ...
Hint ORA-01110: Data file 1 requires recovery, try recover action

Try recover action
Connect to:
Oracle Database 11g Enterprise Edition release 11.2.0.1.0-production
With the partitioning, OLAP, Data Mining and real application testing options

sql> Recover database;
Ora-00283:recovery session canceled due to errors
Ora-16433:the database must is opened in Read/write mode.


sql> ALTER DATABASE backup Controlfile to trace as ' d:\ctl.txt ';
ALTER DATABASE backup Controlfile to trace as ' d:\ctl.txt '
*
Line 1th Error:
ORA-16433: The database must be opened in read/write mode.


sql> Recover database using Backup controlfile;
Ora-00283:recovery session canceled due to errors
Ora-16433:the database must is opened in Read/write mode.
create control file again
sql> shutdown immediate;
ORA-01109: Database not open


The database has been unloaded.
The ORACLE routine has been closed.
Sql> STARTUP Nomount
The ORACLE routine has started.

Total System Global area 970895360 bytes
Fixed Size 1375452 bytes
Variable Size 603980580 bytes
Database buffers 360710144 bytes
Redo buffers 4829184 bytes
Sql> CREATE controlfile Reuse DATABASE orcl noresetlogs FORCE LOGGING archivelog

2 Maxlogfiles 16
3 Maxlogmembers 3
4 Maxdatafiles 100
5 Maxinstances 8
6 Maxloghistory 2921
7 LOGFILE
8 GROUP 1 ' F:\ORACLE\ORADATA\ORCL\REDO01.LOG ' SIZE 50M,
9 GROUP 2 ' F:\ORACLE\ORADATA\ORCL\REDO02.LOG ' SIZE 50M,
GROUP 3 ' F:\ORACLE\ORADATA\ORCL\REDO03.LOG ' SIZE 50M
One datafile
' F:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF ',
' F:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF ',
' F:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF ',
' F:\ORACLE\ORADATA\ORCL\USERS01.DBF '
CHARACTER SET ZHS16GBK
17;

The control file was created.
This step seriously wrong, before the recovery did not seriously look at the alert log, too dependent on v$datafile query results, resulting in the reconstruction of control files lost data files, buried Big Thunder. Based on the previous alert log error ORA-600 2662, decide to handle the problem together and recover
sql> shutdown immediate;
ORA-01109:??????


The database has been unloaded.
The ORACLE routine has been closed.
sql> startup pfile= ' D:\pfile.txt ' mount;
The ORACLE routine has started.

Total System Global area 970895360 bytes
Fixed Size 1375452 bytes
Variable Size 603980580 bytes
Database buffers 360710144 bytes
Redo buffers 4829184 bytes
Database loading complete.
sql> Recover database;
Complete media recovery.
sql> ALTER DATABASE open;
ALTER DATABASE Open
*
Line 1th Error:
Ora-00603:oracle server session terminated by fatal error
Ora-00600:internal error code, arguments: [4194], [], [
Database report ORA-600 4194, modify undo_management=manual directly, and then try to start the database
Sql> Conn/as SYSDBA
You are connected to an idle routine.
sql> startup pfile= ' D:\pfile.txt '
The ORACLE routine has started.

Total System Global area 970895360 bytes
Fixed Size 1375452 bytes
Variable Size 603980580 bytes
Database buffers 360710144 bytes
Redo buffers 4829184 bytes
Database loading complete.
The database is already open.
Sql> select name from V$datafile;

NAME
--------------------------------------------------------------------------------

F:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
F:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF
F:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF
F:\ORACLE\ORADATA\ORCL\USERS01.DBF
F:\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\MISSING00005
F:\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\MISSING00006

6 rows have been selected.

sql> ALTER DATABASE rename file ' F:\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\MISSING00005 '
2 to ' F:\oracle\oradata\SOURCE_DATA1. DBF ';

The database has changed.

sql> ALTER DATABASE rename file ' F:\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\MISSING00006 '
2 to ' F:\oracle\oradata\SOURCE_idx1. DBF ';

The database has changed.

sql> shutdown immediate;
The database has been closed.
The database has been unloaded.
The ORACLE routine has been closed.
sql> startup Mount Pfile= ' D:\pfile.txt '
The ORACLE routine has started.

Total System Global area 970895360 bytes
Fixed Size 1375452 bytes
Variable Size 603980580 bytes
Database buffers 360710144 bytes
Redo buffers 4829184 bytes
Database loading complete.
Sql> alter datafile 5 online;
Alter DataFile 5 Online
*
Line 1th Error:
ORA-00940: Invalid ALTER command


sql> ALTER DATABASE datafile 5 online;

The database has changed.

Sql> ALTER DATABASE datafile 6 online;

The database has changed.

sql> recover database until cancel;
Ora-00283:recovery session canceled due to errors
Ora-19909:datafile 5 belongs to a orphan incarnation
Ora-01110:data file 5: ' F:\ORACLE\ORADATA\SOURCE_DATA1. DBF '


sql> ALTER DATABASE open resetlogs;
ALTER DATABASE open Resetlogs
*
Line 1th Error:
The ora-01139:resetlogs option is only valid after incomplete database recovery


Sql> ALTER DATABASE datafile 6 offline;

The database has changed.

sql> ALTER DATABASE datafile 5 offline;

The database has changed.

sql> recover database until cancel;
Complete media recovery.
Sql> ALTER DATABASE datafile 6 online;

The database has changed.

sql> ALTER DATABASE datafile 5 online;

The database has changed.

sql> ALTER DATABASE open resetlogs;

The database has changed.
Fortunately, the combination of some implied parameters to recover successfully, almost to the extent of the use of bbed

This recovery tells me: Oracle database recovery is more than the general idea, need to carefully analyze alert logs and consulting customers do those operations, otherwise it may lead to the forbidden territory

Contact: Mobile Phone (13429648788) QQ (107644445)
Link:http://www.xifenfei.com/5515.html