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:27:29 -0700
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:
