{"id":1553,"date":"2010-03-03T01:15:46","date_gmt":"2010-03-03T05:15:46","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2010\/03\/03\/migrating-non-asm-db-to-asm-db\/"},"modified":"2010-03-03T01:15:46","modified_gmt":"2010-03-03T05:15:46","slug":"migrating-non-asm-db-to-asm-db","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/03\/migrating-non-asm-db-to-asm-db\/","title":{"rendered":"Migrating Non ASM DB to ASM DB"},"content":{"rendered":"

This is a sample document showing how to migrate Non ASM DB to ASM DB
\n1 create the ASM instance<\/p>\n

2.Create the required\u00a0 DISK groups according to\u00a0 the needs<\/p>\n

DB name DEVEL<\/p>\n

SQL> select file_name from dba_data_files;<\/p>\n

FILE_NAME
\n——————————————————————————–
\n\/oracle\/DEVEL\/system01.dbf
\n\/oracle\/DEVEL\/undotbs01.dbf
\n\/oracle\/DEVEL\/sysaux01.dbf
\n\/oracle\/DEVEL\/users01.dbf
\n\/oracle\/DEVEL\/example01.dbf<\/p>\n

SQL> select name from v$controlfile;<\/p>\n

NAME
\n——————————————————————————–
\n\/oracle\/DEVEL\/control01.ctl
\nSQL> select MEMBER from v$logfile;<\/p>\n

MEMBER
\n——————————————————————————–
\n\/oracle\/DEVEL\/redo03.log
\n\/oracle\/DEVEL\/redo02.log
\n\/oracle\/DEVEL\/redo01.log
\nShutdown the database.<\/p>\n

SQL> SHUTDOWN IMMEDIATE<\/p>\n

Start the database in nomount mode.<\/p>\n

RMAN> STARTUP NOMOUNT (make sure you start with the spfile )
\nRestore the controlfile into ASM
\nRMAN> restore controlfile to ‘+DATA1’ from ‘\/oracle\/DEVEL\/control01.ctl’;<\/p>\n

Starting restore at 22-FEB-06
\nusing target database control file instead of recovery catalog
\nallocated channel: ORA_DISK_1
\nchannel ORA_DISK_1: sid=37 devtype=DISK<\/p>\n

channel ORA_DISK_1: copied control file copy
\nFinished restore at 22-FEB-06<\/p>\n

Find the contlrol file in ASM<\/p>\n

ASMCMD> find -t CONTROLFILE\u00a0 +DATA1 *<\/p>\n

+DATA1\/DEVEL\/CONTROLFILE\/backup.264.583101555
\n+DATA1\/DEVEL\/CONTROLFILE\/backup.265.583101651
\nModify the spfile for the controlfile new path
\nSQL> alter system set control_files=’+DATA1\/DEVEL\/CONTROLFILE\/backup.264.583101555′,’+DATA1\/DEVEL\/CONTROLFILE\/backup.265.583101651′ scope=spfile;<\/p>\n

System altered.
\nshutdown\u00a0 the database and restart in mount state
\nSQL> shutdown
\nORA-01507: database not mounted
\nORACLE instance shut down.
\nSQL> startup mount
\nORACLE instance started.<\/p>\n

Total System Global Area\u00a0 473956352 bytes
\nFixed Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1220072 bytes
\nVariable Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 142606872 bytes
\nDatabase Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 327155712 bytes
\nRedo Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2973696 bytes
\nDatabase mounted.<\/p>\n

SQL> select name from v$controlfile;<\/p>\n

NAME
\n——————————————————————————–
\n+DATA1\/devel\/controlfile\/backup.264.583101555
\n+DATA1\/devel\/controlfile\/backup.265.583101651
\nNow move the datafiles to ASM<\/p>\n

(here as my DB size was too small\u00a0 i used this simple method, where as in big sized DB you should implement some other strategies to do everything in\u00a0\u00a0in parallel\u00a0 as the downtime will be minimal)
\nRMAN> BACKUP AS COPY DATABASE FORMAT ‘+DATA1’;<\/p>\n

Starting backup at 22-FEB-06
\nallocated channel: ORA_DISK_1
\nchannel ORA_DISK_1: sid=37 devtype=DISK
\nchannel ORA_DISK_1: starting datafile copy
\ninput datafile fno=00001 name=\/oracle\/DEVEL\/system01.dbf<\/p>\n

output filename=+DATA1\/devel\/datafile\/system.256.583100553 tag=TAG20060222T202229 recid=5 stamp=583100614
\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:05
\nchannel ORA_DISK_1: starting datafile copy
\ninput datafile fno=00003 name=\/oracle\/DEVEL\/sysaux01.dbf
\noutput filename=+DATA1\/devel\/datafile\/sysaux.257.583100615 tag=TAG20060222T202229 recid=6 stamp=583100652
\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
\nchannel ORA_DISK_1: starting datafile copy
\ninput datafile fno=00005 name=\/oracle\/DEVEL\/example01.dbf
\noutput filename=+DATA1\/devel\/datafile\/example.258.583100661 tag=TAG20060222T202229 recid=7 stamp=583100675
\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
\nchannel ORA_DISK_1: starting datafile copy
\ninput datafile fno=00002 name=\/oracle\/DEVEL\/undotbs01.dbf
\noutput filename=+DATA1\/devel\/datafile\/undotbs1.259.583100677 tag=TAG20060222T202229 recid=8 stamp=583100680
\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
\nchannel ORA_DISK_1: starting datafile copy
\ninput datafile fno=00004 name=\/oracle\/DEVEL\/users01.dbf
\noutput filename=+DATA1\/devel\/datafile\/users.260.583100683 tag=TAG20060222T202229 recid=9 stamp=583100684
\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
\nchannel ORA_DISK_1: starting datafile copy
\ncopying current control file
\noutput filename=+DATA1\/devel\/controlfile\/backup.261.583100685 tag=TAG20060222T202229 recid=10 stamp=583100686
\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
\nchannel ORA_DISK_1: starting full datafile backupset
\nchannel ORA_DISK_1: specifying datafile(s) in backupset
\nincluding current SPFILE in backupset
\nchannel ORA_DISK_1: starting piece 1 at 22-FEB-06
\nchannel ORA_DISK_1: finished piece 1 at 22-FEB-06
\npiece handle=+DATA1\/devel\/backupset\/2006_02_22\/nnsnf0_tag20060222t202229_0.262.583100689 tag=TAG20060222T202229 comment=NONE
\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
\nFinished backup at 22-FEB-06<\/p>\n

RMAN>
\nRMAN> SWITCH DATABASE TO COPY;<\/p>\n

datafile 1 switched to datafile copy “+DATA1\/devel\/datafile\/system.256.583100553”
\ndatafile 2 switched to datafile copy “+DATA1\/devel\/datafile\/undotbs1.259.583100677”
\ndatafile 3 switched to datafile copy “+DATA1\/devel\/datafile\/sysaux.257.583100615”
\ndatafile 4 switched to datafile copy “+DATA1\/devel\/datafile\/users.260.583100683”
\ndatafile 5 switched to datafile copy “+DATA1\/devel\/datafile\/example.258.583100661”
\nRMAN> ALTER DATABASE OPEN;<\/p>\n

database opened<\/p>\n

SQL> select file_name from dba_data_files;<\/p>\n

FILE_NAME
\n——————————————————————————–
\n+DATA1\/devel\/datafile\/system.256.583100553
\n+DATA1\/devel\/datafile\/undotbs1.259.583100677
\n+DATA1\/devel\/datafile\/sysaux.257.583100615
\n+DATA1\/devel\/datafile\/users.260.583100683
\n+DATA1\/devel\/datafile\/example.258.583100661
\nMove the redo logs to ASM<\/p>\n

SQL> select * from v$log;<\/p>\n

\u00a0\u00a0\u00a0 GROUP#\u00a0\u00a0\u00a0 THREAD#\u00a0 SEQUENCE#\u00a0\u00a0\u00a0\u00a0\u00a0 BYTES\u00a0\u00a0\u00a0 MEMBERS ARC STATUS
\n———- ———- ———- ———- ———- — —————-
\nFIRST_CHANGE# FIRST_TIM
\n————- ———
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0 104857600\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 YES INACTIVE
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 567335 22-FEB-06<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6\u00a0 104857600\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 YES INACTIVE
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 567340 22-FEB-06<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7\u00a0\u00a0 52428800\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 NO\u00a0 CURRENT
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 567343 22-FEB-06<\/p>\n

SQL> alter database drop logfile group 1;<\/p>\n

Database altered.<\/p>\n

SQL> alter database add logfile group 1 (‘+DATA1’) size 100M;<\/p>\n

Database altered.<\/p>\n

SQL> alter database drop logfile group 2;<\/p>\n

Database altered.<\/p>\n

SQL> alter database add logfile group 2 (‘+DATA1’) size 100M;<\/p>\n

Database altered.
\nSQL> alter system switch logfile;<\/p>\n

System altered.<\/p>\n

SQL> select * from v$log;<\/p>\n

\u00a0\u00a0\u00a0 GROUP#\u00a0\u00a0\u00a0 THREAD#\u00a0 SEQUENCE#\u00a0\u00a0\u00a0\u00a0\u00a0 BYTES\u00a0\u00a0\u00a0 MEMBERS ARC STATUS
\n———- ———- ———- ———- ———- — —————-
\nFIRST_CHANGE# FIRST_TIM
\n————- ———
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8\u00a0 104857600\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 NO\u00a0 CURRENT
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 567349 22-FEB-06<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6\u00a0 104857600\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 YES INACTIVE
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 567340 22-FEB-06<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7\u00a0\u00a0 52428800\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 YES INACTIVE
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 567343 22-FEB-06
\nSQL> alter database drop logfile group 3;<\/p>\n

Database altered.<\/p>\n

SQL> alter database add logfile group 3 (‘+DATA1’) size 100M;<\/p>\n

Database altered.
\nSQL> select member from v$logfile;<\/p>\n

MEMBER
\n——————————————————————————–
\n+DATA1\/devel\/onlinelog\/group_3.268.583102251
\n+DATA1\/devel\/onlinelog\/group_2.267.583102163
\n+DATA1\/devel\/onlinelog\/group_1.266.583102121
\nRMAN> BACKUP AS COPY SPFILE FORMAT ‘+DATA1′;<\/p>\n

Starting backup at 22-FEB-06
\nusing target database control file instead of recovery catalog
\nallocated channel: ORA_DISK_1
\nchannel ORA_DISK_1: sid=32 devtype=DISK
\nchannel ORA_DISK_1: starting full datafile backupset
\nchannel ORA_DISK_1: specifying datafile(s) in backupset
\nincluding current SPFILE in backupset
\nchannel ORA_DISK_1: starting piece 1 at 22-FEB-06
\nchannel ORA_DISK_1: finished piece 1 at 22-FEB-06
\npiece handle=+DATA1\/devel\/backupset\/2006_02_22\/nnsnf0_tag20060222t211333_0.270.583103615 tag=TAG20060222T211333 comment=NONE
\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
\nFinished backup at 22-FEB-06<\/p>\n

Now find the spfile in the ASM<\/p>\n

ASMCMD> find -t parameterfile +DATA1 *
\n+DATA1\/DEVEL\/PARAMETERFILE\/spfile.273.583106111<\/p>\n

Now make an entry in the pfile, like below
\n[oracle@RAC2 dbs]$ cat initDEVEL.ora
\nspfile=’+DATA1\/DEVEL\/PARAMETERFILE\/spfile.273.583106111’
\n[oracle@RAC2 dbs]$<\/p>\n

so now all the\u00a0 DB files are stored in ASM.<\/p>\n

Please let me if you have some questions or doubts.<\/p>\n","protected":false},"excerpt":{"rendered":"

This is a sample document showing how to migrate Non ASM DB to ASM DB 1 create the ASM instance […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[424],"tags":[],"class_list":["post-1553","post","type-post","status-publish","format-standard","hentry","category-database"],"yoast_head":"\nMigrating Non ASM DB to ASM DB -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/03\/migrating-non-asm-db-to-asm-db\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Migrating Non ASM DB to ASM DB -\" \/>\n<meta property=\"og:description\" content=\"This is a sample document showing how to migrate Non ASM DB to ASM DB 1 create the ASM instance […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/03\/migrating-non-asm-db-to-asm-db\/\" \/>\n<meta property=\"article:published_time\" content=\"2010-03-03T05:15:46+00:00\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/onlineappsdba.com\\\/index.php\\\/2010\\\/03\\\/03\\\/migrating-non-asm-db-to-asm-db\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/onlineappsdba.com\\\/index.php\\\/2010\\\/03\\\/03\\\/migrating-non-asm-db-to-asm-db\\\/\"},\"author\":{\"name\":\"Masroof Ahmad\",\"@id\":\"https:\\\/\\\/onlineappsdba.com\\\/#\\\/schema\\\/person\\\/909a876ed58d400faf82caf81d61bfdb\"},\"headline\":\"Migrating Non ASM DB to ASM DB\",\"datePublished\":\"2010-03-03T05:15:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/onlineappsdba.com\\\/index.php\\\/2010\\\/03\\\/03\\\/migrating-non-asm-db-to-asm-db\\\/\"},\"wordCount\":1015,\"commentCount\":3,\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/onlineappsdba.com\\\/index.php\\\/2010\\\/03\\\/03\\\/migrating-non-asm-db-to-asm-db\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/onlineappsdba.com\\\/index.php\\\/2010\\\/03\\\/03\\\/migrating-non-asm-db-to-asm-db\\\/\",\"url\":\"https:\\\/\\\/onlineappsdba.com\\\/index.php\\\/2010\\\/03\\\/03\\\/migrating-non-asm-db-to-asm-db\\\/\",\"name\":\"Migrating Non ASM DB to ASM DB -\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/onlineappsdba.com\\\/#website\"},\"datePublished\":\"2010-03-03T05:15:46+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/onlineappsdba.com\\\/#\\\/schema\\\/person\\\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/onlineappsdba.com\\\/index.php\\\/2010\\\/03\\\/03\\\/migrating-non-asm-db-to-asm-db\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/onlineappsdba.com\\\/index.php\\\/2010\\\/03\\\/03\\\/migrating-non-asm-db-to-asm-db\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/onlineappsdba.com\\\/index.php\\\/2010\\\/03\\\/03\\\/migrating-non-asm-db-to-asm-db\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/onlineappsdba.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Migrating Non ASM DB to ASM DB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/onlineappsdba.com\\\/#website\",\"url\":\"https:\\\/\\\/onlineappsdba.com\\\/\",\"name\":\"\",\"description\":\"Oracle Implementation & Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/onlineappsdba.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/onlineappsdba.com\\\/#\\\/schema\\\/person\\\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\\\/\\\/onlineappsdba.com\\\/index.php\\\/author\\\/masroof\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Migrating Non ASM DB to ASM DB -","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:\/\/onlineappsdba.com\/index.php\/2010\/03\/03\/migrating-non-asm-db-to-asm-db\/","og_locale":"en_US","og_type":"article","og_title":"Migrating Non ASM DB to ASM DB -","og_description":"This is a sample document showing how to migrate Non ASM DB to ASM DB 1 create the ASM instance […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/03\/migrating-non-asm-db-to-asm-db\/","article_published_time":"2010-03-03T05:15:46+00:00","author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/03\/migrating-non-asm-db-to-asm-db\/#article","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/03\/migrating-non-asm-db-to-asm-db\/"},"author":{"name":"Masroof Ahmad","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"headline":"Migrating Non ASM DB to ASM DB","datePublished":"2010-03-03T05:15:46+00:00","mainEntityOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/03\/migrating-non-asm-db-to-asm-db\/"},"wordCount":1015,"commentCount":3,"articleSection":["Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/onlineappsdba.com\/index.php\/2010\/03\/03\/migrating-non-asm-db-to-asm-db\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/03\/migrating-non-asm-db-to-asm-db\/","url":"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/03\/migrating-non-asm-db-to-asm-db\/","name":"Migrating Non ASM DB to ASM DB -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"datePublished":"2010-03-03T05:15:46+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/03\/migrating-non-asm-db-to-asm-db\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2010\/03\/03\/migrating-non-asm-db-to-asm-db\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/03\/migrating-non-asm-db-to-asm-db\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Migrating Non ASM DB to ASM DB"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation & Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/1553","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=1553"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/1553\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=1553"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=1553"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=1553"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}