Rman backup Times "ora-19504:failed to create File" and "ora-27038:created file already exists"

Source: Internet
Author: User

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"

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.