Description:
All control files are corrupted, power down, no archive, no backup successful recovery.
An example wants to give you help. Note: When creating a control file, use the red part of Reuse and NoreSetLogs, so you can automatically recover if you have a manual apply log.
Connected to:
Oracle8i
Enterprise
Edition Release
8.1.7
.0.0 - Production
WITH THE PartInog Option
JServer Release
8.1.7
.0.0 - Production
SQL> DROP TABLE RN;
The table has been discarded.
SQL> ALTER System Checkpoint;
The system has changed.
SQL> DROP TABLE TEST_GROUP;
The table has been discarded.
SQL> conn / as sysdba
connected.
SQL> Shutdown Abort
Oracle routines have been closed.
SQL> Startup Nomount
Oracle routines have been started.
Total System Global Area 31229980 BYtes
Fixed Size 75804 BYTES
Variable size 14299136 bytes
Database buffers 16777216 BYTES
Redo buffers 77824 bytes
SQL> Create ControlFile Set / Reuse Database "Billy" ResetLogs / NoreSetLogs NoarchiveLog
2 MaxLogfiles 64
3 MaxLogmembers 2
4 MaxDataFiles 254
5 MaxInstances 32
6 MaxLoghistory 113
7 logfile
8 Group 1 'E: /oracle/oradata/billy/redo01.log' size 1048576,
9 Group 2 'E: /oracle/oradata/billy/redo02.log' size 1048576,
10 Group 3 'E: /oracle/oradata/billy/redo03.log' size 1048576
11 DataFile
12 'E: /oracle/oradata/billy/system01.dbf',
13 'E: /oracle/oradata/billy/rbs01.dbf',
14 'E: /oracle/oradata/billy/users01.dbf',
15 'E: /oacle/oradata/billy/temp01.dbf',
16 'E: /oacle/oradata/billy/tools01.dbf',
17 'E: /oacle/oradata/billy/indx01.dbf',
18 'E: /oracle/oradata/billy/dr01.dbf',
19 'E: /oracle/oradata/billy/db4k.dbf'
20 Character Set ZHS16GBK
twenty one ;
Data clusters have been changed.
SQL> Shutdown
ORA-01109: ??????
The database has been uninstalled.
Oracle routines have been closed.
SQL> Startup Mount
Oracle routines have been started.
Total System Global Area 31229980 BYtes
Fixed Size 75804 BYTES
Variable size 14299136 bytes
Database buffers 16777216 BYTES
Redo buffers 77824 bytes
The database is loaded.
SQL> Recover Database Use Backup ControlFile Until Cancel;
ORA-00279: ?? 25526706 (?
03/20/2003
09:45:25 ??) ???? 1 ????
ORA-00289: ??: E: /oracle/ora81/rdbms/arc00001.001
ORA-00280: ?? 25526706 ???? 1 ????? # 1???
Specify log: {
'E: /oracle/oradata/billy/redo01.log'
ORA-00339: ???????????
ORA-00334: ????: 'E: /oracle/oradata/billy/redo01.log'
ORA-01547: ??: recover ??? Open resetLogs ???????
ORA-01194: ?? 1 ?????????????
ORA-01110: ???? 1: 'E: /oracle/oradata/billy/system01.dbf'
SQL> Recover Database Use Backup ControlFile Until Cancel;
ORA-00279: ?? 25526706 (?
03/20/2003
09:45:25 ??) ???? 1 ????
ORA-00289: ??: E: /oracle/ora81/rdbms/arc00001.001
ORA-00280: ?? 25526706 ???? 1 ????? # 1???
Specify log: {
'E: /oracle/oradata/billy/redo03.log'
Applicable logs.
Complete media recovery.
SQL> Recover Database Use Backup ControlFile Until Cancel;
ORA-00279: ?? 25526718 (?
03/20/2003
09:45:38 ??) ???? 1????
ORA-00289: ??: E: /oracle/ora81/rdbms/arc00001.001
ORA-00280: ?? 25526718 ???? 1 ????? # 1???
Specify log: {
'E: /oracle/oradata/billy/redo01.log'
ORA-00339: ???????????
ORA-00334: ????: 'E: /oracle/oradata/billy/redo01.log'
SQL> ALTER DATABASE OPEN RESETLOGS;
The database has been changed.
SQL>
At the last step, pay attention to the correct log file, there is no relationship between a test.
Or ask:
Create ControlFile Set Database "Billy" ResetLogs NoarchiveLog ??
Shouldn't RESETLOGS? Redo log file is not all the data before Shut Abort?
answer:
If Reuse creates a control file, you can use RESETLOGS. Even with the SET creation control file can be fully recovered.
look down:
SQL> CONN RAINY / RAINY
connected.
SQL> TRUNCATE TABLE TABLE
The table has been cut off.
SQL> ALTER System Checkpoint;
The system has changed.
SQL> INSERT INTO TRANS VALUES (1);
It has created a row.
SQL> commit;
Submitted.
SQL> conn / as sysdba
connected.
SQL> Shutdown Abort
Oracle routines have been closed.
SQL> Startup Nomount
Oracle routines have been started.
Total System Global Area 31229980 BYtes
Fixed Size 75804 BYTES
Variable size 14299136 bytes
Database buffers 16777216 BYTES
Redo buffers 77824 bytes
SQL> Create ControlFile Set Database "Billy" NoreSetLogs NoarchiveLog
2 MaxLogfiles 64
3 MaxLogmembers 2
4 MaxDataFiles 254
5 MaxInstances 32
6 MaxLoghistory 113
7 logfile
8 Group 1 'E: /oracle/oradata/billy/redo01.log' size 1048576,
9 Group 2 'E: /oracle/oradata/billy/redo02.log' size 1048576,
10 Group 3 'E: /oracle/oradata/billy/redo03.log' size 1048576
11 DataFile
12 'E: /oracle/oradata/billy/system01.dbf',
13 'E: /oracle/oradata/billy/rbs01.dbf',
14 'E: /oracle/oradata/billy/users01.dbf',
15 'E: /oacle/oradata/billy/temp01.dbf',
16 'E: /oacle/oradata/billy/tools01.dbf',
17 'E: /oacle/oradata/billy/indx01.dbf',
18 'E: /oracle/oradata/billy/dr01.dbf',
19 'E: /oracle/oradata/billy/db4k.dbf'
20 Character Set ZHS16GBK
twenty one ;
Create ControlFile Set Database "Billy" NoreSetlogs NoarchiveLog
*
Error is located on the first line:
ORA-01503: CREATE controlFile ??
ORA-01223: ???? resetlogs ?????????
SQL> Create ControlFile Set Database "Billy" ResetLogs NoarchiveLog
2 MaxLogfiles 64
3 MaxLogmembers 2
4 MaxDataFiles 254
5 MaxInstances 32
6 MaxLoghistory 113
7 logfile
8 Group 1 'E: /oracle/oradata/billy/redo01.log' Size 1048576, 9 Group 2 'E: /oracle/oradata/billy/redo02.log' size 1048576,
10 Group 3 'E: /oracle/oradata/billy/redo03.log' size 1048576
11 DataFile
12 'E: /oracle/oradata/billy/system01.dbf',
13 'E: /oracle/oradata/billy/rbs01.dbf',
14 'E: /oracle/oradata/billy/users01.dbf',
15 'E: /oacle/oradata/billy/temp01.dbf',
16 'E: /oacle/oradata/billy/tools01.dbf',
17 'E: /oacle/oradata/billy/indx01.dbf',
18 'E: /oracle/oradata/billy/dr01.dbf',
19 'E: /oracle/oradata/billy/db4k.dbf'
20 Character Set ZHS16GBK
twenty one ;
Data clusters have been changed.
SQL>
SQL> Shutdown
ORA-01109: ??????
The database has been uninstalled.
Oracle routines have been closed.
SQL> Startup Mount
Oracle routines have been started.
Total System Global Area 31229980 BYtes
Fixed Size 75804 BYTES
Variable size 14299136 bytes
Database buffers 16777216 BYTES
Redo buffers 77824 bytes
The database is loaded.
SQL> Recover Database Use Backup ControlFile Until Cancel;
ORA-00279: ?? 25546853 (?
03/20/2003
11:51:40 ??) ???? 1????
ORA-00289: ??: E: /oracle/ora81/rdbms/arc00002.001
ORA-00280: ?? 25546853 ???? 1 ????? # 2???
Specify log: {
'E: /oracle/oradata/billy/redo03.log'
ORA-00310: ???????? 1 ????? 2
ORA-00334: ????: 'E: /oracle/oradata/billy/redo03.log'
ORA-01547: ??: recover ??? Open resetLogs ???????
ORA-01194: ?? 1 ?????????????
ORA-01110: ???? 1: 'E: /oracle/oradata/billy/system01.dbf'
SQL> Recover Database Use Backup ControlFile Until Cancel;
ORA-00279: ?? 25546853 (?
03/20/2003
11:51:40 ??) ???? 1????
ORA-00289: ??: E: /oracle/ora81/rdbms/arc00002.001
ORA-00280: ?? 25546853 ???? 1 ????? # 2???
Specify log: {
Applicable logs.
Complete media recovery.
SQL> ALTER DATABASE OPEN RESETLOGS;
The database has been changed.
SQL> CONN RAINY / RAINY
connected.
SQL> SELECT *.
A
------------
1
SQL>
