Re: recovery question
- From: "bao jiejie" <baojiejie@xxxxxxxxx>
- To: hkchital@xxxxxxxxxxxxxx
- Date: Wed, 5 Nov 2008 23:01:01 +0800
*Note:130724.1
**Note:29430.1*
u can make a try, check if your control file is ok for the restore. ...
Make sure the database is mounted.
6Z3L l2VtI%q s0 In all cases you need the name of the missing datafile.
Because theITPUB个人空间f#KSZ E3u$`'^ Y5V u
controlfile is up-to-date you can retrieve this information with theITPUB个人空间 m
lYmI1K&A
following query:
S/AEgT4pl0 select name from v$datafile where file#= which fileid prompt
your recover error;ITPUB个人空间eF)^t~)P | o|)w:A
=> /u02/oradata/target/users_target01.dbf
1. The missing datafile is the only datafile that needs recovery.
ITPUB个人空间"kfuM%t?!bo8a5F
In this case you do not have to restore anything.
VnTFe,{C0 Archivelogs are restored automatically by RMAN as they are
needed for theITPUB个人空间QV6i u#[5E9v~
recover command.
run {ITPUB个人空间~'Y Rt5J&|
allocate channel d1 type disk;ITPUB个人空间p ]6\;?w
sql "alter database create datafile ITPUB个人空间:Y�u&h#U|qF
''/u02/oradata/target/users_target01.dbf'' " ;ITPUB个人空间6yt:eRr$B y)O fq
~
recover database;
!_ VY2n'x T�R"J0 sql "alter database open";ITPUB个人空间 n [ _ i | a)S
release channel d1;ITPUB个人空间4{9fD!W;ig!d W
}
On Wed, Nov 5, 2008 at 10:04 PM, Hemant K Chitale
<hkchital@xxxxxxxxxxxxxx>wrote:
>
> 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
>
>
>
--
("'-''-/").___..--''"'-._
'7_ 7 ) '_. ( ).'-.__.')
(_Y_.) ._ ) '._ '. ''-..-'
_.'--'_..-_/ /--'_.' ,'
(il),-'' (li),' ((!.-'
Best regards，
Yours sincerely House
baojiejie@xxxxxxxxx
Other related posts:
