Re: RMAN SCRIPT

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