| Restore Operation requires old Archived Redo- Log [message #123649] |
Tue, 14 June 2005 04:35  |
pelle23
Messages: 3
Registered: June 2005
|
Junior Member |
|
|
Hello,
on sunday our db- server has had a problem and switched
one tablespace offline.
As I tried to put it back online I get information that
recovery is necessary.
So I tried to recover the tablespace using a hot- backup
done early the same morning.
I used the following commands:
ALTER DATABASE RECOVER tablespace markem
--- alert.log ----
Sun Jun 12 16:31:46 2005
Media Recovery Tablespace: MARKEM
Media Recovery Start
Starting datafile 13 recovery in thread 1 sequence 16728
Datafile 13: 'S:\ORACLE\ORADATA\LVS\MARKEM.ORA'
Starting datafile 14 recovery in thread 1 sequence 23274
Datafile 14: 'T:\ORACLE\ORADATA\LVS\MARKEM.ORA'
Media Recovery Log
ORA-279 signalled during: ALTER DATABASE RECOVER tablespace markem ...
Sun Jun 12 16:31:54 2005
ALTER DATABASE RECOVER CONTINUE DEFAULT
Media Recovery Log W:\ORACLE\ORADATA\LVS\ARCHIVES\ARCH_1_16728.ARC
Errors with log W:\ORACLE\ORADATA\LVS\ARCHIVES\ARCH_1_16728.ARC.
ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Sun Jun 12 16:31:54 2005
--
So my problem:
The archived redo log arch_1_16728.arc is very old (from january) and overwritten by the backup cycle.
I was happy having an export of this tablespace from one day before.
So I deleted, recreated and importet this tablespace.
But how can I verify having all archived redo logs on the backup?
Or did I something wrong in recover ing the tablespace?
Thanks Steffen
|
|
|
|
| Re: Restore Operation requires old Archived Redo- Log [message #123729 is a reply to message #123649] |
Tue, 14 June 2005 10:28  |
limer
Messages: 15
Registered: June 2005
Location: Madrid
|
Junior Member |
|
|
Hello.
The error was:
ORA-00279 change string generated at string needed for thread string
Cause: The requested log is required to proceed with recovery.
Action: Supply the requested log with ALTER DATABASE RECOVER LOGFILE filename or cancel recovery with ALTER DATABASE RECOVER CANCEL
So you need this file to recover the tablespace. Think that you need the archivelogs from the last backup of the tablespace or database. Probably you need to restore that tablespace and then, recover it. RMAN then will use the last archived redo logs needed to bring that tablespace to the point of crash.
Hope this may help you.
|
|
|
|
| Re: Restore Operation requires old Archived Redo- Log [message #123844 is a reply to message #123649] |
Wed, 15 June 2005 02:05 |
pelle23
Messages: 3
Registered: June 2005
|
Junior Member |
|
|
Thank you limer.
But there is one thing I can't understand.
I thought that if I do a hot backup and copy all the archived
redologs during the backup on it, I can restore everything to the point of backup- time.
But the restore operation wanted to have a very old archived redo log.
What does that mean? Was the datafile I've restored already damaged, or something?
I've lost the trust in my backup, but I re- read all the documentation of oracle it seems to be correct.
(I don't use rman, alter ... backup and xcopy)
Any Idear?
[Updated on: Wed, 15 June 2005 02:07] Report message to a moderator |
|
|
|
| Re: Restore Operation requires old Archived Redo- Log [message #123876 is a reply to message #123649] |
Wed, 15 June 2005 05:31 |
limer
Messages: 15
Registered: June 2005
Location: Madrid
|
Junior Member |
|
|
mmmm.
If you end the tablespace backup process with
ALTER TABLESPACE ... END BACKUP
There is no reason for needing of redo logs made before the begining of the backup. Oracle only needs the redologs between the SCN marked in the BEGIN BACKUP operation and the actual database SCN.
No idea about your problesm.
sorry.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
