RE: recovery question

From: Mark W. Farnham <>
Date: Tue, 4 Nov 2008 12:54:13 -0500
Message-ID: <>

If, as you wrote, you are merely recovering, there should be no problem.  

However, if you have lost your datafiles and you are actually restoring and then recovering, and in particular if you lost the new datafile, you'll need to recreate it and make sure it is where it is expected to be. Look up the exact procedure, command, and syntax in your exact release level to create an empty datafile. For example in 11gR1 look at alter database create_datafile_clause.  

Take home lesson: If you add a data file, the simplest way to avoid future trouble is to immediately back up the tablespace it is part of and also back up the controlfile both through RMAN and to trace. (Or if you're not using RMAN, in binary to a file system file and to trace.) But if you indeed have all the redo to apply, lacking the datafile is not "game over" regardless of what the usually infallible TK said at OOW.  



From: [] On Behalf Of Prabhu, Krishnaswamy
Sent: Tuesday, November 04, 2008 12:29 PM To:
Subject: recovery question  


There is a full online backup taken for an instance and later we added a datafile for a data tablespace, which is not captured on the rman backup yet. Before another backup schedule, the database crashed, and we're in the process of recoverying the database. Now is there will be a problem during recoverying the datafile which is not backed up. Please advice.  


Watch useful tips on recipes, fitness, yoga and fashion only on MSN videos. Try <> it!

Received on Tue Nov 04 2008 - 11:54:13 CST

Original text of this message