RE: recovery question
Date: Wed, 05 Nov 2008 22:04:39 +0800
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.
What was it that TK said as being "game over" ?
You are right. It is not game over.
At 01:54 AM Wednesday, Mark W. Farnham wrote:
>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.
Hemant K Chitale
"A 'No' uttered from the deepest conviction is better than a 'Yes'
merely uttered to please, or worse, to avoid trouble."
Mohandas Gandhi Quotes