incremental backups and new datafiles
Andrea MAug 17 2009 — edited Aug 24 2009Hi all,
I'm trying to set up some script to configure RMAN to use incremental (level 1) backups to recover a full image backup (incremental level 0) of my database.
To be more precise:
I have all my database under /fw05/app/ora10/oradata/O10CFS/ and I have a copy of my database under /fw04/app/ora10/backup/O10CFS/
I can update my copy running a script like
run{
allocate channel d1 device type disk;
backup incremental level 1
for recover of copy with tag db_O10CFS_whole_copy
database
format '/fw04/app/ora10/backup/O10CFS/INCR_LEV_1_O10CFS_%U.BKP'
tag db_O10CFS_copy_upd;
recover copy of database with tag db_O10CFS_whole_copy;
delete noprompt backupset tag db_O10CFS_copy_upd;
release channel d1 ;
}
So far, so easy.
The problem is: how can I instruct rman to make a copy of new datafile in the right folder (i.e. in /fw04/app/ora10/backup/O10CFS/ ) ?
If I add a new datafile, rman copies it into $ORACLE_HOME/dbs/ !
thanks
andrea