Hello everybody.
I have a server with Oracle 11.2.0.4 EE + ASM residing on top of OL6.
It's a production server so that's the reason why i'm asking:
ASM has the only group ASMDATA
[+ASM]> asmcmd lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 1044480 619059 0 619059 0 N ASMDATA/
The server also has the following configuration for FRA
NAME DISPLAY_VALUE
db_recovery_file_dest +ASMDATA
db_recovery_file_dest_size 4182M
I carried out some appropriate queries against RMAN :
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
In addition performed this alter operation
alter database enable block change tracking using file '/home/oracle/backups/change_tracking.f';
As you may spoted the server does not have any dedicated FRA disk group so whether it is safe to run the following script on a regular basis - please advise:
run{
allocate channel ch1 type disk;
allocate channel ch2 type disk;
#catalog recovery area noprompt;
crosscheck backup;
crosscheck copy;
crosscheck archivelog all;
delete noprompt obsolete;
DELETE noprompt EXPIRED ARCHIVELOG ALL;
DELETE noprompt EXPIRED BACKUP;
#DELETE noprompt EXPIRED copy device type disk;
#DELETE NOPROMPT ARCHIVELOG ALL completed before 'sysdate-1';
RECOVER COPY OF DATABASE WITH TAG 'WHISMA' until time 'SYSDATE-8';
BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'WHISMA' DATABASE;
BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL;
#restore validate database;
report unrecoverable;
RELEASE CHANNEL ch1;
RELEASE CHANNEL ch2;
}