Can can i skip offline datafile during restore
I took a backup using this script below:
create script daily_backup_db_full {
# Performs a daily complete backup
execute script alloc_disk;
backup full database skip offline
tag daily_backup_db_full
format '/backuprawtofile/PROD/RMAN/Online_Delete_CRM_Daily_4drives<PROD2_%s:%t:%p>.dbf';
execute script rel_disk;
}
NB: During the backup i skipped datafile 119
And while trying to do a restore it gives error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script restore_uat_2_test_new
RMAN-03002: failure of restore command at 01/27/2010 10:53:50
RMAN-06026: some targets not found - aborting restore