 | | | recovery problem, what does this mean | recovery problem, what does this mean 2004-02-26 - By Mladen Gogala
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@(protected)
> 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@(protected)
> [mailto:oracle-l-bounce@(protected)] On Behalf Of David Eckermann
> Sent: 26 February 2004 18:07 PM
> To: oracle-l@(protected)
> 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 (See ORA-00279.ora-code.com): change 6641427117202 generated at 02/24/2004 22:11:56
> needed
> > for
> > thread 1
> > ORA-00289 (See ORA-00289.ora-code.com): suggestion :
> > /data3/oradata/networks/archives/networks_t1_s8534.arc
> > ORA-00280 (See ORA-00280.ora-code.com): 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@(protected)
> > 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@(protected)
> 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
|