| 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
UntitledIt means you need the archivelog containing the scn which is in the
archivelog /data3/oradata/networks/archives/networks_t1_s8534.arc. If you
don't have it you won't be able to open the database with the current
recovery scenerio.
Ruth
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of George Leonard
Sent: Thursday, February 26, 2004 10:50 AM
To: oracle-l_at_freelists.org
Subject: recovery problem, what does this mean
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 "
 |
 |