<<Back to DB Administration Main Page
[FATAL] [DBT-06002] Selected disk group (DG_TEST_DATA/TEST/) is not found
ACTION: Specify a disk group that is accessible from the system.
[FATAL] [DBT-06007] The specified location (Redo Log or Control file location) is invalid.
CAUSE: The specified location is not found on the system or is detected to be a file.
[FATAL] [DBT-06002] Selected disk group (DG_TEST_DATA/TEST/) is not found.
ACTION: Specify a disk group that is accessible from the system.
[FATAL] [DBT-06007] The specified location (Redo Log or Control file location) is invalid.
CAUSE: The specified location is not found on the system or is detected to be a file.
[FATAL] [DBT-06007] The specified location (Redo Log or Control file location) is invalid.
CAUSE: The specified location is not found on the system or is detected to be a file.
Reason
Diskgroup name supplied to DBCA missing + in front of it.
Solution
Replace the <DG_NAME> with <+DG_NAME>
As you can see I replaced the each DG_NAME with +DG_NAME in the template file and it resolved my issue
DB Template Extract After Correction (Working)
<?xml version = '1.0'?>
<DatabaseTemplate name="TPL_DB_12201.dbt" description="SI on ASM " version="12.2.0.1.0">
.........................
.........................
<initParam name="log_archive_dest_1" value="'LOCATION=+DG_TEST_FRA'"/>
<initParam name="db_create_file_dest" value="+DG_TEST_DATA"/>
<initParam name="db_create_online_log_dest_2" value="+DG_TEST_FRA"/>
<initParam name="db_create_online_log_dest_1" value="+DG_TEST_REDO"/>
<initParam name="db_recovery_file_dest" value="+DG_TEST_FRA"/>
.........................
.........................
<image name="<OMF_CONTROL_0>" filepath="+DG_TEST_DATA"/>
<image name="<OMF_CONTROL_1>" filepath="+DG_TEST_FRA"/>
<image name="<OMF_CONTROL_2>" filepath="+DG_TEST_REDO"/>
<DatabaseTemplate name="TPL_DB_12201.dbt" description="SI on ASM " version="12.2.0.1.0">
.........................
.........................
<initParam name="log_archive_dest_1" value="'LOCATION=+DG_TEST_FRA'"/>
<initParam name="db_create_file_dest" value="+DG_TEST_DATA"/>
<initParam name="db_create_online_log_dest_2" value="+DG_TEST_FRA"/>
<initParam name="db_create_online_log_dest_1" value="+DG_TEST_REDO"/>
<initParam name="db_recovery_file_dest" value="+DG_TEST_FRA"/>
.........................
.........................
<image name="<OMF_CONTROL_0>" filepath="+DG_TEST_DATA"/>
<image name="<OMF_CONTROL_1>" filepath="+DG_TEST_FRA"/>
<image name="<OMF_CONTROL_2>" filepath="+DG_TEST_REDO"/>
<member ordinal="0" memberName="OMF_1_REDOLOG_MEMBER_0" filepath="+DG_TEST_REDO"/>
<member ordinal="11" memberName="OMF_1_REDOLOG_MEMBER_1" filepath="+DG_TEST_FRA"/>
<member ordinal="0" memberName="OMF_2_REDOLOG_MEMBER_0" filepath="+DG_TEST_REDO"/>
<member ordinal="6" memberName="OMF_2_REDOLOG_MEMBER_1" filepath="+DG_TEST_FRA"/>
<member ordinal="0" memberName="OMF_3_REDOLOG_MEMBER_0" filepath="+DG_TEST_REDO"/>
<member ordinal="6" memberName="OMF_3_REDOLOG_MEMBER_1" filepath="+DG_TEST_FRA"/>
<member ordinal="11" memberName="OMF_1_REDOLOG_MEMBER_1" filepath="+DG_TEST_FRA"/>
<member ordinal="0" memberName="OMF_2_REDOLOG_MEMBER_0" filepath="+DG_TEST_REDO"/>
<member ordinal="6" memberName="OMF_2_REDOLOG_MEMBER_1" filepath="+DG_TEST_FRA"/>
<member ordinal="0" memberName="OMF_3_REDOLOG_MEMBER_0" filepath="+DG_TEST_REDO"/>
<member ordinal="6" memberName="OMF_3_REDOLOG_MEMBER_1" filepath="+DG_TEST_FRA"/>
DB Template Extract Before Correction (Not Working)
<?xml version = '1.0'?>
<DatabaseTemplate name="TPL_DB_12201.dbt" description="SI on ASM " version="12.2.0.1.0">
.........................
.........................
<initParam name="log_archive_dest_1" value="'LOCATION=DG_TEST_FRA'"/>
<initParam name="db_create_file_dest" value="DG_TEST_DATA"/>
<initParam name="db_create_online_log_dest_2" value="DG_TEST_FRA"/>
<initParam name="db_create_online_log_dest_1" value="DG_TEST_REDO"/>
<initParam name="db_recovery_file_dest" value="DG_TEST_FRA"/>
.........................
.........................
<image name="<OMF_CONTROL_0>" filepath="DG_TEST_DATA"/>
<image name="<OMF_CONTROL_1>" filepath="DG_TEST_FRA"/>
<image name="<OMF_CONTROL_2>" filepath="DG_TEST_REDO"/>
<DatabaseTemplate name="TPL_DB_12201.dbt" description="SI on ASM " version="12.2.0.1.0">
.........................
.........................
<initParam name="log_archive_dest_1" value="'LOCATION=DG_TEST_FRA'"/>
<initParam name="db_create_file_dest" value="DG_TEST_DATA"/>
<initParam name="db_create_online_log_dest_2" value="DG_TEST_FRA"/>
<initParam name="db_create_online_log_dest_1" value="DG_TEST_REDO"/>
<initParam name="db_recovery_file_dest" value="DG_TEST_FRA"/>
.........................
.........................
<image name="<OMF_CONTROL_0>" filepath="DG_TEST_DATA"/>
<image name="<OMF_CONTROL_1>" filepath="DG_TEST_FRA"/>
<image name="<OMF_CONTROL_2>" filepath="DG_TEST_REDO"/>
<member ordinal="0" memberName="OMF_1_REDOLOG_MEMBER_0" filepath="DG_TEST_REDO"/>
<member ordinal="11" memberName="OMF_1_REDOLOG_MEMBER_1" filepath="DG_TEST_FRA"/>
<member ordinal="0" memberName="OMF_2_REDOLOG_MEMBER_0" filepath="DG_TEST_REDO"/>
<member ordinal="6" memberName="OMF_2_REDOLOG_MEMBER_1" filepath="DG_TEST_FRA"/>
<member ordinal="0" memberName="OMF_3_REDOLOG_MEMBER_0" filepath="DG_TEST_REDO"/>
<member ordinal="6" memberName="OMF_3_REDOLOG_MEMBER_1" filepath="DG_TEST_FRA"/>
<member ordinal="11" memberName="OMF_1_REDOLOG_MEMBER_1" filepath="DG_TEST_FRA"/>
<member ordinal="0" memberName="OMF_2_REDOLOG_MEMBER_0" filepath="DG_TEST_REDO"/>
<member ordinal="6" memberName="OMF_2_REDOLOG_MEMBER_1" filepath="DG_TEST_FRA"/>
<member ordinal="0" memberName="OMF_3_REDOLOG_MEMBER_0" filepath="DG_TEST_REDO"/>
<member ordinal="6" memberName="OMF_3_REDOLOG_MEMBER_1" filepath="DG_TEST_FRA"/>
Comments
Post a Comment