Re: deleted undotbs01.dbf...

From: Alexander Skwar <alexander_at_skwar.name>
Date: Thu, 02 Aug 2007 15:55:04 +0200
Message-ID: <3044460.kIR32ofWxN@kn.gn.rtr.message-center.info>

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 Received on Thu Aug 02 2007 - 08:55:04 CDT