RMAN Duplicate Database Failed with RMAN-06136, ORA-15001: diskgroup "DATA_CEX" does not exist or is not mounted

Error Description: RMAN duplicate database command failed with following error

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/18/2012 07:12:15
RMAN-05501: aborting duplication of target database
RMAN-06136: ORACLE error from auxiliary database: ORA-00349: failure obtaining block size for '+data_cex'
ORA-15001: diskgroup "DATA_CEX" does not exist or is not mounted


Solution Description:
RMAN is trying to access the diskgroup which is not accessible from the auxiliary or target database. In the above example DATA_CEX disk group is not accessible from the auxiliary database.

  1. Open your init.ora parameter file which you used for duplicating the database and check whether you used the disk group which is not available.
  2. Check your target database datafile names, logfile members are using this disk group (DATA_CEX) and you have used the corresponding covert parameters (LOG_FILE_NAME_CONVERT, DB_FILE_NAME_CONVERT) in auxiliary database parameter file. This should be the reason for the error and make necessary changes to the parameter file.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google