Hi all.
This is a 11g Rel2 DB.
I have performed a recovery from autobackup after loss of all controlfiles.
The process completed successfully, but now the database crashes.
This messages are on alert log:
WARNING! Recovering data file 1 from a fuzzy file
Setting recovery target incarnation to 20
2015-11-24 12:43:21.692000 -04:30
Assigning activation ID 1787223092 (0x6a86dc34)
2015-11-24 12:43:23.504000 -04:30
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=23, OS id=4440
2015-11-24 12:43:24.520000 -04:30
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
ARC1 started with pid=24, OS id=2460
ARC2 started with pid=25, OS id=4596
ARC1: Archival started
ARC3 started with pid=26, OS id=4044
ARC2: Archival started
ARC2: Becoming the 'no FAL' ARCH
ARC2: Becoming the 'no SRL' ARCH
ARC1: Becoming the heartbeat ARCH
2015-11-24 12:43:25.723000 -04:30
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
2015-11-24 12:43:35.487000 -04:30
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: F:\APP\CODISA\ORADATA\REDOPPAL\REDO01.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
2015-11-24 12:43:42.081000 -04:30
SMON: enabling cache recovery
2015-11-24 12:45:30.275000 -04:30
Successfully onlined Undo Tablespace 15.
Dictionary check beginning
2015-11-24 12:47:27.031000 -04:30
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
2015-11-24 12:47:31.312000 -04:30
Database Characterset is WE8MSWIN1252
2015-11-24 12:47:39.076000 -04:30
SMON: Restarting fast_start parallel rollback
2015-11-24 12:47:50.529000 -04:30
No Resource Manager plan active
2015-11-24 12:48:30.478000 -04:30
replication_dependency_tracking turned off (no async multimaster replication found)
2015-11-24 12:49:23.521000 -04:30
Starting background process QMNC
QMNC started with pid=36, OS id=3732
2015-11-24 12:50:06.689000 -04:30
LOGSTDBY: Validating controlfile with logical metadata
2015-11-24 12:50:16.282000 -04:30
LOGSTDBY: Validation complete
2015-11-24 12:53:51.389000 -04:30
Errors in file f:\app\codisa\diag\rdbms\redoppal\redoppal\trace\redoppal_p000_384.trc:
ORA-00339: el archive log no contiene ningún redo
ORA-00334: archive log: 'F:\APP\CODISA\ORADATA\REDOPPAL\REDO02.LOG'
2015-11-24 12:54:27.324000 -04:30
From trc file:
[1] Error during leaf key undo operation: 5 count=3
KTB Redo
op: 0x02 ver: 0x01
compat bit: 4 (post-11) padding: 0
at the end:
dump current and previous redo logs
DUMP REDO
Opcodes 10.*
DBAs (file#, block#):
(24, 215701) .
SCNs: scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
**NOTE: Only Dumping Redo less then 12 hours**
Times: 11/24/2015 01:26:37 thru eternity
*** 2015-11-24 13:33:29.386
SCN Start Scan Point: scn: 0x0002.3325dbf7 (9448053751)
*** 2015-11-24 13:33:37.917
INCARNATION:
START: scn: 0x0002.1bafb8ee (9054435566) Timestamp: 06/29/2015 11:42:14
END: scn: 0x0002.33262959 (9448073561)
*** 2015-11-24 13:37:18.742
*Error 339 when opening Archive Log -
F:\APP\CODISA\ORADATA\REDOPPAL\REDO02.LOG at SCN: scn: 0x0002.3325dbf7 (9448053751)
*Error is non fatal for dump - Dump will continue