NOTE: Always Do Exercise on Test Environment, First. 

Assumptions : 

1. ASM Instance is already Created and Ready to Use.

2. DB Instance was Started using ‘spfile’

3. Disk Group Name : ‘+DGDATA’ 

- Set the Parameter ‘db_create_file_dest’ to ‘+DGDATA’  

alter system set db_create_file_dest=’+DGDATA’ scope=spfile;

- Set the Parameter ‘control_file’ to the destination in ASM

alter system set control_files=” scope=spfile;

 - Bounce/Open the Database with ‘NoMount’ Clause
startup nomount

- Restore Control File from the Previous Destination
restore controlfile from ‘/u001/oracle/data/control001.ctl’;

- Mount the Database
alter database mount;

-Do the following :

backup as copy database format ‘+DGDATA’;

switch database to copy;

recover database;

alter database open;

alter tablespace TEMP add TEMPFILE;

alter database tempfile ‘/u001/oracle/data/temp001.dbf’ drop; 

Best of Luck.

Popularity: 9% [?]

Share This