oracle11g windows迁移至linux

时间:2022-02-23 01:59:44

 

原创cube_six_hujw 最后发布于2018-03-02 11:46:06

概述:跨操作系统平台数据库迁移,windows to linux 步骤记录;

 

实验步骤:

(一)、linux平台安装好数据库软件及配置好监听;

(二)、备份windows数据库;

(三)、linux平台进行数据库恢复操作;

(四)、linux平台进行数据库恢复后的相关操作;

 

windows 备份数据库:

run {
configure device type disk parallelism 4;
backup database format ‘C:bakfull_%U‘;
 }

 

模拟数据库还在运行,多切换几个日志进行归档:

alter system switch logfile; (多次执行)

 

备份控制文件

alter database backup  controlfile to ‘C:bakctl.bak‘;

 

将备份文件、备份控制文件、全量的归档 传输与linux平台

 

linux平台进行恢复操作:

启动linux至nomount状态:

[[email protected] dbs]$ cat initcube.ora 
db_name=‘cube‘
memory_target=500M
processes = 150
audit_file_dest=‘/u01/ora/app/admin/cube/adump‘
audit_trail =‘db‘
db_block_size=8192
db_domain=‘‘
db_recovery_file_dest=‘/u01/ora/app/flash_recovery_area‘
db_recovery_file_dest_size=2G
diagnostic_dest=‘/u01/ora/app‘
dispatchers=‘(PROTOCOL=TCP) (SERVICE=ORCLXDB)‘
open_cursors=300 
remote_login_passwordfile=‘EXCLUSIVE‘
undo_tablespace=‘UNDOTBS1‘
control_files = (/u01/ora/app/data/control1.ctl, /u01/ora/app/data/control2.ctl)
compatible =‘11.2.0‘

 

恢复数据:

rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Fri Mar 2 03:09:56 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: CUBE (not mounted)

RMAN> restore controlfile from ‘/u01/ora/app/bak/CTL.BAK‘;

Starting restore at 02-MAR-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK


channel ORA_DISK_1: copied control file copy
output file name=/u01/ora/app/data/control1.ctl
output file name=/u01/ora/app/data/control2.ctl
Finished restore at 02-MAR-18

RMAN> sql ‘alter database mount‘;

sql statement: alter database mount

released channel: ORA_DISK_1

RMAN> catalog start with ‘/u01/ora/app/bak/‘;

Starting implicit crosscheck backup at 02-MAR-18
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=21 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=22 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=23 device type=DISK
Crosschecked 10 objects
Finished implicit crosscheck backup at 02-MAR-18


Starting implicit crosscheck copy at 02-MAR-18
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
Crosschecked 2 objects
Finished implicit crosscheck copy at 02-MAR-18


searching for all files in the recovery area
cataloging files...
no files cataloged


searching for all files that match the pattern /u01/ora/app/bak/


List of Files Unknown to the Database
=====================================
File Name: /u01/ora/app/bak/ARC0000000004_0968951521.0001
File Name: /u01/ora/app/bak/ARC0000000005_0968951521.0001
File Name: /u01/ora/app/bak/FULL_08SSP3N8_1_1
File Name: /u01/ora/app/bak/ARC0000000009_0968951521.0001
File Name: /u01/ora/app/bak/ARC0000000007_0968951521.0001
File Name: /u01/ora/app/bak/ARC0000000006_0968951521.0001
File Name: /u01/ora/app/bak/ARC0000000012_0968951521.0001
File Name: /u01/ora/app/bak/ARC0000000008_0968951521.0001
File Name: /u01/ora/app/bak/ARC0000000014_0968951521.0001
File Name: /u01/ora/app/bak/FULL_06SSP3N8_1_1
File Name: /u01/ora/app/bak/ARC0000000010_0968951521.0001
File Name: /u01/ora/app/bak/ARC0000000016_0968951521.0001
File Name: /u01/ora/app/bak/ARC0000000015_0968951521.0001
File Name: /u01/ora/app/bak/FULL_07SSP3N8_1_1
File Name: /u01/ora/app/bak/CTL.BAK
File Name: /u01/ora/app/bak/FULL_09SSP3N8_1_1
File Name: /u01/ora/app/bak/FULL_0ASSP3N9_1_1
File Name: /u01/ora/app/bak/ARC0000000013_0968951521.0001
File Name: /u01/ora/app/bak/ARC0000000011_0968951521.0001


Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done


