Re: recovery question
- From: "bao jiejie" <baojiejie@xxxxxxxxx>
- To: hkchital@xxxxxxxxxxxxxx
- Date: Wed, 5 Nov 2008 23:09:15 +0800
sorry for the mess, it may because my firefox format issue, let me reinput
...
> *Note:130724.1
> **Note:29430.1*
>
> Make sure the database is mounted.
> In all cases you need the name of the missing datafile. Because the
> controlfile is up-to-date you can retrieve this information with the
> following query:
> select name from v$datafile where file#=2;
> => /u02/oradata/target/users_target01.dbf
>
> 1. The missing datafile is the only datafile that needs recovery.
> In this case you do not have to restore anything.
> Archivelogs are restored automatically by RMAN as they are needed for the
> recover command.
>
> run {
> allocate channel d1 type disk;
> sql "alter database create datafile
> ''/u02/oradata/target/users_target01.dbf'' " ;
> recover database;
> sql "alter database open";
> release channel d1;
> }
>
>
> }
>
>
> 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
>
>
>
--
("'-''-/").___..--''"'-._
'7_ 7 ) '_. ( ).'-.__.')
(_Y_.) ._ ) '._ '. ''-..-'
_.'--'_..-_/ /--'_.' ,'
(il),-'' (li),' ((!.-'
Best regards，
Yours sincerely House
baojiejie@xxxxxxxxx
Other related posts:
