{"id":5608,"date":"2018-11-22T09:14:41","date_gmt":"2018-11-22T09:14:41","guid":{"rendered":"https:\/\/dbtut.com\/?p=5608"},"modified":"2018-11-22T09:14:41","modified_gmt":"2018-11-22T09:14:41","slug":"how-to-transfer-a-database-in-the-file-system-to-asm","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/11\/22\/how-to-transfer-a-database-in-the-file-system-to-asm\/","title":{"rendered":"How To Transfer a Database in the File System To ASM"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>This article describes how to move a database in the file system into ASM. First, Grid Infrastructure installation is required. We are creating two disk groups named DATA and FRA. The following steps are as follows.<\/p>\n<p>First of all, we close the database and create a pfile from the existing spfile. We need to add new parameters in Pfile.<\/p>\n<p>After these changes, we will need to create spfile in ASM.<\/p>\n\n<pre class=\"lang:default decode:true \">[root@oradb ~]# su - oracle\r\n[oracle@oradb ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.4.0 Production on Mon Aug 31 14:24:52 2015\r\n\r\nCopyright (c) 1982, 2013, Oracle. All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\n\r\nSQL&gt; shu immediate\r\nDatabase closed.\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\n\r\nSQL&gt; create pfile='\/tmp\/initORCL.ora' from spfile;\r\n\r\nFile created.\r\n\r\nSQL&gt; exit\r\nDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options<\/pre>\n<p>&nbsp;<\/p>\n<p>Add the following parameters to &#8220;\/tmp\/initORCL.ora&#8221;.<\/p>\n<pre class=\"lang:default decode:true \">*.control_files=(+DATA, +FRA)\r\n*.db_recovery_file_dest=+FRA\r\n*.db_recovery_file_dest_size=5368709120\r\n*.db_create_file_dest=+DATA\r\n*.db_create_online_log_dest_1=+FRA\r\n\r\n\r\n[oracle@oradb ~]$ vi \/tmp\/initORCL.ora<\/pre>\n<p>&nbsp;<\/p>\n<p>We&#8217;re backing up the existing spfile under &#8220;$ORACLE_HOME\/dbs&#8221; and copying the updated pfile to this directory.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@oradb ~]$ cd $ORACLE_HOME\/dbs\r\n[oracle@oradb dbs]$ mv spfileORCL.ora spfileORCL.ora.31082015\r\n[oracle@oradb dbs]$ mv initORCL.ora initORCL.ora.31082015 \r\n[oracle@oradb dbs]$ mv \/tmp\/initORCL.ora .\r\n[oracle@oradb dbs]$ ls -ltr\r\ntotal 28\r\n-rw-r--r--. 1 oracle oinstall 2851 May 15 2009 init.ora\r\n-rw-r-----. 1 oracle oinstall 605 Aug 26 16:15 initORCL.ora.31082015\r\n-rw-r-----. 1 oracle oinstall 24 Aug 26 16:16 lkORCL\r\n-rw-r-----. 1 oracle oinstall 1536 Aug 26 17:07 orapwORCL\r\n-rw-r-----. 1 oracle oinstall 3584 Aug 30 22:02 spfileORCL.ora.31082015\r\n-rw-rw----. 1 oracle oinstall 1544 Aug 31 14:24 hc_ORCL.dat\r\n-rw-r--r-- 1 oracle oinstall 949 Aug 31 14:27 initORCL.ora<\/pre>\n<p>&nbsp;<\/p>\n<p>We create spfile in ASM.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@oradb dbs]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.4.0 Production on Mon Aug 31 14:29:11 2015\r\n\r\nCopyright (c) 1982, 2013, Oracle. All rights reserved.\r\n\r\nConnected to an idle instance.\r\n\r\nSQL&gt; create spfile from pfile;\r\n\r\nFile created.<\/pre>\n<p>&nbsp;<\/p>\n<p>We are opening the database in nomount mode for the control file restore operation.<\/p>\n<pre class=\"lang:default decode:true\">SQL&gt; startup nomount\r\nORACLE instance started.\r\n\r\nTotal System Global Area 4275781632 bytes\r\nFixed Size 2260088 bytes\r\nVariable Size 2466251656 bytes\r\nDatabase Buffers 1795162112 bytes\r\nRedo Buffers 12107776 bytes\r\n\r\nSQL&gt; exit\r\nDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\n\r\n\r\n[oracle@oradb dbs]$ rman target \/\r\n\r\nRecovery Manager: Release 11.2.0.4.0 - Production on Mon Aug 31 14:30:41 2015\r\n\r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates. All rights reserved.\r\n\r\nconnected to target database: ORCL (not mounted)\r\n\r\nRMAN&gt; restore controlfile from '\/home\/app\/oracle\/oradata\/ORCL\/control01.ctl';\r\n\r\nStarting restore at 31-AUG-15\r\nusing target database control file instead of recovery catalog\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=398 device type=DISK\r\n\r\nchannel ORA_DISK_1: copied control file copy\r\noutput file name=+DATA\/ORCL\/controlfile\/current.256.889194645\r\noutput file name=+FRA\/ORCL\/controlfile\/current.256.889194645\r\nFinished restore at 31-AUG-15\r\n\r\nRMAN&gt; startup mount\r\n\r\ndatabase is already started\r\ndatabase mounted\r\nreleased channel: ORA_DISK_1\r\n\r\nRMAN&gt; configure device type disk parallelism 4;\r\n\r\nnew RMAN configuration parameters:\r\nCONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;\r\nnew RMAN configuration parameters are successfully stored<\/pre>\n<p>&nbsp;<\/p>\n<p>We create a copy of the database in + DATA.<\/p>\n<pre class=\"lang:default decode:true\">RMAN&gt; BACKUP AS COPY DATABASE FORMAT '+DATA';\r\n\r\nStarting backup at 31-AUG-15\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=398 device type=DISK\r\nallocated channel: ORA_DISK_2\r\nchannel ORA_DISK_2: SID=399 device type=DISK\r\nallocated channel: ORA_DISK_3\r\nchannel ORA_DISK_3: SID=14 device type=DISK\r\nallocated channel: ORA_DISK_4\r\nchannel ORA_DISK_4: SID=400 device type=DISK\r\nchannel ORA_DISK_1: starting datafile copy\r\ninput datafile file number=00006 name=\/home\/app\/oracle\/oradata\/ORCL\/hope_data01.dbf\r\nchannel ORA_DISK_2: starting datafile copy\r\ninput datafile file number=00007 name=\/home\/app\/oracle\/oradata\/ORCL\/hope_index01.dbf\r\nchannel ORA_DISK_3: starting datafile copy\r\ninput datafile file number=00002 name=\/home\/app\/oracle\/oradata\/ORCL\/sysaux01.dbf\r\nchannel ORA_DISK_4: starting datafile copy\r\ninput datafile file number=00001 name=\/home\/app\/oracle\/oradata\/ORCL\/system01.dbf\r\noutput file name=+DATA\/ORCL\/datafile\/system.260.889194691 tag=TAG20150831T143129 RECID=2 STAMP=889194743\r\nchannel ORA_DISK_4: datafile copy complete, elapsed time: 00:00:55\r\nchannel ORA_DISK_4: starting datafile copy\r\ninput datafile file number=00003 name=\/home\/app\/oracle\/oradata\/ORCL\/undotbs01.dbf\r\noutput file name=+DATA\/ORCL\/datafile\/sysaux.259.889194691 tag=TAG20150831T143129 RECID=3 STAMP=889194749\r\nchannel ORA_DISK_3: datafile copy complete, elapsed time: 00:01:02\r\nchannel ORA_DISK_3: starting datafile copy\r\ninput datafile file number=00005 name=\/home\/app\/oracle\/oradata\/ORCL\/example01.dbf\r\noutput file name=+DATA\/ORCL\/datafile\/example.262.889194753 tag=TAG20150831T143129 RECID=4 STAMP=889194770\r\nchannel ORA_DISK_3: datafile copy complete, elapsed time: 00:00:25\r\nchannel ORA_DISK_3: starting datafile copy\r\ncopying current control file\r\noutput file name=+DATA\/ORCL\/controlfile\/backup.263.889194777 tag=TAG20150831T143129 RECID=5 STAMP=889194778\r\nchannel ORA_DISK_3: datafile copy complete, elapsed time: 00:00:03\r\nchannel ORA_DISK_3: starting datafile copy\r\ninput datafile file number=00004 name=\/home\/app\/oracle\/oradata\/ORCL\/users01.dbf\r\noutput file name=+DATA\/ORCL\/datafile\/undotbs1.261.889194745 tag=TAG20150831T143129 RECID=6 STAMP=889194778\r\nchannel ORA_DISK_4: datafile copy complete, elapsed time: 00:00:35\r\nchannel ORA_DISK_4: starting full datafile backup set\r\nchannel ORA_DISK_4: specifying datafile(s) in backup set\r\nincluding current SPFILE in backup set\r\nchannel ORA_DISK_4: starting piece 1 at 31-AUG-15\r\noutput file name=+DATA\/ORCL\/datafile\/users.264.889194781 tag=TAG20150831T143129 RECID=7 STAMP=889194781\r\nchannel ORA_DISK_3: datafile copy complete, elapsed time: 00:00:02\r\nchannel ORA_DISK_4: finished piece 1 at 31-AUG-15\r\npiece handle=+DATA\/ORCL\/backupset\/2015_08_31\/nnsnf0_tag20150831t143129_0.265.889194781 tag=TAG20150831T143129 comment=NONE\r\nchannel ORA_DISK_4: backup set complete, elapsed time: 00:00:01\r\noutput file name=+DATA\/ORCL\/datafile\/hope_data.257.889194689 tag=TAG20150831T143129 RECID=8 STAMP=889194909\r\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:47\r\noutput file name=+DATA\/ORCL\/datafile\/hope_index.258.889194689 tag=TAG20150831T143129 RECID=9 STAMP=889194932\r\nchannel ORA_DISK_2: datafile copy complete, elapsed time: 00:04:07\r\nFinished backup at 31-AUG-15<\/pre>\n<p>&nbsp;<\/p>\n<p>With the following switch operation, we set the copies in +DATA as the actual files of the database.<\/p>\n<pre class=\"lang:default decode:true \">RMAN&gt; SWITCH DATABASE TO COPY;\r\n\r\ndatafile 1 switched to datafile copy \"+DATA\/ORCL\/datafile\/system.260.889194691\"\r\ndatafile 2 switched to datafile copy \"+DATA\/ORCL\/datafile\/sysaux.259.889194691\"\r\ndatafile 3 switched to datafile copy \"+DATA\/ORCL\/datafile\/undotbs1.261.889194745\"\r\ndatafile 4 switched to datafile copy \"+DATA\/ORCL\/datafile\/users.264.889194781\"\r\ndatafile 5 switched to datafile copy \"+DATA\/ORCL\/datafile\/example.262.889194753\"\r\ndatafile 6 switched to datafile copy \"+DATA\/ORCL\/datafile\/hope_data.257.889194689\"\r\ndatafile 7 switched to datafile copy \"+DATA\/ORCL\/datafile\/hope_index.258.889194689\"\r\n\r\nRMAN&gt; alter database open;\r\n\r\ndatabase opened\r\n\r\nRMAN&gt; exit\r\n\r\n\r\nRecovery Manager complete.<\/pre>\n<p>&nbsp;<\/p>\n<p>The database is now running in ASM, and the database files in the file system are marked as copies.<\/p>\n<p>We can begin operations after the switch. First of all, we will create temp tablespace in ASM and drop the current temp tablespace.<\/p>\n<pre class=\"lang:default decode:true\">[oracle@oradb dbs]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.4.0 Production on Mon Aug 31 14:36:20 2015\r\n\r\nCopyright (c) 1982, 2013, Oracle. All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nWith the Partitioning, Automatic Storage Management, OLAP, Data Mining\r\nand Real Application Testing options\r\n\r\nSQL&gt; select name, bytes from v$tempfile;\r\n\r\nNAME\r\n--------------------------------------------------------------------------------\r\nBYTES\r\n----------\r\n\/home\/app\/oracle\/oradata\/ORCL\/temp01.dbf\r\n66060288\r\n\r\n\r\nSQL&gt; create temporary tablespace temp1 tempfile SIZE 100M extent management local uniform size 1M;\r\n\r\nTablespace created.\r\n\r\nSQL&gt; alter database default temporary tablespace temp1;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; drop tablespace temp including contents;\r\n\r\nTablespace dropped.\r\n\r\nSQL&gt; create temporary tablespace temp tempfile SIZE 1G extent management local uniform size 10M;\r\n\r\nTablespace created.\r\n\r\nSQL&gt; alter database default temporary tablespace temp;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; drop tablespace temp1 including contents;\r\n\r\nTablespace dropped.<\/pre>\n<p>&nbsp;<\/p>\n<p>We complete Redolog operations.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; shu immediate\r\nDatabase closed.\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\nSQL&gt; startup\r\nORACLE instance started.\r\n\r\nTotal System Global Area 4275781632 bytes\r\nFixed Size 2260088 bytes\r\nVariable Size 2466251656 bytes\r\nDatabase Buffers 1795162112 bytes\r\nRedo Buffers 12107776 bytes\r\nDatabase mounted.\r\nDatabase opened.\r\nSQL&gt; show parameter control;\r\n\r\nNAME TYPE VALUE\r\n------------------------------------ ----------- ------------------------------\r\ncontrol_file_record_keep_time integer 7\r\ncontrol_files string +DATA\/ORCL\/controlfile\/curr\r\nent.256.889194645, +FRA\/dcltes\r\nt\/controlfile\/current.256.8891\r\n94645\r\ncontrol_management_pack_access string DIAGNOSTIC+TUNING\r\n\r\n\r\nSQL&gt; show parameter db_recovery_file_dest_size;\r\n\r\nNAME TYPE VALUE\r\n------------------------------------ ----------- ------------------------------\r\ndb_recovery_file_dest_size big integer 5192M\r\n\r\nSQL&gt; select member from v$logfile;\r\n\r\nMEMBER\r\n--------------------------------------------------------------------------------\r\n\/home\/app\/oracle\/oradata\/ORCL\/redo03.log\r\n\/home\/app\/oracle\/oradata\/ORCL\/redo02.log\r\n\/home\/app\/oracle\/oradata\/ORCL\/redo01.log\r\n\r\nSQL&gt; alter database add logfile thread 1 group 21 ('+DATA') size 100M;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; alter database add logfile thread 1 group 22 ('+DATA') size 100M;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; alter database add logfile thread 1 group 23 ('+DATA') size 100M;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; alter system switch logfile;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; alter system switch logfile;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; alter system switch logfile;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; alter database drop logfile group 1;\r\n\r\nDatabase altered.<\/pre>\n<p>&nbsp;<\/p>\n<p>If you encounter with an error such as the following when you drop the log file, you can correct it with the redo log switch and checkpoint operations.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; alter database drop logfile group 2;\r\nalter database drop logfile group 2\r\n*\r\nERROR at line 1:\r\nORA-01624: log 2 needed for crash recovery of instance ORCL (thread 1)\r\nORA-00312: online log 2 thread 1: '\/home\/app\/oracle\/oradata\/ORCL\/redo02.log'\r\n\r\n\r\nSQL&gt; alter database drop logfile group 3;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; alter system checkpoint;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; alter database drop logfile group 2;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; alter database add logfile thread 1 group 1 ('+DATA') size 100M;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; alter database add logfile thread 1 group 2 ('+DATA') size 100M;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; alter database add logfile thread 1 group 3 ('+DATA') size 100M;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; alter system switch logfile;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; alter system switch logfile;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; alter system switch logfile;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; alter system checkpoint;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; alter database drop logfile group 21;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; alter database drop logfile group 22;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; alter database drop logfile group 23;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; alter database add logfile member '+FRA' to group 1;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; alter database add logfile member '+FRA' to group 2;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; alter database add logfile member '+FRA' to group 3;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; exit\r\nDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nWith the Partitioning, Automatic Storage Management, OLAP, Data Mining\r\nand Real Application Testing options<\/pre>\n<p>&nbsp;<\/p>\n<p>Finally, we delete the copy in the file system.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@oradb dbs]$ rman target \/\r\n\r\nRecovery Manager: Release 11.2.0.4.0 - Production on Mon Aug 31 15:00:27 2015\r\n\r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates. All rights reserved.\r\n\r\nconnected to target database: ORCL (DBID=2455775002)\r\n\r\nRMAN&gt; DELETE COPY OF DATABASE;\r\n\r\nusing target database control file instead of recovery catalog\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=22 device type=DISK\r\nallocated channel: ORA_DISK_2\r\nchannel ORA_DISK_2: SID=410 device type=DISK\r\nallocated channel: ORA_DISK_3\r\nchannel ORA_DISK_3: SID=418 device type=DISK\r\nallocated channel: ORA_DISK_4\r\nchannel ORA_DISK_4: SID=18 device type=DISK\r\nList of Datafile Copies\r\n=======================\r\n\r\nKey File S Completion Time Ckp SCN Ckp Time \r\n------- ---- - --------------- ---------- ---------------\r\n10 1 A 31-AUG-15 121206512 31-AUG-15 \r\nName: \/home\/app\/oracle\/oradata\/ORCL\/system01.dbf\r\n\r\n11 2 A 31-AUG-15 121206512 31-AUG-15 \r\nName: \/home\/app\/oracle\/oradata\/ORCL\/sysaux01.dbf\r\n\r\n12 3 A 31-AUG-15 121206512 31-AUG-15 \r\nName: \/home\/app\/oracle\/oradata\/ORCL\/undotbs01.dbf\r\n\r\n13 4 A 31-AUG-15 121206512 31-AUG-15 \r\nName: \/home\/app\/oracle\/oradata\/ORCL\/users01.dbf\r\n\r\n14 5 A 31-AUG-15 121206512 31-AUG-15 \r\nName: \/home\/app\/oracle\/oradata\/ORCL\/example01.dbf\r\n\r\n15 6 A 31-AUG-15 121206512 31-AUG-15 \r\nName: \/home\/app\/oracle\/oradata\/ORCL\/hope_data01.dbf\r\n\r\n16 7 A 31-AUG-15 121206512 31-AUG-15 \r\nName: \/home\/app\/oracle\/oradata\/ORCL\/hope_index01.dbf\r\n\r\n\r\nDo you really want to delete the above objects (enter YES or NO)? YES \r\ndeleted datafile copy\r\ndatafile copy file name=\/home\/app\/oracle\/oradata\/ORCL\/system01.dbf RECID=10 STAMP=889194941\r\ndeleted datafile copy\r\ndatafile copy file name=\/home\/app\/oracle\/oradata\/ORCL\/sysaux01.dbf RECID=11 STAMP=889194941\r\ndeleted datafile copy\r\ndatafile copy file name=\/home\/app\/oracle\/oradata\/ORCL\/undotbs01.dbf RECID=12 STAMP=889194941\r\ndeleted datafile copy\r\ndatafile copy file name=\/home\/app\/oracle\/oradata\/ORCL\/users01.dbf RECID=13 STAMP=889194941\r\ndeleted datafile copy\r\ndatafile copy file name=\/home\/app\/oracle\/oradata\/ORCL\/example01.dbf RECID=14 STAMP=889194941\r\ndeleted datafile copy\r\ndatafile copy file name=\/home\/app\/oracle\/oradata\/ORCL\/hope_data01.dbf RECID=15 STAMP=889194941\r\ndeleted datafile copy\r\ndatafile copy file name=\/home\/app\/oracle\/oradata\/ORCL\/hope_index01.dbf RECID=16 STAMP=889194941\r\nDeleted 7 objects\r\n\r\n\r\nRMAN&gt; exit\r\n\r\n\r\nRecovery Manager complete.<\/pre>\n<p>&nbsp;<\/p>\n<p>Subsequent operations are required to automatically open the database and view the correct spfile from the pfile.<\/p>\n<p>&nbsp;<\/p>\n<h3>spfile pfile operations:<\/h3>\n<p>Because the spfile is now in the +DATA disk group, the initORCL.ora (pfile) file under dbs must also point to this spfile.<\/p>\n<p>We change the contents of the initORCL.ora file under the $ORACLE_HOME\/dbs directory as follows.<\/p>\n<p>In this way, in the next restart process, the database will see the spfile in the +DATA disk group and open it from there.<\/p>\n<pre class=\"lang:default decode:true \">SPFILE='+DATA\/ORCL\/spfileORCL.ora'<\/pre>\n<p>&nbsp;<\/p>\n<h3>Adding database information to Cluster:<\/h3>\n<p>The following operations are required to include our database in the cluster.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@oradb dbs]$ srvctl add database -d ORCL -n oradb -s open -o \/u01\/app\/oracle\/product\/11.2.0\/db_1 -p +DATA\/ORCL\/spfileORCL.ora -a DATA,FRA\r\n[oracle@oradb dbs]$ srvctl status database -d ORCL\r\nDatabase is not running.\r\n[oracle@oradb dbs]$ srvctl stop database -d ORCL\r\nPRCC-1016 : ORCL was already stopped\r\n[oracle@oradb dbs]$ exit\r\nlogout\r\n[root@oradb \/]# su - oracle\r\n[oracle@oradb ~]$ ps -ef|grep pmon\r\noracle 3166 1 0 Aug27 ? 00:00:24 asm_pmon_+ASM\r\noracle 15840 1 0 15:32 ? 00:00:00 ora_pmon_ORCL\r\noracle 16827 16801 0 15:34 pts\/0 00:00:00 grep pmon\r\n[oracle@oradb ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.4.0 Production on Mon Aug 31 15:34:44 2015\r\n\r\nCopyright (c) 1982, 2013, Oracle. All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nWith the Partitioning, Automatic Storage Management, OLAP, Data Mining\r\nand Real Application Testing options\r\n\r\nSQL&gt; shu immediate\r\nDatabase closed.\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\nSQL&gt; exit\r\nDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nWith the Partitioning, Automatic Storage Management, OLAP, Data Mining\r\nand Real Application Testing options\r\n[oracle@oradb ~]$ srvctl start database -d ORCL\r\n[oracle@oradb ~]$ srvctl status database -d ORCL\r\nDatabase is running.\r\n[oracle@oradb ~]$ . oraenv\r\nORACLE_SID = [ORCL] ? +ASM\r\nThe Oracle base remains unchanged with value \/u01\/app\/oracle\r\n[oracle@oradb ~]$ crs_stat -t\r\nName Type Target State Host \r\n------------------------------------------------------------\r\nora.DATA.dg ora....up.type ONLINE ONLINE oradb \r\nora.FRA.dg ora....up.type ONLINE ONLINE oradb \r\nora....ER.lsnr ora....er.type ONLINE ONLINE oradb \r\nora.asm ora.asm.type ONLINE ONLINE oradb \r\nora.cssd ora.cssd.type ONLINE ONLINE oradb \r\nora.ORCL.db ora....se.type ONLINE ONLINE oradb \r\nora.diskmon ora....on.type OFFLINE OFFLINE \r\nora.evmd ora.evm.type ONLINE ONLINE oradb \r\nora.ons ora.ons.type OFFLINE OFFLINE<\/pre>\n<p>&nbsp;<\/p>\n<p>Our database has started to work in ASM completely.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_5608\" class=\"pvc_stats all  \" data-element-id=\"5608\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; This article describes how to move a database in the file system into ASM. First, Grid Infrastructure installation is required. We are creating two disk groups named DATA and FRA. The following steps are as follows. First of all, we close the database and create a pfile from the existing spfile. We need to &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_5608\" class=\"pvc_stats all  \" data-element-id=\"5608\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-5608","post","type-post","status-publish","format-standard","","category-oracle"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Transfer a Database in the File System To ASM - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Transfer a Database in the File System To ASM\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/11\/22\/how-to-transfer-a-database-in-the-file-system-to-asm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Transfer a Database in the File System To ASM - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Transfer a Database in the File System To ASM\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/11\/22\/how-to-transfer-a-database-in-the-file-system-to-asm\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-22T09:14:41+00:00\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/22\/how-to-transfer-a-database-in-the-file-system-to-asm\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/22\/how-to-transfer-a-database-in-the-file-system-to-asm\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Transfer a Database in the File System To ASM\",\"datePublished\":\"2018-11-22T09:14:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/22\/how-to-transfer-a-database-in-the-file-system-to-asm\/\"},\"wordCount\":367,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/11\/22\/how-to-transfer-a-database-in-the-file-system-to-asm\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/22\/how-to-transfer-a-database-in-the-file-system-to-asm\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/22\/how-to-transfer-a-database-in-the-file-system-to-asm\/\",\"name\":\"How To Transfer a Database in the File System To ASM - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-11-22T09:14:41+00:00\",\"description\":\"How To Transfer a Database in the File System To ASM\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/22\/how-to-transfer-a-database-in-the-file-system-to-asm\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/11\/22\/how-to-transfer-a-database-in-the-file-system-to-asm\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/22\/how-to-transfer-a-database-in-the-file-system-to-asm\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Transfer a Database in the File System To ASM\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Transfer a Database in the File System To ASM - Database Tutorials","description":"How To Transfer a Database in the File System To ASM","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2018\/11\/22\/how-to-transfer-a-database-in-the-file-system-to-asm\/","og_locale":"en_US","og_type":"article","og_title":"How To Transfer a Database in the File System To ASM - Database Tutorials","og_description":"How To Transfer a Database in the File System To ASM","og_url":"https:\/\/dbtut.com\/index.php\/2018\/11\/22\/how-to-transfer-a-database-in-the-file-system-to-asm\/","og_site_name":"Database Tutorials","article_published_time":"2018-11-22T09:14:41+00:00","author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/22\/how-to-transfer-a-database-in-the-file-system-to-asm\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/22\/how-to-transfer-a-database-in-the-file-system-to-asm\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Transfer a Database in the File System To ASM","datePublished":"2018-11-22T09:14:41+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/22\/how-to-transfer-a-database-in-the-file-system-to-asm\/"},"wordCount":367,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/11\/22\/how-to-transfer-a-database-in-the-file-system-to-asm\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/22\/how-to-transfer-a-database-in-the-file-system-to-asm\/","url":"https:\/\/dbtut.com\/index.php\/2018\/11\/22\/how-to-transfer-a-database-in-the-file-system-to-asm\/","name":"How To Transfer a Database in the File System To ASM - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-11-22T09:14:41+00:00","description":"How To Transfer a Database in the File System To ASM","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/22\/how-to-transfer-a-database-in-the-file-system-to-asm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/11\/22\/how-to-transfer-a-database-in-the-file-system-to-asm\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/22\/how-to-transfer-a-database-in-the-file-system-to-asm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Transfer a Database in the File System To ASM"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/5608","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=5608"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/5608\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=5608"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=5608"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=5608"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}