Oracle 11g R2 on Linux 64 bit. ASM for the data files.
For the backup and the log multiplexing, I plan to use the following method to back the data file, online logs, archived redo logs, and control files (I purposely put the backs to two different file system, i.e., one on the raw disk (Oracle managed file system), and another as the cooked file system (ext3 system):
Disk 1 formatted as the raw disk for FRA (for data files, online logs, archived redo logs, and control files)
Disk 2 formatted as the regular file system, i.e., ext3 file system (for multiplexing of online logs, archived redo logs, and control files) .
Naturally, in the case that the data files get crashed, the files on the FRA can be used to do the recovery (Both the FRA and ASM are in the same file system and managed by Oracle).
Now, assume both the data files and files in FRA get crashed. I'll need to rely on the Disk 2 (as mentioned above) and the externally backed files to do the full recovery. This sounds workable too.
But I have a question:
The ASM uses Oracle managed file system, while the files on my Disk 2 are in cooked file system (ext3 file system). Will that be a problem in the future database recovery (by RMAN)?
Thanks
Scott