Shulou(Shulou.com)06/01 Report--

This article mainly introduces "how to migrate the Oracle under the windows to the Linux platform". In the daily operation, I believe that many people have doubts about how to migrate from the Oracle under the windows to the Linux platform. The editor consulted all kinds of materials and sorted out a simple and easy-to-use method of operation. I hope it will be helpful to answer the question of "how to migrate the Oracle under the windows to the Linux platform". Next, please follow the editor to study!

Environment:

The source library is 11.2.0.1 under the win platform.

The target library is 11.2.0.4 under redhat6.10.

Steps:

First create the system on the target server, install the database software, and then do a complete job on the source database side, create a pfile file, and transfer it to the target server.

Edit the Pfile first, because the hardware setting of my target environment is similar to that of the source environment, so I haven't changed the pfile, and the production environment will be adjusted according to the actual situation.

Then go to sql and boot to nomout according to the modified pfile.

-- alter session set nls_language=american

SYS@orcl > startup nomount pfile='/xie/INITorcl.ORA'

After startup, go to rman to recover the control files.

RMAN > restore controlfile from'/ xie/C-1534390551-20190426-01'

Boot to Mount after recovery is complete

RMAN > sql 'alter database mount'

Because the backup is recorded in the source database environment, but not in the target environment, just do a check

RMAN > crosscheck backup

RMAN > delete expired backup

Then register the copied backup in rman

RMAN > catalog start with'/ xie/'

Then restore:

RMAN > run {

RMAN > set newname for database to'/ u01Accord oradataAccord oradataAccording to orclip dbftogether% U'

RMAN > restore database

RMAN >}

Switch to write the new path to the control file

RMAN > switch database to copy

And then recover

RMAN > recover database

Open the database and use the resetlogs upgrade parameter to rebuild the redo file

SQL > alter database open resetlogs upgrade

Generate spfile by the way

SQL > create spfile from pfile='/xie/INITorcl.ORA'

Because the temp data file is not protected by RMAN, you need to check tempfile:

SQL > col name for A50

SQL > select a.ts# "TAB_NUM", t.name "TAB_NAME", a.name "TAB_DIR" from gv_$tempfile a minute tablespace t where t.ts#=a.ts#

SQL > create temporary tablespace temp1 tempfile'/ u01 size size 1024m

SQL > alter database default temporary tablespace temp1

Invalid including contents found by SQL > drop tablespace

SQL > select * from dba_temp_files

Recompile:

SQL > @? / rdbms/admin/utlrp.sql

Update the data dictionary

SQL > @? / rdbms/admin/catupgrd.sql

And then start.

Complete

At this point, the study on "how to migrate Oracle under windows to Linux platform" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.