patternMinor
Altering the location of Oracle-Suggested Backup
Viewed 0 times
thesuggestedalteringoraclelocationbackup
Problem
On one database, the Oracle-Suggested Backup scheduled from Enterprise Manager always ends up in the recovery area, despite RMAN configuration showing that device type disk format points elsewhere.
As far as I can see, the scheduled backup job is simply:
Asking RMAN to
If I run the script manually, the backupset is placed at the above location, when the script is run from the job scheduler the backupset goes to the RECO group on ASM,
Why might Oracle still choose to dump the backupset to the
Ultimately, how can I change the backup destination?
As far as I can see, the scheduled backup job is simply:
run {
allocate channel oem_disk_backup device type disk;
recover copy of database with tag 'ORA_OEM_LEVEL_0';
backup incremental level 1 cumulative copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
}Asking RMAN to
show all reveals that device type disk is indeed configured to store elsewhere:CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/s01/backup/PROD11/PROD11_%U';If I run the script manually, the backupset is placed at the above location, when the script is run from the job scheduler the backupset goes to the RECO group on ASM,
Why might Oracle still choose to dump the backupset to the
db_recovery_file_dest? Ultimately, how can I change the backup destination?
Solution
I cannot say for sure why RMAN behaves in this way, but as a workaround you can edit the resulting script within the same workflow in EM before the job is created:
This will ensure the backups are placed in the destination you specified regardless of RMAN settings in control file saved with
ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '/disk1/%d_backups/%U';
This will ensure the backups are placed in the destination you specified regardless of RMAN settings in control file saved with
CONFIGURE command.Context
StackExchange Database Administrators Q#46303, answer score: 3
Revisions (0)
No revisions yet.