Who owns it? If it was restored by user "root" and if the protections
are 600, then, oracle will report that the file doesn't exist.
On 02/26/2004 11:25:05 AM, George Leonard wrote:
> The file is definitely there
>
> Taken the error string where the file name is displayed and did a
>
> ls /data3/oradata/networks/archives/networks_t1_s8534.arc
>
> and it returns the file.
>
> George
>
> ________________________________________________
>
> George Leonard
> Oracle Database Administrator
> Dimension Data (Pty) Ltd
> (Reg. No. 1987/006597/07)
> Tel: (+27 11) 575 0573
> Fax: (+27 11) 576 0573
> E-mail:george.leonard_at_za.didata.com
> Web: http://www.didata.co.za
>
> You Have The Obligation to Inform One Honestly of the risk, And As a
> Person
> You Are Committed to Educate Yourself to the Total Risk In Any Activity!
> Once Informed & Totally Aware of the Risk,
> Every Fool Has the Right to Kill or Injure Themselves as They See Fit!
>
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Eckermann
> Sent: 26 February 2004 18:07 PM
> To: oracle-l_at_freelists.org
> Subject: Re: recovery problem, what does this mean
>
> My 2 cents:
>
> It means that archived log is required for recovery. Most likely it is
> not in the archived log destination fs.
> Double check it exists , if it isn't there restore it from tape and
> retry the recovery.
>
>
> George Leonard wrote:
>
> > SQL> alter database recover tablespace netstats_hourly_data5m1;
> > alter database recover tablespace netstats_hourly_data5m1
> > *
> > ERROR at line 1:
> > ORA-00279: change 6641427117202 generated at 02/24/2004 22:11:56
> needed
> > for
> > thread 1
> > ORA-00289: suggestion :
> > /data3/oradata/networks/archives/networks_t1_s8534.arc
> > ORA-00280: change 6641427117202 for thread 1 is in sequence #8534
> >
> >
> > The file listed above def exist.
> >
> > George
> >
> > ________________________________________________
> >
> > George Leonard
> > Oracle Database Administrator
> > Dimension Data (Pty) Ltd
> > (Reg. No. 1987/006597/07)
> > Tel: (+27 11) 575 0573
> > Fax: (+27 11) 576 0573
> > E-mail:george.leonard_at_za.didata.com
> > Web: http://www.didata.co.za
> >
> > You Have The Obligation to Inform One Honestly of the risk, And As a
> > Person
> > You Are Committed to Educate Yourself to the Total Risk In Any
> Activity!
> > Once Informed & Totally Aware of the Risk,
> > Every Fool Has the Right to Kill or Injure Themselves as They See Fit!
> >
> > "This e-mail is sent on the Terms and Conditions that can be accessed
> > by Clicking on this link http://www.vodacom.net/legal/email.asp "
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
> ?This e-mail is sent on the Terms and Conditions that can be accessed by Clicking on this link http://www.vodacom.net/legal/email.asp "
>
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Feb 26 2004 - 10:54:59 CST
