Re: RMAN SCRIPT

From: Donkey Hot <spam_at_plc.is-a-geek.com>
Date: 05 Feb 2008 16:50:42 GMT
Message-ID: <Xns9A3BC28C24B25SH15SGybs1ysmajw54s5@194.100.2.89>


joel garry <joel-garry_at_home.com> wrote in news:6cf9ee1b-2bbb-4fb5-81c5-dc25fb4f7893_at_j78g2000hsd.googlegroups.com:

> On Feb 4, 9:27 am, Donkey Hot <s..._at_plc.is-a-geek.com> wrote:

>> cptkirkh <kh..._at_scic.com> wrote in news:aa60d3ec-3522-47ca-990d-
>> 6ab95a39e..._at_e6g2000prf.googlegroups.com:
>>
>>
>>
>>
>>
>> > I am currently reading the Backup and recovery guide to learn more
>> > about backups and I have come up with a script to run my backup.  I
>> > think i have what i want but would like someone to look at my
>> > scrupt to see what i might have missed.  Thnaks for your advice.
>>
>> > backup device type disk tag '%TAG' database;
>> > SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
>> > backup device type disk tag '%TAG' archivelog all not backed up
>> > delete all input;
>> > delete noprompt obsolete device type disk;
>> > restore database validate;
>> > CROSSCHECK BACKUPSET;
>> > delete noprompt obsolete;
>> > host 'copy F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\pwdporky.ora
>> > F: \oracle\product\10.2.0\flash_recovery_area';
>> > host 'copy F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
>> > F: \oracle\product\10.2.0\flash_recovery_area';
>> > host 'copy F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
>> > F: \oracle\product\10.2.0\flash_recovery_area';
>> > exit;
>>
>> -1-
>> The second line SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
>> is not needed, if you configure "autobackup" on. It should always
>> backup control files and spfile (it does that alter system command in
>> background)
> 

>>
>> configure controlfile autobackup on;
>>
>> -2-
>> You should go with spfiles instead of this .ora-files
>>
>> autobackup backs up the spfile allright
> 
> I think explicitly backing up the password, listener and tnsnames
> files is a darn good idea.  I also like to backup controlfile to
> trace.  I also like to have multiple backups of archived logs.  I've
> been burned.
> 
> jg
> --
> @home.com is bogus.
> "Don't ever be the first, don't ever be the last, and don't ever
> volunteer to do anything." - U.S. Navy Swabbie
> 

Autobackup is still darn good for restore.

You can restore a database from autobackup with rman commands

C:>oradim -new ... blah create the db instances. C:>rman

rman>restore spfile from autobackup;
rman>restore control files from autobackup;
rman>restore database;
rman>recover database;
Received on Tue Feb 05 2008 - 10:50:42 CST

Original text of this message