Next, start the database with NOMOUNT option and run the RMAN script convert_script.rcv RMAN>@convert_script.rcv Note what I that while it mentions the converted datafile as actually the file is created as – “+DATA/olap.dbf”, “+DATA/dev/datafile/olap.277.794979681” We had to take lines out of transport_script.sql and edit to include the correct ASM OMF file name. We then created a file called crectl.sql which had the following contents: crecctl.sql CREATE CONTROLFILE REUSE SET DATABASE "DEV" RESETLOGS FORCE LOGGING ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 5 MAXDATAFILES 512 MAXINSTANCES 8 MAXLOGHISTORY 7260 LOGFILE GROUP 1 ( '+DATA', '+DATA' ) SIZE 100M BLOCKSIZE 512, GROUP 2 ( '+DATA', '+DATA' ) SIZE 100M BLOCKSIZE 512, GROUP 3 ( '+DATA', '+DATA' ) SIZE 100M BLOCKSIZE 512, GROUP 4 ( '+DATA',
Next, start the database with NOMOUNT option and run the RMAN script convert_script.rcv RMAN>@convert_script.rcv Note – what I that while it mentions the converted datafile as “+DATA/olap.dbf”, actually the file is created as “+DATA/dev/datafile/olap.277.794979681” We had to take lines out of transport_script.sql and edit to include the correct ASM OMF file name. We then created a file called crectl.sql which had the following contents: crecctl.sql CREATE CONTROLFILE REUSE SET DATABASE "DEV" RESETLOGS FORCE LOGGING ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 5 MAXDATAFILES 512 MAXINSTANCES 8 MAXLOGHISTORY 7260 LOGFILE GROUP 1 ( '+DATA', '+DATA' ) SIZE 100M BLOCKSIZE 512, GROUP 2 ( '+DATA', '+DATA' ) SIZE 100M BLOCKSIZE 512, GROUP 3 ( '+DATA', '+DATA' ) SIZE 100M BLOCKSIZE 512, GROUP 4 ( '+DATA',
RMAN-32-bit-to-64-bit-migration-using-TRANSPORT-DATABASE1.docx