Converting a file system From ASM to Non-ASM in Oracle Database
We are going to Converting a file system From ASM to Non-ASM in Oracle Database
Check the database version and status
Check the datafile location :
PRE REQUISITES TO TAKE THE RMAN FULL BACKUP .
We are going to convert the file system of the below database “ORCL” from ASM to NON-ASM.
shutdown and start the database in nomount stage.
Connect to RMAN to copy the control file from ASM diskgroup to local file system.
Mount the database :
Use RMAN to copy the Datafiles from ASM disk group to NON-ASM.
Update the controlfile and data dictionary for the database files.
Switch Database to specify that a datafile copy is now the current datafile, that is, the datafile pointed to by the control file.
Tempfile relocating to local file system
RMAN> run
{
set newname for tempfile ‘+DATA’ to ‘/u01/app/oracle/oradata/prod/temp01.dbf’;
switch tempfile all;
}
executing command: SET NEWNAME
using target database control file instead of recovery catalog
renamed tempfile 1 to /u01/app/oracle/oradata/prod/temp01.dbf in control file
SQL> select name from v$tempfile;
NAME
—————————————-
/u01/app/oracle/oradata/prod/temp01.dbf
OPEN THE DATABASE :
DROP THE REDO LOG FILES AND RE-CREATE TO LOCAL FILE SYSTEM.
Check the control_file and Data_file location.
