Re: RMAN SCRIPT

cptkirkh <khill_at_scic.com> wrote in news:aa60d3ec-3522-47ca-990d- 6ab95a39e702_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. Received on Mon Feb 04 2008 - 11:27:06 CST