Re: deleted undotbs01.dbf...

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 02 Aug 2007 07:37:34 -0700
Message-ID: <1186065453.554722@bubbleator.drizzle.com>

Alexander Skwar wrote:
> DA Morgan <damorgan_at_psoug.org> wrote:

>> Stefan Wetter wrote:

>

>>> If RMAN is the only way to do a secure full backup, can you point me to
>>> a good tutorial how to start with RMAN? Thanks!
>>>
>>> Stefan
>> $ rman target / catalog <user_id>/<password>@<repository_db>
>> RMAN> create catalog tablespace <tablespace_name>;
>> RMAN> register database;
>> RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
>> RMAN> backup database plus archivelog;

>
> That sounds nice, but that's (of course) not the complete truth.
> The above will backup the database to a directory, where the backup
> is maybe not wanted. So there's some more to learn that's
> necessary to make good use of RMAN.
>
> And what do you do, if that RMAN thingie breaks? And it breaks
> *VERY* easily.
>
> Alexander Skwar

It is a starting point. It doesn't do this either:

  RMAN> RUN

       {
         ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT 
'/home/oracle/backup1/%U';
         ALLOCATE CHANNEL d2 DEVICE TYPE DISK FORMAT 
'/home/oracle/backup2/%U';
         # AS COPY is default when backing up to disk
         BACKUP DATABASE PLUS ARCHIVELOG;
       }

But is is more than enough to have a secure backup while studying a tutorial and learning more about RMAN.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Thu Aug 02 2007 - 09:37:34 CDT