RE: recovery question
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: mwf@xxxxxxxx, <prabhu_adam@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 05 Nov 2008 22:04:39 +0800
Mark,
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.
Hemant
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.
Regards,
mwf
Hemant K Chitale
http://hemantoracledba.blogspot.com
"A 'No' uttered from the deepest conviction is better than a 'Yes'
merely uttered to please, or worse, to avoid trouble."
Mohandas Gandhi Quotes
: http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html
--
//www.freelists.org/webpage/oracle-l
Other related posts:
