how to rename asm files
RMAN>
startup mount;
copy datafile 5 to ‘+DATA’;
list copy;
switch datafile 5 to copy;
RMAN> run {
set newname for tempfile 1 to ‘+DATA’;
set newname for tempfile 2 to ‘+DATA’;
…
switch tempfile all;
}
SQL> alter database datafile ‘+ASM_ORADATA31/pc01bko/xdb_01.dbf’ offline;
RMAN> copy datafile ‘+ASM_ORADATA31/pc01bko/xdb_01.dbf’ to ‘+ASM_ORADATA31/p01bko/xdb_01.dbf’;
RMAN> run {
RMAN> set newname for datafile ‘+ASM_ORADATA31/pc01bko/xdb_01.dbf’ to ‘+ASM_ORADATA31/p01bko/xdb_01.dbf’;
RMAN> switch datafile all;
RMAN> }
RMAN> recover datafile ‘+ASM_ORADATA31/p01bko/xdb_01.dbf’;
SQL> alter database datafile ‘+ASM_ORADATA31/p01bko/xdb_01.dbf’ online;
From ASM instance
SQL> alter diskgroup asm_oradata31 drop file ‘+ASM_ORADATA31/pc01bko/xdb_01.dbf’ ;
Â
Discussion ¬