Re: How to apply archive logs on an cold backup

Bob Jones wrote:

>
> "robson" <dbanewbie_at_yahoo.com.br> wrote in message
> news:514f866a.0408311326.68c5d22d_at_posting.google.com...

>> i have the database with archive log and one cold backup.
>> how to apply archive log in cold backup?
>>
>> thanks,
>> robson

Please don't post complete nonsense.

The 'using backup controlfile' clause should only be specified if that's, strangely enough, actually what you're using. Unless he restores his control files from backup, it would be lunacy to use the clause.

Never mind that an unnecessary use of the clause requires an unnecessary resetlogs, with all the massive downtime and requirement to re-backup the database that brings.

If he loses one DBF, replace that DBF and issue just plain old 'recover datafile X'. If he loses multiple DBFs, restore those DBFS and issue a plain old 'recover database'. If he loses all his control files, then restore the control file and issue a 'recover database using backup controlfile'.

If you don't know how to recover a database, that's fine. But don't mislead others who are looking for assistance, OK?

HJR

-- 
http://www.nicecupofteaandasitdown.com