Re: Backup and Recovery

From: <jpivovar_at_lcp.com>
Date: 1995/12/13
Message-ID: <4an260$1cc_at_news.tpp.com>#1/1

> jantonio_at_worldgate.com (JACK) writes (in oart):

> The scenario occurs where the drives holding the read-only data get blown away, so I want to restore the read-only
> tablespaces to their original backup date. I don't want to have to apply logs to this tablespace period. I just want it
> brought back online as of the date it was backed up.
>
> Currently, as of my last go round with this, point intime recovery can only occur a database level, it cannot occur at
> a tablespace or datafile level. Any thoughts??
>

Why would this scenario require point-in-time recovery? If your read-only tablespace is the same as its last cold backup, why not restore the volume and restore the cold backup? Am I missing Something?
Point-in-Time is used to recover to a point just before a VST (Very Stupid Transaction) hosed your data, not media loss.

jpivovar_at_lcp.com Received on Wed Dec 13 1995 - 00:00:00 CET

This message: [ Message body ]
Next message: Enzo Maini: "How do you perform SOUNDEX queries in Forms Query Mode?"
Previous message: Steve Edelstein: "Re: SQL:Joining same table more than once"
In reply to: JACK: "Backup and Recovery"
Next in thread: Andrew Zitelli: "Deadlock problem? Me too!"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message