RMAN SCRIPT
Date: Mon, 4 Feb 2008 09:32:03 -0800 (PST)
Message-ID: <aa60d3ec-3522-47ca-990d-6ab95a39e702@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;
Received on Mon Feb 04 2008 - 11:32:03 CST