888-685-3101, ext. 2

Renaming an Oracle Database when using ASM 12c

by | Oct 20, 2014 | Blog, Data Management, Databases

There might be better ways to do it, though this is how I renamed a database when asked to do so…Hope it helps someone out.

Make sure Oracle env is set

ORACLE_HOME ORACLE_SID

sqlplus / as sysdba create pfile from spfile; exit

Create a full database backup just in case you miss a step or something goes
wrong. After this procedure the old backups and archivelog files will no longer
be valid or reconigized, but you can restore to this backup.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2296576 bytes
Variable Size 2550138112 bytes
Database Buffers 1711276032 bytes
Redo Buffers 12070912 bytes
Database mounted.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
[oracle@EOC-ORACLE dpdump]$ which nid
/u01/app/oracle/product/12.1.0/db_1/bin/nid
[oracle@EOC-ORACLE dpdump]$ nid TARGET=sys/password DBNAME=NEW
DBNEWID: Release 12.1.0.1.0 - Production on Thu Jul 17 11:34:17 2014
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
Connected to database OLD (DBID=3513390035)
Connected to server version 12.1.0
Control Files in database:
+DATA/OLD/CONTROLFILE/current.262.852913939
+DATA/OLD/CONTROLFILE/current.261.852913941
Change database ID and database name OLD to NEW? (Y/[N]) => Y
Proceeding with operation
Changing database ID from 3513390035 to 1825199737
Changing database name from OLD to NEW
Control File +DATA/OLD/CONTROLFILE/current.262.852913939 - modified
Control File +DATA/OLD/CONTROLFILE/current.261.852913941 - modified
Datafile +DATA/OLD/DATAFILE/system.258.85291385 - dbid changed, wrote new name
Datafile +DATA/OLD/DATAFILE/NEW.271.85302261 - dbid changed, wrote new name
Datafile +DATA/OLD/DATAFILE/sysaux.257.85291379 - dbid changed, wrote new name
Datafile +DATA/OLD/DATAFILE/undotbs1.260.85291390 - dbid changed, wrote new name
Datafile +DATA/OLD/DATAFILE/NEW.272.85302284 - dbid changed, wrote new name
Datafile +DATA/OLD/DATAFILE/users.259.85291390 - dbid changed, wrote new name
Datafile +DATA/OLD/DATAFILE/NEW.274.85302307 - dbid changed, wrote new name
Datafile +DATA/OLD/DATAFILE/NEW.273.85302332 - dbid changed, wrote new name
Datafile +DATA/OLD/DATAFILE/NEW.275.85302349 - dbid changed, wrote new name
Datafile +DATA/OLD/DATAFILE/ads.276.85302382 - dbid changed, wrote new name
Datafile +DATA/OLD/DATAFILE/dataconv.277.85302382 - dbid changed, wrote new name
Datafile +DATA/OLD/DATAFILE/jetspeed.278.85302382 - dbid changed, wrote new name
Datafile +DATA/OLD/TEMPFILE/temp.269.85291396 - dbid changed, wrote new name
Control File +DATA/OLD/CONTROLFILE/current.262.852913939 - dbid changed, wrote new name
Control File +DATA/OLD/CONTROLFILE/current.261.852913941 - dbid changed, wrote new name
Instance shut down
Database name changed to NEW.
Modify parameter file and generate a new password file before restarting.
Database ID for database NEW changed to 1825199737.
All previous backups and archived redo logs for this database are unusable.
Database is not aware of previous backups and archived logs in Recovery Area.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.
Create new password file
orapwd file=orapwNEW
Change pfile name via mv or cp. Also vi the pfile and the parameters of the pfile as below(created earlier)
mv/cp initOLD.ora initNEW.ora
vi initNEW.ora
FROM:
OLD.__data_transfer_cache_size
OLD.__db_cache_size
OLD.__java_pool_size
OLD.__large_pool_size
OLD.__oracle_base='/u01/app/oracle'
OLD.__pga_aggregate_target
OLD.__sga_target
OLD.__shared_io_pool_size
OLD.__shared_pool_size
OLD.__streams_pool_size
*.audit_file_dest='/u01/app/oracle/admin/OLD/adump'
*.control_files='+DATA/OLD/CONTROLFILE/current.262.852913939','+DATA/OLD/CONTROLFILE/current.261.852913941'
*.db_name='OLD'
*.db_unique_name='OLD'
*.instance_name='OLD'
TO:
NEW.__data_transfer_cache_size
NEW.__db_cache_size
NEW.__java_pool_size
NEW.__large_pool_size
NEW.__oracle_base='/u01/app/oracle'
NEW.__pga_aggregate_target
NEW.__sga_target
NEW.__shared_io_pool_size
NEW.__shared_pool_size
NEW.__streams_pool_size
*.audit_file_dest='/u01/app/oracle/admin/NEW/adump'
*.control_files='+DATA/OLD/CONTROLFILE/current.262.852913939','+DATA/OLD/CONTROLFILE/current.261.852913941'
*.db_name='NEW'
*.db_unique_name='NEW'
*.instance_name='NEW'
vi /etc/oratab
OLD:/u01/app/oracle/product/12.1.0/db_1:N: # line added by Agent
NEW:/u01/app/oracle/product/12.1.0/db_1:N: # line added by Agent
create dump dir
mkdir -p /u01/app/oracle/admin/NEW/adump
delete old dump dirs(save any files you need or want from the directory beforehand)
rm -rf /u01/app/oracle/diag/rdbms/OLD
set env
oraenv
ORACLE_SID = [OLD] ? NEW
sqlplus / as sysdba
startup nomount;
This will create an spfile under the new directory structure with the correct
database name in ASM. This can be verified through asmcmd.
SQL> create spfile='+DATA' from pfile;
File created.
SQL> shutdown immediate;
ORACLE instance shut down.
SQL> exit

