Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Question about Archivemode

Re: Question about Archivemode

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


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

>Also if you drop the system tablespace does it wait for any kind of instance
>shut down or is it immediate? Im 99% sure its instant, but I need to prove
>something to someone at work and I dont want to be wrong.
>
>
>"Ryan" <rgaffuri_at_cox.net> wrote in message
>news:R4lZ8.92701$%%2.3951689_at_news2.east.cox.net...
>> 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.
>> :)
>>
>>
>

SMON will immediately issue a shutdown abort, as soon as the file gets dropped/damaged.

Hth

Sybrand Bakker, Senior Oracle DBA

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US