|
|
|
|
|
|
Re: Log file Corrupted [message #460431 is a reply to message #460430] |
Fri, 11 June 2010 03:56 |
|
Michel,
I've one member in each group. Now db is in mount stage.
Queries O/p
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------------------- ---------------------- ---------------------- ---------------------- ---------------------- -------- ---------------- ---------------------- -------------------------
1 1 70 52428800 1 NO CURRENT 2825881 11-JUN-10
2 1 68 52428800 1 YES INACTIVE 2785626 11-JUN-10
3 1 69 52428800 1 YES INACTIVE 2805013 11-JUN-10
3 rows selected
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------------------- ------- ------- ------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------ ---------------------
3 ONLINE D:\APP\ORACLE\ORADATA\ORCL\REDO03.LOG NO
2 ONLINE D:\APP\ORACLE\ORADATA\ORCL\REDO02.LOG NO
1 ONLINE D:\APP\ORACLE\ORADATA\ORCL\REDO01.LOG NO
4 STANDBY D:\APP\ORACLE\ORADATA\ORCL\REDO04A.LOG NO
5 STANDBY D:\APP\ORACLE\ORADATA\ORCL\REDO05A.LOG NO
6 STANDBY D:\APP\ORACLE\ORADATA\ORCL\REDO06A.LOG NO
7 STANDBY D:\APP\ORACLE\ORADATA\ORCL\REDO07A.LOG NO
7 rows selected
|
|
|
|
Re: Log file Corrupted [message #460437 is a reply to message #460433] |
Fri, 11 June 2010 04:39 |
|
This is error from startup
SQL> startup
ORACLE instance started.
Total System Global Area 535662592 bytes
Fixed Size 1334380 bytes
Variable Size 507511700 bytes
Database Buffers 20971520 bytes
Redo Buffers 5844992 bytes
Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\APP\ORACLE\ORADATA\ORCL\REDO01.LOG'
|
|
|
|
Re: Log file Corrupted [message #460446 is a reply to message #460440] |
Fri, 11 June 2010 05:04 |
|
Last Lines from alert log files
<msg time='2010-06-11T15:01:42.875+05:30' org_id='oracle' comp_id='rdbms'
msg_id='opiexe:2986:2780954927' client_id='' type='NOTIFICATION'
group='admin_ddl' level='16' host_id='JNET62'
host_addr='192.168.1.93' module='sqlplus.exe' pid='4572'>
<txt>ORA-313 signalled during: ALTER DATABASE OPEN...
</txt>
</msg>
<msg time='2010-06-11T15:01:43.564+05:30' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='JNET62' host_addr='192.168.1.93' module='MMON_SLAVE'
pid='5732'>
<txt>Errors in file d:\app\oracle\diag\rdbms\orcl\orcl\trace\orcl_m000_5732.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\APP\ORACLE\ORADATA\ORCL\REDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
</txt>
</msg>
<msg time='2010-06-11T15:01:46.853+05:30' org_id='oracle' comp_id='rdbms'
msg_id='dbkh_generate_new_failure_alert:2592:3311820762' client_id='' type='ERROR'
group='DRA' level='1' host_id='JNET62'
host_addr='192.168.1.93' module='MMON_SLAVE' pid='5732'>
<txt>Checker run found 2 new persistent data failures
</txt>
</msg>
<msg time='2010-06-11T15:16:35.532+05:30' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='JNET62' host_addr='192.168.1.93' module=''
pid='2868'>
<txt>db_recovery_file_dest_size of 2048 MB is 64.71% used. This is a
</txt>
</msg>
<msg time='2010-06-11T15:16:35.532+05:30' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='JNET62' host_addr='192.168.1.93' module=''
pid='2868'>
<txt>user-specified limit on the amount of space that will be used by this
</txt>
</msg>
<msg time='2010-06-11T15:16:35.532+05:30' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='JNET62' host_addr='192.168.1.93' module=''
pid='2868'>
<txt>database for recovery-related files, and does not reflect the amount of
</txt>
</msg>
<msg time='2010-06-11T15:16:35.532+05:30' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='JNET62' host_addr='192.168.1.93' module=''
pid='2868'>
<txt>space available in the underlying filesystem or ASM diskgroup.
</txt>
</msg>
|
|
|
|
Re: Log file Corrupted [message #460465 is a reply to message #460455] |
Fri, 11 June 2010 06:26 |
|
The following files are available in that folder
CONTROL01.CTL
CONTROL02.CTL
CONTROL03.CTL
REDO02.LOG
REDO03.LOG
REDO04A.LOG
REDO05A.LOG
REDO06A.LOG
REDO07A.LOG
SYSAUX01.DBF
SYSTEM01.DBF
TEMP01.DBF
UNDOTBS01.DBF
USERS01.DBF
DMTBLSP01.DBF
RCVCAT01.DBF
|
|
|
|
|
|
|