| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: recovery problem, what does this mean
have you tried this syntax:
recover tablespace tsname;
instead of
alter database recover ...
-----Original Message-----
From: George Leonard [mailto:leonarge_at_vodacom.co.za]
Sent: Thursday, February 26, 2004 8:25 AM
To: oracle-l_at_freelists.org
Subject: RE: recovery problem, what does this mean
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 "
-- 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 <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 - 12:41:08 CST
 |
 |