Datafile folder name change on ASM

[Adhrushta]

Hi Erman,

we cloned our database from production but datafile folder name seems wrong on ASM in our new clone system.Is it possible to change folder name on ASM?

For example:

Our new clone SID_name is DEV,but datafiles are under +DATA/TEST/......

We want to change +DATA/TEST/ to +DATA/DEV without problem

[ErmanArslansOracleBlog]

What is the db_unique_name parameter of your target database?

[ErmanArslansOracleBlog]

Also send me the following ;

values of  "db_file_name_convert , db_create_file_dest and standby_file_management"

[Adhrushta]

unique name >> ERPDEV

standby_file_management  >>>  MANUAL

db_file_name_convert                 string      +DATA/, +DATA/
log_file_name_convert                string      +DATA/, +DATA/

[ErmanArslansOracleBlog]

Send me the following;

1)your duplicate/restore command.
2)select name from v$datafile
3)select name from v$asm_alias; (from ASM instance)

[Adhrushta]

this is our duplicate command;

rman auxiliary /
duplicate database to "ERPDEV" backup location '/u01/bck_for_clone' ;

select name from v$datafile;

NAME
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+DATA/erptst/system01.dbf
+DATA/erptst/system02.dbf
+DATA/erptst/system03.dbf
+DATA/erptst/system04.dbf
+DATA/erptst/system05.dbf
+DATA/erptst/system06.dbf
+DATA/erptst/system07.dbf
+DATA/erptst/system08.dbf
+DATA/erptst/system09.dbf
+DATA/erptst/system10.dbf
+DATA/erptst/system11.dbf

NAME
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+DATA/erptst/undo01.dbf
+DATA/erptst/a_archive01.dbf
+DATA/erptst/a_int01.dbf
+DATA/erptst/a_media01.dbf
+DATA/erptst/a_nolog01.dbf
+DATA/erptst/a_queue01.dbf
+DATA/erptst/a_queue02.dbf
+DATA/erptst/a_ref01.dbf
+DATA/erptst/a_ref02.dbf
+DATA/erptst/a_summ01.dbf
+DATA/erptst/a_txn_data01.dbf

NAME
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+DATA/erptst/a_txn_data02.dbf
+DATA/erptst/a_txn_data03.dbf
+DATA/erptst/a_txn_ind01.dbf
+DATA/erptst/a_txn_ind02.dbf
+DATA/erptst/a_txn_ind03.dbf
+DATA/erptst/a_txn_ind04.dbf
+DATA/erptst/a_txn_ind05.dbf
+DATA/erptst/ctxd01.dbf
+DATA/erptst/odm.dbf
+DATA/erptst/olap.dbf
+DATA/erptst/owad01.dbf

NAME
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+DATA/erptst/portal01.dbf
+DATA/erptst/sysaux01.dbf
+DATA/erptst/apps_ts_tools01.dbf
+DATA/erptst/interim.dbf
+DATA/erptst/a_txn_data4.dbf
+DATA/erptst/a_txn_ind6.dbf
+DATA/erptst/system12.dbf
+DATA/erptst/system13.dbf
+DATA/erptst/system14.dbf
+DATA/erptst/system15.dbf
+DATA/erptst/system16.dbf

NAME
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+DATA/erptst/system17.dbf
+DATA/erptst/system18.dbf
+DATA/erptst/system19.dbf
+DATA/erptst/system20.dbf
+DATA/erptst/system21.dbf
+DATA/erptst/system22.dbf
+DATA/erptst/system23.dbf
+DATA/erptst/system24.dbf
+DATA/erptst/a_ref03.dbf
+DATA/erptst/a_ref04.dbf
+DATA/erptst/a_ref05.dbf

NAME
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+DATA/erptst/undo02.dbf
+DATA/ERPDEV/DATAFILE/undotbs2.310.957747357
+DATA/ERPDEV/DATAFILE/apps_ts_tx_data.289.957746909
+DATA/ERPDEV/DATAFILE/apps_ts_tx_data.263.957746907
+DATA/ERPDEV/DATAFILE/xxefa_idx.288.957746909
+DATA/ERPDEV/DATAFILE/xxefa_data.277.957746909
+DATA/ERPDEV/DATAFILE/xxdt_idx.324.957747635
+DATA/ERPDEV/DATAFILE/xxdt_data.264.957746907
+DATA/ERPDEV/DATAFILE/xxvb_idx.325.957747695
+DATA/ERPDEV/DATAFILE/xxvb_data.290.957746909
+DATA/ERPDEV/DATAFILE/xxmt_idx.283.957746909

NAME
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+DATA/ERPDEV/DATAFILE/xxmt_data.326.957747711
+DATA/ERPDEV/DATAFILE/apps_ts_interface.266.957746907
+DATA/ERPDEV/DATAFILE/xxdt_data.262.957746907
+DATA/ERPDEV/DATAFILE/apps_ts_tx_data.260.957746907

70 rows selected.

----------------------------------------


select name from v$asm_alias;

NAME
----------------------------------------------------------------------
ASM
ASMPARAMETERFILE
REGISTRY.253.957172761
PASSWORD
pwdasm.256.957172761
orapwasm
erptst
system24.dbf
a_ref05.dbf
system09.dbf
system15.dbf

