Re: exp and archive available.... recover table

From: Alexander Skwar <alexander_at_skwar.name>
Date: Fri, 13 Jul 2007 13:30:37 +0200
Message-ID: <7973498.xgv8HuFyLJ@kn.gn.rtr.message-center.info>

sybrandb <sybrandb_at_gmail.com> wrote:
> On Jul 13, 12:00 pm, Alexander Skwar <alexan..._at_skwar.name> wrote:

>> What I'm now considering to do is, that I'd copy all the .dbf files and
>> also the redo log files. When I have the archived redo log files
>> available, I am able to do a media recovery, aren't I?

>
> No you aren't. You are copying datafiles without putting tablespaces
> in backup mode.

Yes. What's the problem in doing this, if the redo logs are available?

> If you put your tablespaces in backup mode when you cp files, Oracle
> will change the redolog mechanism, and log the complete block, instead
> of only the changed bytes.
> RMAN is much smarter at this, so you won't need to put the tablespace
> in backup mode.
> Cp a file on the O/S without taking any special precautions will hose
> your database.

Archive logs won't help?

> Or do you already know
> 'everything'?

No, I do not.

> Or do you just hack away and hope no one will notice?

Also not.

> I really don't envy your company.

You know, I don't envy your company and colleagues either.

Alexander Skwar Received on Fri Jul 13 2007 - 06:30:37 CDT