Re: Question about Archivemode

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 18 Jul 2002 00:20:07 +0200
Message-ID: <bbrbjuk34h7eu2evt2jeuuiitc32pa03b3@4ax.com>

On Wed, 17 Jul 2002 21:12:17 GMT, "Ryan" <rgaffuri_at_cox.net> wrote:

>Ok this is a really basic Backup and Recovery question.
>
>If someone drops the system tablespace, ie, an intruder.
>
>Is it possible to perform a backup from the redo logs in you are not in
>archive mode or have any software like RMAN installed? Or do I have to
>recover from my last cold backup?
>
>For those of you who saw an earlier post of mine... no this did not happen.
>:)
>

If you are not in archive mode you need to restore a cold backup. Every transaction after the backup is lost 4 ever.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jul 17 2002 - 17:20:07 CDT