MIGRATION FROM WINDOWS TO LINUX(12.1.0.1 TO 19.0.0)

 

INSTALLED A DATABASE IN WINDOWS AND CHECKED THE PLATFORM NAME AND ENDIAN FORMAT

CREATED A USER AND CREATED A TABLE IN THE USER TO VERIFY AFTER MIGRATION

 

 

TO CHECK WHETHER EXTERNAL TABLES ARE AVAILABLE WE ARE DBMS_TDB.CHECK_EXTERNAL IF AVAILABLE WE NEED TO CREATE IT MANUALLY

 

 

SHUT THE DATABASE AND OPEN THE DATABASE IN READ ONLY MODE

 

 

RUN DBMS_TDB.CHECK_DB TO VERIFY WHETHER IT CAN BE MIGRATED

CREATE A FILE TO STORE THE TRANSPORT SCRIPT

IN RMAN CONVERT THE DATABASE AND GENERATED THE TRANSPORT SCRIPT AND ALSO INCLUDED DB_FILE_NAME_CONVERT FOR THE DATAFILES

 

CREATED A PFILE

 

CREATED THE REQUIRD DIRECTORY IN THE LINUX SERVER

MOVED THE GENERATED FILES TO THE CORRESPONDING DIRECTORIES

EDIT THE TRANSPORT SCRIPT WITH THE RESPECTIVE DIRECTORIES

 

EDIT THE PFILE WITH THE RESPECTIVE DIRECTORIES

RUN THE TRANSPORT SCRIPT

CHECKED THE TABLE WHETHER IT IS AVAILABLE OR NOT

 

 

Posted by:Sakthi sethu perumal S

Recommended Posts

Start typing and press Enter to search