Login into +ASM instance using asmcmd tool. Then the new spfile you just
created. Then add the below line with the appropriate directory structure
and filename.

[ORACLE ~]$ asmcmd
ASMCMD> cd +DATA/NEW/PARAMETERFILE
ASMCMD> ls
spfile.270.853168143
ASMCMD>
vi initNEW.ora and add
SPFILE='+DATA/NEW/PARAMETERFILE/spfile.282.853165763'

Now lets use the old controlfiles to create the controlfiles in the
correct ASM location.

ORACLE dbs]$ rman target /
Recovery Manager: Release 12.1.0.1.0 - Production on Thu Jul 17 15:24:10 2014
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> startup nomount;
Oracle instance started
Total System Global Area 4275781632 bytes
Fixed Size 2296576 bytes
Variable Size 2550138112 bytes
Database Buffers 1711276032 bytes
Redo Buffers 12070912 bytes
RMAN> restore controlfile from '+DATA/OLD/CONTROLFILE/Current.261.852913941';
Starting restore at 17-JUL-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=124 device type=DISK
channel ORA_DISK_1: copied control file copy
output file name=+DATA/NEW/CONTROLFILE/current.282.853169127
output file name=+DATA/NEW/CONTROLFILE/current.281.853169127
Finished restore at 17-JUL-14
RMAN> sql "alter system set control_files = ''+DATA/NEW/CONTROLFILE/current.281.853169127'',''+DATA/NEW/CONTROLFILE/current.282.853169127'' scope = spfile";
sql statement: alter system set control_files = ''+DATA/NEW/CONTROLFILE/current.281.853169127'',''+DATA/NEW/CONTROLFILE/current.282.853169127'' scope = spfile
RMAN> shutdown immediate;
Oracle instance shut down
RMAN> startup mount;
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area 4275781632 bytes
Fixed Size 2296576 bytes
Variable Size 2550138112 bytes
Database Buffers 1711276032 bytes
Redo Buffers 12070912 bytes
RMAN> backup as copy database;
Starting backup at 17-JUL-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=+DATA/OLD/DATAFILE/NEW.271.853022617
output file name=+DATA/NEW/DATAFILE/NEW.286.853169583 tag=TAG20140717T153301 RECID=7 STAMP=853169632
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=+DATA/OLD/DATAFILE/NEW.272.853022843
output file name=+DATA/NEW/DATAFILE/NEW.285.853169637 tag=TAG20140717T153301 RECID=8 STAMP=853169686
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=+DATA/OLD/DATAFILE/NEW.274.853023077
output file name=+DATA/NEW/DATAFILE/NEW.280.853169693 tag=TAG20140717T153301 RECID=9 STAMP=853169742
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00008 name=+DATA/OLD/DATAFILE/NEW.273.853023321
output file name=+DATA/NEW/DATAFILE/NEW.284.853169747 tag=TAG20140717T153301 RECID=10 STAMP=853169796
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00009 name=+DATA/OLD/DATAFILE/NEW.275.853023495
output file name=+DATA/NEW/DATAFILE/NEW.283.853169803 tag=TAG20140717T153301 RECID=11 STAMP=853169869
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00006 name=+DATA/OLD/DATAFILE/users.259.852913907
output file name=+DATA/NEW/DATAFILE/users.279.853169877 tag=TAG20140717T153301 RECID=12 STAMP=853169883
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=+DATA/OLD/DATAFILE/system.258.852913853
output file name=+DATA/NEW/DATAFILE/system.287.853169885 tag=TAG20140717T153301 RECID=13 STAMP=853169890
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=+DATA/OLD/DATAFILE/sysaux.257.852913797
output file name=+DATA/NEW/DATAFILE/sysaux.288.853169893 tag=TAG20140717T153301 RECID=14 STAMP=853169897
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=+DATA/OLD/DATAFILE/undotbs1.260.852913909
output file name=+DATA/NEW/DATAFILE/undotbs1.289.853169899 tag=TAG20140717T153301 RECID=15 STAMP=853169899
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00010 name=+DATA/OLD/DATAFILE/ads.276.853023823
output file name=+DATA/NEW/DATAFILE/ads.290.853169901 tag=TAG20140717T153301 RECID=16 STAMP=853169900
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00011 name=+DATA/OLD/DATAFILE/dataconv.277.853023825
output file name=+DATA/NEW/DATAFILE/dataconv.291.853169901 tag=TAG20140717T153301 RECID=17 STAMP=853169901
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00012 name=+DATA/OLD/DATAFILE/jetspeed.278.853023825
output file name=+DATA/NEW/DATAFILE/jetspeed.292.853169903 tag=TAG20140717T153301 RECID=18 STAMP=853169902
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=+DATA/NEW/CONTROLFILE/backup.293.853169903 tag=TAG20140717T153301 RECID=19 STAMP=853169903
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 17-JUL-14
channel ORA_DISK_1: finished piece 1 at 17-JUL-14
piece handle=+DATA/NEW/BACKUPSET/2014_07_17/nnsnf0_tag20140717t153301_0.294.853169905 tag=TAG20140717T153301 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 17-JUL-14
RMAN> list copy of database;
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time
------- ---- - --------------- ---------- ---------------
13 1 A 17-JUL-14 2328483 17-JUL-14
Name: +DATA/NEW/DATAFILE/system.287.853169885
Tag: TAG20140717T153301
7 2 A 17-JUL-14 2328483 17-JUL-14
Name: +DATA/NEW/DATAFILE/NEW.286.853169583
Tag: TAG20140717T153301
14 3 A 17-JUL-14 2328483 17-JUL-14
Name: +DATA/NEW/DATAFILE/sysaux.288.853169893
Tag: TAG20140717T153301
15 4 A 17-JUL-14 2328483 17-JUL-14
Name: +DATA/NEW/DATAFILE/undotbs1.289.853169899
Tag: TAG20140717T153301
8 5 A 17-JUL-14 2328483 17-JUL-14
Name: +DATA/NEW/DATAFILE/NEW.285.853169637
Tag: TAG20140717T153301
12 6 A 17-JUL-14 2328483 17-JUL-14
Name: +DATA/NEW/DATAFILE/users.279.853169877
Tag: TAG20140717T153301
9 7 A 17-JUL-14 2328483 17-JUL-14
Name: +DATA/NEW/DATAFILE/NEW.280.853169693
Tag: TAG20140717T153301
10 8 A 17-JUL-14 2328483 17-JUL-14
Name: +DATA/NEW/DATAFILE/NEW.284.853169747
Tag: TAG20140717T153301
11 9 A 17-JUL-14 2328483 17-JUL-14
Name: +DATA/NEW/DATAFILE/NEW.283.853169803
Tag: TAG20140717T153301
16 10 A 17-JUL-14 2328483 17-JUL-14
Name: +DATA/NEW/DATAFILE/ads.290.853169901
Tag: TAG20140717T153301
17 11 A 17-JUL-14 2328483 17-JUL-14
Name: +DATA/NEW/DATAFILE/dataconv.291.853169901
Tag: TAG20140717T153301
18 12 A 17-JUL-14 2328483 17-JUL-14
Name: +DATA/NEW/DATAFILE/jetspeed.292.853169903
Tag: TAG20140717T153301
RMAN> switch database to copy;
datafile 1 switched to datafile copy "+DATA/NEW/DATAFILE/system.287.853169885"
datafile 2 switched to datafile copy "+DATA/NEW/DATAFILE/NEW.286.853169583"
datafile 3 switched to datafile copy "+DATA/NEW/DATAFILE/sysaux.288.853169893"
datafile 4 switched to datafile copy "+DATA/NEW/DATAFILE/undotbs1.289.853169899"
datafile 5 switched to datafile copy "+DATA/NEW/DATAFILE/NEW.285.853169637"
datafile 6 switched to datafile copy "+DATA/NEW/DATAFILE/users.279.853169877"
datafile 7 switched to datafile copy "+DATA/NEW/DATAFILE/NEW.280.853169693"
datafile 8 switched to datafile copy "+DATA/NEW/DATAFILE/NEW.284.853169747"
datafile 9 switched to datafile copy "+DATA/NEW/DATAFILE/NEW.283.853169803"
datafile 10 switched to datafile copy "+DATA/NEW/DATAFILE/ads.290.853169901"
datafile 11 switched to datafile copy "+DATA/NEW/DATAFILE/dataconv.291.853169901"
datafile 12 switched to datafile copy "+DATA/NEW/DATAFILE/jetspeed.292.853169903"
RMAN> alter database open resetlogs;
Statement processed
RMAN> report schema;
Report of database schema for database with db_unique_name NEW
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 830 SYSTEM *** +DATA/NEW/DATAFILE/system.287.853169885
2 8192 NEW *** +DATA/NEW/DATAFILE/NEW.286.853169583
3 810 SYSAUX *** +DATA/NEW/DATAFILE/sysaux.288.853169893
4 85 UNDOTBS1 *** +DATA/NEW/DATAFILE/undotbs1.289.853169899
5 8192 NEW *** +DATA/NEW/DATAFILE/NEW.285.853169637
6 867 USERS *** +DATA/NEW/DATAFILE/users.279.853169877
7 8192 NEW *** +DATA/NEW/DATAFILE/NEW.280.853169693
8 8192 NEW *** +DATA/NEW/DATAFILE/NEW.284.853169747
9 8192 NEW *** +DATA/NEW/DATAFILE/NEW.283.853169803
10 24 ADS *** +DATA/NEW/DATAFILE/ads.290.853169901
11 24 DATACONV *** +DATA/NEW/DATAFILE/dataconv.291.853169901
12 24 JETSPEED *** +DATA/NEW/DATAFILE/jetspeed.292.853169903
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 561 TEMP 32767 +DATA/OLD/TEMPFILE/temp.269.852913963
RMAN> sql 'alter tablespace temp add tempfile';
sql statement: alter tablespace temp add tempfile
RMAN> exit;
rman target /
RMAN> sql "alter database tempfile ''+DATA/OLD/TEMPFILE/temp.269.852913963'' drop";
using target database control file instead of recovery catalog
sql statement: alter database tempfile ''+DATA/OLD/TEMPFILE/temp.269.852913963'' drop
RMAN> exit;
Next lets move the logfile groups.
SQL> sqlplus / as sysdba
SQL> set lines 150
SQL> set pages 150
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME CON_ID
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ --------- ----------
1 1 1 52428800 512 2 NO CURRENT 2328484 17-JUL-14 2.8147E+14 0
2 1 0 52428800 512 2 YES UNUSED 0 0 0
3 1 0 52428800 512 2 YES UNUSED 0 0 0
SQL> alter database add logfile group 4;
Database altered.
SQL> alter database add logfile group 5;
Database altered.
SQL> alter system switch logfile;
SQL> alter system checkpoint;
System altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME CON_ID
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ --------- ----------
2 1 2 52428800 512 2 NO ACTIVE 2331712 17-JUL-14 2331736 17-JUL-14 0
3 1 3 52428800 512 2 NO ACTIVE 2331736 17-JUL-14 2331741 17-JUL-14 0
4 1 4 104857600 512 2 NO CURRENT 2331741 17-JUL-14 2.8147E+14 0
5 1 0 104857600 512 2 YES UNUSED 0 0 0
SQL> alter system checkpoint;
System altered.
SQL> alter database drop logfile group 2;
Database altered.
SQL> alter database drop logfile group 3;
Database altered.
SQL> alter database add logfile group 1;
Database altered.
SQL> alter database add logfile group 2;
Database altered.
SQL> alter database add logfile group 3;
Database altered.
SQL> alter system switch logfile;
System altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME CON_ID
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ --------- ----------
1 1 5 104857600 512 2 NO CURRENT 2332232 17-JUL-14 2.8147E+14 0
2 1 0 104857600 512 2 YES UNUSED 0 0 0
3 1 0 104857600 512 2 YES UNUSED 0 0 0
4 1 4 104857600 512 2 NO ACTIVE 2331741 17-JUL-14 2332232 17-JUL-14 0
5 1 0 104857600 512 2 YES UNUSED 0 0 0
SQL> alter system checkpoint;
System altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME CON_ID
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ --------- ----------
1 1 5 104857600 512 2 NO CURRENT 2332232 17-JUL-14 2.8147E+14 0
2 1 0 104857600 512 2 YES UNUSED 0 0 0
3 1 0 104857600 512 2 YES UNUSED 0 0 0
4 1 4 104857600 512 2 NO INACTIVE 2331741 17-JUL-14 2332232 17-JUL-14 0
5 1 0 104857600 512 2 YES UNUSED 0 0 0
SQL> alter database drop logfile group 4;
Database altered.
SQL> alter database drop logfile group 5;
Database altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME CON_ID
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ --------- ----------
1 1 5 104857600 512 2 NO CURRENT 2332232 17-JUL-14 2.8147E+14 0
2 1 0 104857600 512 2 YES UNUSED 0 0 0
3 1 0 104857600 512 2 YES UNUSED 0 0 0
SQL> select * from v$logfile
GROUP# STATUS TYPE MEMBER IS_ CON_ID
---------- ------- ------- ------------------------------------------------------------ --- ----------
1 ONLINE +DATA/NEW/ONLINELOG/group_1.267.853172445 NO 0
1 ONLINE +DATA/NEW/ONLINELOG/group_1.268.853172445 YES 0
2 ONLINE +DATA/NEW/ONLINELOG/group_2.265.853172455 NO 0
2 ONLINE +DATA/NEW/ONLINELOG/group_2.266.853172455 YES 0
3 ONLINE +DATA/NEW/ONLINELOG/group_3.263.853173325 NO 0
3 ONLINE +DATA/NEW/ONLINELOG/group_3.264.853173325 YES 0
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------
+DATA/NEW/DATAFILE/system.287.853169885
+DATA/NEW/DATAFILE/sysaux.288.853169893
+DATA/NEW/DATAFILE/undotbs1.289.853169899
+DATA/NEW/DATAFILE/users.279.853169877
+DATA/NEW/DATAFILE/NEW.283.853169803
+DATA/NEW/DATAFILE/NEW.284.853169747
+DATA/NEW/DATAFILE/NEW.280.853169693
+DATA/NEW/DATAFILE/NEW.286.853169583
+DATA/NEW/DATAFILE/NEW.285.853169637
+DATA/NEW/DATAFILE/ads.290.853169901
+DATA/NEW/DATAFILE/dataconv.291.853169901
+DATA/NEW/DATAFILE/jetspeed.292.853169903
SQL> show parameter control_files
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string +DATA/NEW/CONTROLFILE/current.281.853169127, +DATA/NEW/CONTROLFILE/current.282.853169127

As you can see all files have been moved to the correct location in ASM. It’s now safe to remove the other files via asmcmd.

Remember to also edit your listener.ora and tnsnames.ora for the new sid and restart your listener.

After this has been completed you need to take a full rman database backup as the previous backups and archivelogs will not work with this new database with it’s new dbid.