List of Cataloged Files
=======================
File Name: /u01/ora/app/bak/ARC0000000004_0968951521.0001
File Name: /u01/ora/app/bak/ARC0000000005_0968951521.0001
File Name: /u01/ora/app/bak/FULL_08SSP3N8_1_1
File Name: /u01/ora/app/bak/ARC0000000009_0968951521.0001
File Name: /u01/ora/app/bak/ARC0000000007_0968951521.0001
File Name: /u01/ora/app/bak/ARC0000000006_0968951521.0001
File Name: /u01/ora/app/bak/ARC0000000012_0968951521.0001
File Name: /u01/ora/app/bak/ARC0000000008_0968951521.0001
File Name: /u01/ora/app/bak/ARC0000000014_0968951521.0001
File Name: /u01/ora/app/bak/FULL_06SSP3N8_1_1
File Name: /u01/ora/app/bak/ARC0000000010_0968951521.0001
File Name: /u01/ora/app/bak/ARC0000000016_0968951521.0001
File Name: /u01/ora/app/bak/ARC0000000015_0968951521.0001
File Name: /u01/ora/app/bak/FULL_07SSP3N8_1_1
File Name: /u01/ora/app/bak/CTL.BAK
File Name: /u01/ora/app/bak/FULL_09SSP3N8_1_1
File Name: /u01/ora/app/bak/FULL_0ASSP3N9_1_1
File Name: /u01/ora/app/bak/ARC0000000013_0968951521.0001
File Name: /u01/ora/app/bak/ARC0000000011_0968951521.0001


RMAN> report schema;

RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name CUBE


List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    0        SYSTEM               ***     C:DATAORADATACUBESYSTEM01.DBF
2    0        SYSAUX               ***     C:DATAORADATACUBESYSAUX01.DBF
3    0        UNDOTBS1             ***     C:DATAORADATACUBEUNDOTBS01.DBF
4    0        USERS                ***     C:DATAORADATACUBEUSERS01.DBF
5    0        CUBE                 ***     C:DATAORADATACUBECUBE01.DBF
6    0        CUBE                 ***     C:DATAORADATACUBECUBE02.DBF


List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       C:DATAORADATACUBETEMP01.DBF


