This content has been marked as final. Show 7 replies
Edited by: newbieDBA on Jan 21, 2013 12:03 AM
1 person found this helpful
by default backup area is FRA, It can be change by db_recovery_file_destuse RMAN "FORMAT" parameter, you can set it by "configure" command or in rman commands
FRA contains archivelog ,backupset,datafile,onlinelog folders..
NOW, i specially want to change backup dest. of archvelog to C: (suppose i have C , D, E, F , G) - (i know for archivelogs its log_archive_dest_N command can backup copies to other location but it also goes to default FRA )
backupset to D:
datafile to E:
onlinelog to F:
controlfile to G:
ALL SHOULD CONTAIN ONLY 1 DESTINATION NOT 2 FOR BACKUPS
Backup archivelogs by specifying the destination path using the "format" clause.
RMAN>backup archivelog all format 'C:\bkp\arch_%U.bak';
But i want that done when i command RMAN>backup database; ONLy(is it possible?)
backup database format .... plus archivelog format ...
RMAN>backup database ;
it will backup everything , i want to know the parameters to change dest. for every and then dnt backup @ default location .
just like --
result should be = backup of [ arch in C,backupset in D, datafile in E,online in F, control in G ]
Thanks in Advance
RMAN>backup database ;it will backup datafiles, controlfile and spfile
it will backup everything
you can see default locations with "show all" rman command
to change, use "configure"