Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.
run {
host 'copy D:\oracle\product\10.2.0\db_1\database\spfiletest.ora E:\oracle\flash_recovery_area\TEST';
host 'copy D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora E:\oracle\flash_recovery_area\TEST';
host 'copy D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora E:\oracle\flash_recovery_area\TEST';
configure backup optimization on;
crosscheck backup of database;
crosscheck backup of controlfile;
crosscheck archivelog all;
delete noprompt obsolete;
delete force noprompt expired backup of database;
delete force noprompt expired backup of controlfile;
delete force noprompt expired archivelog all;
backup as compressed backupset database plus archivelog;
crosscheck backup of database;
backup flash recovery area;
}
exit
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
You have two "crosscheck backup of database" lines, only one should be needed, unless you are somehow deleting something from outside of RMAN.
Also make sure you have: "configure controlfile autobackup on;" in your RMAN config.
Other than that, it looks good.
Specifically: backup as compressed backupset database plus archivelog;
Will correctly backup your DB plus flush your archivelog so you'll have a full backupset to recover from. This is often an oversight.