RMAN> run{
 set newname for datafile 1    to    ‘/u01/ora/app/data/SYSTEM01.DBF‘;
 set newname for datafile 2    to   ‘/u01/ora/app/data/SYSAUX01.DBF‘;
set newname for datafile 3     to   ‘/u01/ora/app/data/UNDOTBS01.DBF‘;
set newname for datafile 4    to     ‘/u01/ora/app/data/USERS01.DBF‘;
 set newname for datafile 5     to    ‘/u01/ora/app/data/CUBE01.DBF‘;
set newname for datafile 6     to    ‘/u01/ora/app/data/CUBE02.DBF‘;
restore database;             
 switch datafile all;          

 

RMAN> recover database;

SQL> alter database open resetlogs;

Database altered.

SQL> select * from v$tempfile;

     FILE# CREATION_CHANGE# CREATION_        TS#     RFILE# STATUS  ENABLED
---------- ---------------- --------- ---------- ---------- ------- ----------
     BYTES     BLOCKS CREATE_BYTES BLOCK_SIZE
---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
         1           994247 24-FEB-18          3          1 ONLINE  READ WRITE
         0          0     20971520       8192
C:DATAORADATACUBETEMP01.DBF

SQL> create temporary tablespace temp1 tempfile ‘/u01/ora/app/data/temp1.dbf‘ size 500M;

Tablespace created.

SQL> alter database default temporary tablespace temp1;

Database altered.

SQL> drop tablespace temp including contents;

Tablespace dropped.

SQL>  select * from dba_temp_files;


FILE_NAME
--------------------------------------------------------------------------------
   FILE_ID TABLESPACE_NAME                     BYTES     BLOCKS STATUS
---------- ------------------------------ ---------- ---------- -------
RELATIVE_FNO AUT   MAXBYTES  MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
/u01/ora/app/data/temp1.dbf
         2 TEMP1                           524288000      64000 ONLINE
           1 NO           0          0            0  523239424       63872


SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/u01/ora/app/product/11.2.0/dbs/C:DATAORADATACUBEREDO03.LOG
/u01/ora/app/product/11.2.0/dbs/C:DATAORADATACUBEREDO02.LOG
/u01/ora/app/product/11.2.0/dbs/C:DATAORADATACUBEREDO01.LOG

SQL> select group#,thread#,status,sequence# from v$log;

    GROUP#    THREAD# STATUS            SEQUENCE#
---------- ---------- ---------------- ----------
         1          1 CURRENT                   1
         2          1 UNUSED                    0
         3          1 UNUSED                    0

SQL> select group#,thread# from v$log;

    GROUP#    THREAD#
---------- ----------
         1          1
         2          1
         3          1

SQL> select group#,member from v$logfile;

    GROUP#
----------
MEMBER
--------------------------------------------------------------------------------
         3
/u01/ora/app/product/11.2.0/dbs/C:DATAORADATACUBEREDO03.LOG

         2
/u01/ora/app/product/11.2.0/dbs/C:DATAORADATACUBEREDO02.LOG


         1
/u01/ora/app/product/11.2.0/dbs/C:DATAORADATACUBEREDO01.LOG


SQL> alter database add logfile group 4 ‘/u01/ora/app/data/redo01.log‘ size 50M;


Database altered.


SQL>  alter database add logfile group 5 ‘/u01/ora/app/data/redo02.log‘ size 50M;


Database altered.


SQL> alter database add logfile group 6 ‘/u01/ora/app/data/redo03.log‘ size 50M;


Database altered.


SQL> select group#,status from v$log;


    GROUP# STATUS
---------- ----------------
         1 CURRENT
         2 UNUSED
         3 UNUSED
         4 UNUSED
         5 UNUSED
         6 UNUSED


6 rows selected.

SQL> alter database drop logfile group 2;

Database altered.

SQL> alter database drop logfile group 3;


Database altered.


SQL> alter system switch logfile;


System altered.


SQL> select group#,status from v$log;


    GROUP# STATUS
---------- ----------------
         1 ACTIVE
         4 CURRENT
         5 UNUSED
         6 UNUSED

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ----------------
         1 ACTIVE
         4 CURRENT
         5 UNUSED
         6 UNUSED


SQL> alter system switch logfile;

System altered.

SQL> select group#,status from v$log;


    GROUP# STATUS
---------- ----------------
         1 ACTIVE
         4 ACTIVE
         5 CURRENT
         6 UNUSED


SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ----------------
         1 ACTIVE
         4 ACTIVE
         5 CURRENT
         6 UNUSED


SQL> alter system checkpoint;


System altered.

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ----------------
         1 INACTIVE
         4 INACTIVE
         5 CURRENT
         6 UNUSED


SQL>  alter database drop logfile group 1;


Database altered.


SQL> conn cube/cube
Connected.

SQL>  select count(*) from t1;

  COUNT(*)
----------
     74511

 

总结:至此windows 迁移至linux 异机恢复完成。

oracle11g windows迁移至linuxoracle11g windows迁移至linux cube_six_hujw 发布了65 篇原创文章 · 获赞 4 · 访问量 4万 私信 关注 展开阅