Re: Backup Recovery - Cold Backup in Archive log mode

Howard,

We have a database with some tablespaces are for read-only applications. Does this mean that I can only backup the datafiles related to tablespaces that are being updated? What about system related tablespaces? Thanks ..

"Howard J. Rogers" <hjr_at_dizwell.com> wrote:

>
>"raj" <rajesh_choprauk_at_yahoo.co.uk> wrote in message
>news:80c4d335.0406081512.49502aa8_at_posting.google.com...
>> I want to implement the following approach to backuping our oracle
>> database server.
>>
>> The aim is to allow for point in time recovery of transactions.
>>
>> Weekly Cold Backup
>> Archive Log Mode
>>
>> I'm a little confused with regards to the recovery of control files
>> and redo logs prior to Point in time Recovery. Can someone help
>> clarify?
>>
>> Raj
>
>What's your source of confusion?
>
>You *never* restore control files or online redo logs to perform any sort of
>recovery whatsoever, unless you've actually lost your control files or
>online redo logs.
>
>That's rule 1.
>
>Rule 2 is that you never, ever back up your online redo logs. So even if
>you've lost your online redo logs, you won't actually restore them (instead
>you'll re-create them with an open resetlogs).
>
>Rule 3 is: to perform a point in time recovery, you restore all data files,
>and 'recover database until...'. That's it. No restoring or recovering of
>control files or online logs necessary.
>
>If you could elaborate on what your confusion is, we could go through some
>scenarios with you to help eliminate it.
>
>Regards
>HJR
>
Received on Wed Jun 09 2004 - 02:06:44 CDT