Rman>2>3'/dbbackup/db_%t'4 >5>}
Report the following error:
released channel:ch00 RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE, STACK follows ===============RMAN-00571: ===========================================================RMAN-03009: Failure of backup command on ch00 channel at ,/ One/ - -: +: theORA-19504: Failed to create file"/dbbackup/db_20150811"ORA-27038: Created file already exists Additional information:1RMAN>
The reason is that the control files and parameter files need to generate a separate backup set, cannot share a backup set with the database, and specify a single file name when specifying a backup set to the data file, so the file has been reported as an error. The workaround is to add a%u in format, which will automatically generate a different and unique file name.
The control file cannot coexist with the data file in a backup set because the block size of the two is different, see ref2 for a passage.
note:if the control File block size is not equal to the block size for data file 1
, then the control file cannot is written into the same backup set as the data file. RMAN writes the control file into a backup set by itself if The block size is different. The V$controlfile. Block_size column indicates the control file block SIZE, whereas the Db_block_size initialization parameter indicates the Block size of data file 1
Select from v$controlfile;name ----------------------------------------------------------------------/u01/app/oracle/oradata/dbt/ Control01.ctl 16384 /u01/app/oracle/oradata/dbt/control02.ctl 16384SQL> Show Parameter Db_block_sizename TYPE ----------------------------------------------------------------------------- db_block_size integer 8192 SQL>
Rman backup Times "ora-19504:failed to create File" and "ora-27038:created file already exists"