NAME
----------------------------------------------------------------------
a_txn_ind01.dbf
a_media01.dbf
undo01.dbf
system17.dbf
sysaux01.dbf
a_txn_ind02.dbf
a_int01.dbf
system12.dbf
system19.dbf
a_txn_ind05.dbf
a_ref01.dbf

NAME
----------------------------------------------------------------------
system21.dbf
a_ref02.dbf
system13.dbf
system04.dbf
system06.dbf
system11.dbf
system14.dbf
system23.dbf
system16.dbf
system18.dbf
a_ref04.dbf

NAME
----------------------------------------------------------------------
system10.dbf
a_txn_data02.dbf
system03.dbf
system01.dbf
system05.dbf
a_archive01.dbf
a_txn_ind6.dbf
a_queue01.dbf
a_txn_data03.dbf
system20.dbf
odm.dbf

NAME
----------------------------------------------------------------------
apps_ts_tools01.dbf
system22.dbf
a_ref03.dbf
portal01.dbf
a_txn_data01.dbf
a_txn_ind03.dbf
a_nolog01.dbf
a_summ01.dbf
owad01.dbf
a_txn_ind04.dbf
interim.dbf

NAME
----------------------------------------------------------------------
system08.dbf
olap.dbf
ctxd01.dbf
a_txn_data4.dbf
system07.dbf
system02.dbf
undo02.dbf
a_queue02.dbf
ERPDEV
CONTROLFILE
current.257.957746891

NAME
----------------------------------------------------------------------
current.258.957746891
current.259.957746891
cntrl01.dbf
cntrl02.dbf
cntrl03.dbf
DATAFILE
XXDT_DATA.264.957746907
APPS_TS_TX_DATA.263.957746907
XXDT_DATA.262.957746907
SYSTEM.261.957746907
APPS_TS_TX_DATA.260.957746907

NAME
----------------------------------------------------------------------
APPS_TS_SEED.265.957746907
APPS_TS_INTERFACE.266.957746907
SYSTEM.267.957746907
SYSTEM.268.957746907
APPS_TS_TX_IDX.269.957746907
APPS_TS_MEDIA.270.957746907
APPS_UNDOTS1.271.957746907
SYSTEM.272.957746909
SYSAUX.273.957746909
APPS_TS_TX_IDX.274.957746909
APPS_TS_INTERFACE.275.957746909

NAME
----------------------------------------------------------------------
SYSTEM.276.957746909
XXEFA_DATA.277.957746909
SYSTEM.278.957746909
APPS_TS_TX_IDX.279.957746909
APPS_TS_SEED.280.957746909
SYSTEM.281.957746909
APPS_TS_SEED.282.957746909
XXMT_IDX.283.957746909
SYSTEM.284.957746909
SYSTEM.285.957746909
SYSTEM.286.957746909

NAME
----------------------------------------------------------------------
SYSTEM.287.957746909
XXEFA_IDX.288.957746909
APPS_TS_TX_DATA.289.957746909
XXVB_DATA.290.957746909
SYSTEM.291.957746909
SYSTEM.292.957746909
SYSTEM.293.957746909
SYSTEM.294.957746909
APPS_TS_SEED.295.957746909
SYSTEM.296.957746909
APPS_TS_TX_DATA.297.957746909

NAME
----------------------------------------------------------------------
SYSTEM.298.957746909
SYSTEM.299.957746909
SYSTEM.300.957746931
APPS_TS_ARCHIVE.301.957746931
APPS_TS_TX_IDX.302.957746955
APPS_TS_QUEUES.303.957746993
APPS_TS_TX_DATA.304.957747271
SYSTEM.305.957747291
ODM.306.957747307
APPS_TS_TOOLS.307.957747319
SYSTEM.308.957747319

NAME
----------------------------------------------------------------------
APPS_TS_SEED.309.957747329
UNDOTBS2.310.957747357
PORTAL.311.957747375
APPS_TS_TX_DATA.312.957747395
APPS_TS_TX_IDX.313.957747421
APPS_TS_NOLOGGING.314.957747427
APPS_TS_SUMMARY.315.957747447
OWAPUB.316.957747459
APPS_TS_TX_IDX.317.957747503
INTERIM.318.957747525
SYSTEM.319.957747555

NAME
----------------------------------------------------------------------
OLAP.320.957747569
CTXD.321.957747579
APPS_TS_TX_DATA.322.957747579
SYSTEM.323.957747605
XXDT_IDX.324.957747635
XXVB_IDX.325.957747695
XXMT_DATA.326.957747711
SYSTEM.327.957747727
APPS_UNDOTS1.328.957747913
APPS_TS_QUEUES.329.957748019
ONLINELOG

NAME
----------------------------------------------------------------------
group_3.330.957749689
group_3.331.957749695
group_4.332.957749701
group_4.333.957749707

147 rows selected.

[ErmanArslansOracleBlog]

Drop ASM aliases and recrete the controlfile accordingly.

Alias Dropping can be done using ALTER DISKGROUP DATA DROP ALIAS 'blabla'