| Media Recovery necessary - Asks for a arch file older than 3 months [message #128617] |
Tue, 19 July 2005 17:14  |
oskarthik
Messages: 26
Registered: March 2005
|
Junior Member |
|
|
hi,
We run our 817 on RH and a datafile requires media recovery.
When we use recover datafile... cmd it asks for an old archieve file (more thn 3 months old) which is deleted coz we have a cron which deleted arch files which are old enough.
We dont have a backup of a db. we just have an export script running daily.
We just have an export dmp which is 2 days old.
Its ok if i get data back until the export.
What shud i do now
Just drop the objects in the schema and import it.
If i do so will the datafile which required media recovery be ok.
r is there to any other way to recover the datafile.
Thanks in advance,
Karthik
[Updated on: Tue, 19 July 2005 17:14] Report message to a moderator |
|
|
|
| Re: Media Recovery necessary - Asks for a arch file older than 3 months [message #128650 is a reply to message #128617] |
Wed, 20 July 2005 00:33  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
HI
Mount the database and make this deleted file offline/or drop it altogether from database.
alter database datafile offline drop
This wont work if the datafile is only one in tablespace.
However, if the datafile is the only datafile in its tablespace, it can be removed together with the tablespace:
DROP TABLESPACE ts_data INCLUDING CONTENTS;
After that open the database & then import data from your export dump.
*** A word of caution: Pls stop that cron immediately or keep track of backups & arhive logs, maintaining all the related information about recovery from these available backups/archive logs.
Regds
Girish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
