Database Backup and Recovery (MOSC)

MOSC Banner

Question about backup.

edited Jan 20, 2011 3:22PM in Database Backup and Recovery (MOSC) 12 commentsAnswered
Hi gurus,

I have Oracle EE 10.2.4 database on windows 2003 R2 Server.   I have cold backup of the database every night.   I have all archive logs  since my last cold backup everyday.   I don't have recovery situation yet, but have a question in anticipation of it.   My Questions is--

Assume I have media failure, say for example disk failue on Monday monrning at 9.00 AM, which needs media recovery.   At that point I have Sunday night cold backup and all the archives since then.  Now I need to restore my Sunday night cold backup and apply all archives since then on it.  I have shutdown database(normal or abort) at this point of time.  The question is Should I have backup of the existing corrupted database before I try to restore my Cold backup of Sunday and apply archive logs on it?  This question is borthering me.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center