OraFAQ Forum: Backup & Recovery » Restore Operation requires old Archived Redo- Log

Home » RDBMS Server » Backup & Recovery » Restore Operation requires old Archived Redo- Log

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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.

Report message to a moderator

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.

Report message to a moderator

Previous Topic:	Importing dump taken from higher version to lower version
Next Topic:	time taken by import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Mar 01 02:36:08 CST 2025