Re: Database can't open / corruption at system01 datafile

  • From: "Mostafa Eletriby" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "m_etrib@xxxxxxxxx" for DMARC)
  • To: "k3nnyp@xxxxxxxxx" <k3nnyp@xxxxxxxxx>
  • Date: Wed, 22 Oct 2014 05:31:12 -0700

Thanks a lot it worked & startup normally without open resetlogs.
RMAN can't backup , I will export data in order to continue.

Thanks


On Wednesday, October 22, 2014 2:28 PM, Mostafa Eletriby 
<dmarc-noreply@xxxxxxxxxxxxx> wrote:
 


It was permission problem at os & solved.
But after altering parameter , startup opens normally & I am in phase of backup 
now by rman & export/import




On Wednesday, October 22, 2014 2:02 PM, Kenny Payton <k3nnyp@xxxxxxxxx> wrote:
 


Are you using an spfile?  If not you can add the parameter itself to your 
init.ora file.



On Oct 22, 2014, at 7:58 AM, Mostafa Eletriby (Redacted sender 
"m_etrib@xxxxxxxxx" for DMARC) <dmarc-noreply@xxxxxxxxxxxxx> wrote:

Actually data at database is not important, but I just need to startup instance 
then perofming export/import as mentioned.
>
>
>
>altering spfile don't work.
>please advice
>
>
>SQL> show user
>USER is "SYS"
>SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile;
>alter system set "_allow_resetlogs_corruption"=true scope=spfile
>*
>ERROR at line 1:
>ORA-27072: File I/O error
>Linux-x86_64 Error: 9: Bad file descriptor
>Additional information: 4
>Additional information: 4
>Additional information: -1
>
>
>
>
>SQL>
>
>
>
>
>
>
>
>
>
>On Wednesday, October 22, 2014 1:50 PM, "hostetter.jay@xxxxxxxxx" 
><hostetter.jay@xxxxxxxxx> wrote:
> 
>
>
>Is there more than 1 copy of redolog 3? If so, you could try recovery from 
>within sql plus and specify the other redolog.  But as others have mentioned, 
>Oracle support is the way to go.
>
>Standard disclaimers apply.
>
>Jay
>
>
>Sent via BlackBerry by AT&T
>________________________________
>
>From:  Mostafa Eletriby <m_etrib@xxxxxxxxx> 
>Date: Wed, 22 Oct 2014 04:30:32 -0700
>To: k3nnyp@xxxxxxxxx<k3nnyp@xxxxxxxxx>; 
>hostetter.jay@xxxxxxxxx<hostetter.jay@xxxxxxxxx>
>ReplyTo:  Mostafa Eletriby <m_etrib@xxxxxxxxx> 
>Cc: oracle-l<oracle-l@xxxxxxxxxxxxx>
>Subject: Re: Database can't open / corruption at system01 datafile
>
>
>Archivelog is enabled,
>
>
>SQL> select log_mode from v$database;
>
>
>LOG_MODE
>------------------------------------
>ARCHIVELOG
>
>
>Block corruption is shown as below:
>------------------------------------------------
>
>
>RMAN> recover database;
>
>
>Starting recover at 22-OCT-14
>using channel ORA_DISK_1
>
>
>starting media recovery
>
>
>archived log for thread 1 with sequence 4149 is already on disk as file 
>/oraData/cdsdb/redo03.log
>archived log file name=/oraData/<SID>/redo03.log thread=1 sequence=4149
>RMAN-00571: ===========================================================
>RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
>RMAN-00571: ===========================================================
>RMAN-03002: failure of recover command at 10/22/2014 13:24:45
>ORA-00283: recovery session canceled due to errors
>RMAN-11003: failure during parse/execution of SQL statement: alter database 
>recover logfile '/oraData/<SID>/redo03.log'
>ORA-00283: recovery session canceled due to errors
>ORA-00354: corrupt redo log block header
>ORA-00353: log corruption near block 9214 change 50976239 time 10/20/2014 
>17:41:50
>ORA-00334: archived log: '/oraData/<SID>/redo03.log'
>
>
>RMAN>
>
>
>
>
>Also please I need to know how to set hidden parameter   
>_allow_resetlogs_corruption=TRUE   at spfile or pfile in order to startup 
>database after this change.
>
>
>Thanks
>
>
>
>
>
>On Wednesday, October 22, 2014 1:22 PM, Kenny Payton <k3nnyp@xxxxxxxxx> wrote:
> 
>
>
>And controlfile.  If those check out I’d start with verifying the file ( 
>database and redo logs ) locations and make sure the actual file locations 
>match that in the control file.  Next step would be to issue a “recover 
>database” command.  If the needed redo is in the redo logs to get the 
>datafiles consistent then it’ll roll forward.  Something tells me archiving is 
>not enabled.
>
>
>Situations like this tend to have a long back story but at it’s simplest this 
>might get you consistent so that you can open the database.
>
>
>You mention corruption in your post but I don’t see anything suggestion 
>corruption, only inconsistency in datafiles.  There is a big difference 
>between the two and handling them are quite different.
>
>
>Kenny
>
>
>
>
>
>On Oct 22, 2014, at 7:12 AM, hostetter.jay@xxxxxxxxx wrote:
>
>Make sure you aren't using an old init.ora or spfile. 
>>
>>Jay
>>Sent via BlackBerry by AT&T
>>________________________________
>>
>>From:  "Mostafa Eletriby" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender 
>>"m_etrib@xxxxxxxxx" for DMARC) 
>>Sender:  oracle-l-bounce@xxxxxxxxxxxxx 
>>Date: Wed, 22 Oct 2014 04:00:24 -0700
>>To: niall.litchfield@xxxxxxxxx<niall.litchfield@xxxxxxxxx>
>>ReplyTo:  dmarc-noreply@xxxxxxxxxxxxx 
>>Cc: oracle-l<oracle-l@xxxxxxxxxxxxx>
>>Subject: Re: Database can't open / corruption at system01 datafile
>>
>>
>>Database version: Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
>>Platform:  Linux 5  2.6.18-164.el5  x86_64 
>>
>>
>>
>>On Wednesday, October 22, 2014 12:53 PM, Mostafa Eletriby 
>><dmarc-noreply@xxxxxxxxxxxxx> wrote:
>> 
>>
>>
>>There is no metalink support.
>>----------------------------------------------
>>SQL> alter database open;
>>alter database open
>>*
>>ERROR at line 1:
>>ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
>>
>>
>>
>>
>>SQL> alter database open resetlogs;
>>alter database open resetlogs
>>*
>>ERROR at line 1:
>>ORA-01196: file 1 is inconsistent due to a failed media recovery session
>>ORA-01110: data file 1: '/oraData/<SID>/system01.dbf'
>>
>>
>>
>>On Wednesday, October 22, 2014 12:45 PM, Niall Litchfield 
>><niall.litchfield@xxxxxxxxx> wrote:
>> 
>>
>>
>>That's what you pay support fees for. Definitely log a P1 SR with Oracle if 
>>you haven't already. 
>>
>>
>>To offer any help we'd need version, platform and exact error messages. Even 
>>then you might not want to take recovery advice from strangers on the 
>>internet.  
>>
>>
>>On Wed, Oct 22, 2014 at 11:36 AM, Mostafa Eletriby 
>><dmarc-noreply@xxxxxxxxxxxxx> wrote:
>>
>>Dear All,
>>>Please I have a problem at database startup as it can only be mounted while 
>>>there isn't any backup taken before , corruption at system01 datafile.
>>>Please advice
>>>
>>>
>>>
>>>
>>>Best Regards,
>>>Mostafa Eletriby
>>>Oracle DBA
>>
>>
>>
>>-- 
>>Niall Litchfield
>>Oracle DBA
>>http://www.orawin.info 
>>
>>
>>
>>
>
>
>
>
>

Other related posts: