在ORACLE11gR2上使用RMAN实现整库迁移

最新推荐文章于 2021-11-19 09:15:58 发布
最新推荐文章于 2021-11-19 09:15:58 发布
阅读量235 收藏
点赞数
文章标签： 数据库 网络

在ORACLE11gR2上使用RMAN实现整库迁移

背景：

数据库

IP

SID

端口

数据库版本

Target DB

192.168.1.133

orcl

1521

11.2.0.1.0

Auxiliary DB

192.168.1.133（可以是同一机器，也可以是不同机器）

V112

1522

11.2.0.1.0

 

1. 在Auxiliary 创建pfile 参数文件

 

[oracle@localhost dbs]$ pwd

/u01/oracle11gR2/product/11.2.0/db_1/dbs

[oracle@localhost dbs]$ more initv112.ora

*.DB_NAME=v112

*.control_files='/u01/oracle11gR2/oradata/v112/control01.ctl','/u01/oracle11gR2/flash_recovery_area

/v112/control02.ctl'

*.db_block_size=8192

*.compatible='11.2.0.1'

_compression_compatibility="11.2.0"   注：这个隐含参数可以绕过11.2.0.1的bug

*.db_recovery_file_dest_size=4294967296

*.db_recovery_file_dest='/u01/oracle11gR2/flash_recovery_area'

*.audit_file_dest='/u01/oracle11gR2/admin/v112/adump'

 

   

2. 在Auxiliary库上创建口令文件

[oracle@localhost dbs]$ pwd

/u01/oracle11gR2/product/11.2.0/db_1/dbs

[oracle@localhost dbs]$ orap

orapipe  orapki   orapwd   orapwdO 

[oracle@localhost dbs]$ orapwd file=orapwv112 password=Your password

   

3. 在Auxiliary库创建相关的目录结构

[oracle@localhost dbs]$ mkdir /u01/oracle11gR2/admin/v112/

[oracle@localhost dbs]$ mkdir /u01/oracle11gR2/oradata/v112/

 

注：在duplicate过程中，如果目录不存在，则会报错“ORA-27040: file create error, unable to create file”

 

4. 启动Auxiliary 到nomout 状态

 

SQL> conn / as sysdba;

Connected to an idle instance.

SQL> startup nomount pfile=‘/u01/oracle11gR2/product/11.2.0/db_1/dbs/initv112.ora’

ORACLE instance started.

Total System Global Area  146472960 bytes

Fixed Size                  1335080 bytes

Variable Size              92274904 bytes

Database Buffers           50331648 bytes

Redo Buffers                2531328 bytes

    

5. 在Target 和Auxiliary 都配置Oracle Net（Listener.ora and tnsnames.ora）[可选]

 

 

 

[oracle@localhost admin]$ more tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/oracle11gR2/product/11.2.0/db_1/network/admin/tnsna

mes.ora

# Generated by Oracle configuration tools.

v112 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.133)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = v112)

    )

  )

LISTENER_v112 =

  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.133)(PORT = 1521))

ORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.133)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SID_NAME = orcl

    )

  )

LISTENER_ORCL =

  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.133)(PORT = 1521))

 

[oracle@localhost admin]$ more listener.ora

# listener.ora Network Configuration File: /u01/oracle11gR2/product/11.2.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.133)(PORT = 1521))

    )

  )

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = v112)

      (ORACLE_HOME = /u01/oracle11gR2/product/11.2.0/db_1)

      (SID_NAME = v112)

    )

  )

 

LISTENER2 =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.133)(PORT = 1522))

    )

  )

 

SID_LIST_LISTENER2 =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = orcl)

      (ORACLE_HOME = /u01/oracle11gR2/product/11.2.0/db_1)

      (SID_NAME = orcl)

    )

  )

 

ADR_BASE_LISTENER1 = /u01/oracle11gR2

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

6. 开始RMAN duplicate from active database

 

 

[oracle@localhost temp]$ rman target sys/mxy19880122@192.168.1.133:1522/orcl auxiliary sys/mxy19880122@192.168.1.133:1521/v112

 

注:这里没有用tnsnames.ora文件中的配置。

 

Recovery Manager: Release 11.2.0.1.0 - Production on Sun Jun 3 17:31:11 2012

 

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

 

connected to target database: ORCL (DBID=1311170080)

connected to auxiliary database: V112 (not mounted)

 

RMAN> run{

set newname for datafile '/u01/oracle11gR2/oradata/orcl/system01.dbf' to

3>

'/u01/oracle11gR2/oradata/v112/system01.dbf';

 set newname for datafile '/u01/oracle11gR2/oradata/orcl/sysaux01.dbf' to

6>

'/u01/oracle11gR2/oradata/v112/sysaux01.dbf';

set newname for datafile '/u01/oracle11gR2/oradata/orcl/undotbs01.dbf' to

9>

'/u01/oracle11gR2/oradata/v112/undotbs01.dbf';

set newname for datafile '/u01/oracle11gR2/oradata/orcl/users01.dbf' to

11>

'/u01/oracle11gR2/oradata/v112/users01.dbf';

set newname for datafile

14> 15>

'/u01/oracle11gR2/oradata/orcl/ORCL/datafile/o1_mf_mxy_7v8tdctq_.dbf' to

17>

18> '/u01/oracle11gR2/oradata/v112/mxy.dbf';

19> duplicate target database to V112 from active database nofilenamecheck;}

 

executing command: SET NEWNAME

 

executing command: SET NEWNAME

 

executing command: SET NEWNAME

 

executing command: SET NEWNAME

 

executing command: SET NEWNAME

 

注：由于RMAN需要将文件恢复到新的位置，因此需要对文件进行重新映射。

 

Starting Duplicate Db at 03-JUN-12

using target database control file instead of recovery catalog

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=20 device type=DISK

 

contents of Memory Script.:

{

   sql clone "create spfile from memory";

}

executing Memory Script

 

sql statement: create spfile from memory

 

contents of Memory Script.:

{

   shutdown clone immediate;

   startup clone nomount;

}

executing Memory Script

 

注：恢复spfile

 

Oracle instance shut down

 

connected to auxiliary database (not started)

Oracle instance started

 

Total System Global Area     217157632 bytes

 

Fixed Size                     2211928 bytes

Variable Size                159387560 bytes

Database Buffers              50331648 bytes

Redo Buffers                   5226496 bytes

 

contents of Memory Script.:

{

   sql clone "alter system set  db_name =

 ''ORCL'' comment=

 ''Modified by RMAN duplicate'' scope=spfile";

   sql clone "alter system set  db_unique_name =

 ''V112'' comment=

 ''Modified by RMAN duplicate'' scope=spfile";

   shutdown clone immediate;

   startup clone force nomount

   backup as copy current controlfile auxiliary format  '/u01/oracle11gR2/oradata/v112/control01.ctl';

   restore clone controlfile to  '/u01/oracle11gR2/flash_recovery_area/v112/control02.ctl' from

 '/u01/oracle11gR2/oradata/v112/control01.ctl';

   alter clone database mount;

}

executing Memory Script

 

注：恢复控制文件

 

sql statement: alter system set  db_name =  ''ORCL'' comment= ''Modified by RMAN duplicate'' scope=spfile

 

sql statement: alter system set  db_unique_name =  ''V112'' comment= ''Modified by RMAN duplicate'' scope=spfile

 

注：重新设置db_name

 

Oracle instance shut down

 

Oracle instance started

 

Total System Global Area     217157632 bytes

 

Fixed Size                     2211928 bytes

Variable Size                159387560 bytes

Database Buffers              50331648 bytes

Redo Buffers                   5226496 bytes

 

Starting backup at 03-JUN-12

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=34 device type=DISK

channel ORA_DISK_1: starting datafile copy

copying current control file

output file name=/u01/oracle11gR2/product/11.2.0/db_1/dbs/snapcf_orcl.f tag=TAG20120603T173213 RECID=1 STAMP=785007137

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:08

Finished backup at 03-JUN-12

 

Starting restore at 03-JUN-12

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=18 device type=DISK

 

channel ORA_AUX_DISK_1: copied control file copy

Finished restore at 03-JUN-12

 

database mounted

 

contents of Memory Script.:

{

   set newname for datafile  1 to

 "/u01/oracle11gR2/oradata/v112/system01.dbf";

   set newname for datafile  2 to

 "/u01/oracle11gR2/oradata/v112/sysaux01.dbf";

   set newname for datafile  3 to

 "/u01/oracle11gR2/oradata/v112/undotbs01.dbf";

   set newname for datafile  4 to

 "/u01/oracle11gR2/oradata/v112/users01.dbf";

   set newname for datafile  5 to

 "/u01/oracle11gR2/oradata/v112/mxy.dbf";

   backup as copy reuse

   datafile  1 auxiliary format

 "/u01/oracle11gR2/oradata/v112/system01.dbf"   datafile

 2 auxiliary format

 "/u01/oracle11gR2/oradata/v112/sysaux01.dbf"   datafile

 3 auxiliary format

 "/u01/oracle11gR2/oradata/v112/undotbs01.dbf"   datafile

 4 auxiliary format

 "/u01/oracle11gR2/oradata/v112/users01.dbf"   datafile

 5 auxiliary format

 "/u01/oracle11gR2/oradata/v112/mxy.dbf"   ;

   sql 'alter system archive log current';

}

executing Memory Script

 

executing command: SET NEWNAME

 

executing command: SET NEWNAME

 

executing command: SET NEWNAME

 

executing command: SET NEWNAME

 

executing command: SET NEWNAME

 

注：开始恢复数据文件（耐心等待）

Starting backup at 03-JUN-12

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile copy

input datafile file number=00001 name=/u01/oracle11gR2/oradata/orcl/system01.dbf

output file name=/u01/oracle11gR2/oradata/v112/system01.dbf tag=TAG20120603T173229

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:05

channel ORA_DISK_1: starting datafile copy

input datafile file number=00002 name=/u01/oracle11gR2/oradata/orcl/sysaux01.dbf

output file name=/u01/oracle11gR2/oradata/v112/sysaux01.dbf tag=TAG20120603T173229

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:06

channel ORA_DISK_1: starting datafile copy

input datafile file number=00003 name=/u01/oracle11gR2/oradata/orcl/undotbs01.dbf

output file name=/u01/oracle11gR2/oradata/v112/undotbs01.dbf tag=TAG20120603T173229

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:06

channel ORA_DISK_1: starting datafile copy

input datafile file number=00004 name=/u01/oracle11gR2/oradata/orcl/users01.dbf

output file name=/u01/oracle11gR2/oradata/v112/users01.dbf tag=TAG20120603T173229

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45

channel ORA_DISK_1: starting datafile copy

input datafile file number=00005 name=/u01/oracle11gR2/oradata/orcl/ORCL/datafile/o1_mf_mxy_7v8tdctq_.dbf

output file name=/u01/oracle11gR2/oradata/v112/mxy.dbf tag=TAG20120603T173229

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25

Finished backup at 03-JUN-12

 

sql statement: alter system archive log current

 

contents of Memory Script.:

{

   backup as copy reuse

   archivelog like  "/u01/oracle11gR2/flash_recovery_area/ORCL/archivelog/2012_06_03/o1_mf_1_291_7wpd7h5x_.arc" auxiliary format

 "/u01/oracle11gR2/flash_recovery_area/V112/archivelog/2012_06_03/o1_mf_1_291_%u_.arc"   ;

   catalog clone recovery area;

   switch clone datafile all;

}

executing Memory Script

 

Starting backup at 03-JUN-12

using channel ORA_DISK_1

channel ORA_DISK_1: starting archived log copy

input archived log thread=1 sequence=291 RECID=176 STAMP=785007599

output file name=/u01/oracle11gR2/flash_recovery_area/V112/archivelog/2012_06_03/o1_mf_1_291_0hnckgvg_.arc RECID=0 STAMP=0

channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01

Finished backup at 03-JUN-12

 

searching for all files in the recovery area

 

List of Files Unknown to the Database

=====================================

File Name: /u01/oracle11gR2/flash_recovery_area/V112/archivelog/2012_06_03/o1_mf_1_291_0hnckgvg_.arc

cataloging files...

cataloging done

 

List of Cataloged Files

=======================

File Name: /u01/oracle11gR2/flash_recovery_area/V112/archivelog/2012_06_03/o1_mf_1_291_0hnckgvg_.arc

 

datafile 1 switched to datafile copy

input datafile copy RECID=1 STAMP=785007602 file name=/u01/oracle11gR2/oradata/v112/system01.dbf

datafile 2 switched to datafile copy

input datafile copy RECID=2 STAMP=785007602 file name=/u01/oracle11gR2/oradata/v112/sysaux01.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=3 STAMP=785007602 file name=/u01/oracle11gR2/oradata/v112/undotbs01.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=4 STAMP=785007602 file name=/u01/oracle11gR2/oradata/v112/users01.dbf

datafile 5 switched to datafile copy

input datafile copy RECID=5 STAMP=785007602 file name=/u01/oracle11gR2/oradata/v112/mxy.dbf

 

contents of Memory Script.:

{

   set until scn  6603687;

   recover

   clone database

    delete archivelog

   ;

}

executing Memory Script

 

executing command: SET until clause

 

Starting recover at 03-JUN-12

using channel ORA_AUX_DISK_1

 

starting media recovery

 

archived log for thread 1 with sequence 291 is already on disk as file /u01/oracle11gR2/flash_recovery_area/V112/archivelog/2012_06_03/o1_mf_1_291_0hnckgvg_.arc

archived log file name=/u01/oracle11gR2/flash_recovery_area/V112/archivelog/2012_06_03/o1_mf_1_291_0hnckgvg_.arc thread=1 sequence=291

media recovery complete, elapsed time: 00:00:01

Finished recover at 03-JUN-12

 

contents of Memory Script.:

{

   shutdown clone immediate;

   startup clone nomount;

   sql clone "alter system set  db_name =

 ''V112'' comment=

 ''Reset to original value by RMAN'' scope=spfile";

   sql clone "alter system reset  db_unique_name scope=spfile";

   shutdown clone immediate;

   startup clone nomount;

}

executing Memory Script

 

database dismounted

Oracle instance shut down

 

connected to auxiliary database (not started)

Oracle instance started

 

Total System Global Area     217157632 bytes

 

Fixed Size                     2211928 bytes

Variable Size                159387560 bytes

Database Buffers              50331648 bytes

Redo Buffers                   5226496 bytes

 

sql statement: alter system set  db_name =  ''V112'' comment= ''Reset to original value by RMAN'' scope=spfile

 

sql statement: alter system reset  db_unique_name scope=spfile

 

Oracle instance shut down

 

connected to auxiliary database (not started)

Oracle instance started

 

Total System Global Area     217157632 bytes

 

Fixed Size                     2211928 bytes

Variable Size                159387560 bytes

Database Buffers              50331648 bytes

Redo Buffers                   5226496 bytes

sql statement: CREATE CONTROLFILE REUSE SET DATABASE "V112" RESETLOGS ARCHIVELOG

  MAXLOGFILES     16

  MAXLOGMEMBERS      3

  MAXDATAFILES      100

  MAXINSTANCES     8

  MAXLOGHISTORY      292

 LOGFILE

  GROUP  1  SIZE 50 M ,

  GROUP  2  SIZE 50 M ,

  GROUP  3  SIZE 50 M

 DATAFILE

  '/u01/oracle11gR2/oradata/v112/system01.dbf'

 CHARACTER SET AL32UTF8

 

 

contents of Memory Script.:

{

   set newname for tempfile  1 to

 "/u01/oracle11gR2/oradata/orcl/temp01.dbf";

   set newname for tempfile  2 to

 "/u01/oracle11gR2/oradata/orcl/ORCL/datafile/o1_mf_temp1_7vb4dcv5_.tmp";

   set newname for tempfile  3 to

 "/u01/oracle11gR2/oradata/orcl/ORCL/datafile/o1_mf_temp2_7vb4djq8_.tmp";

   switch clone tempfile all;

   catalog clone datafilecopy  "/u01/oracle11gR2/oradata/v112/sysaux01.dbf",

 "/u01/oracle11gR2/oradata/v112/undotbs01.dbf",

 "/u01/oracle11gR2/oradata/v112/users01.dbf",

 "/u01/oracle11gR2/oradata/v112/mxy.dbf";

   switch clone datafile all;

}

executing Memory Script

 

executing command: SET NEWNAME

 

executing command: SET NEWNAME

 

executing command: SET NEWNAME

 

renamed tempfile 1 to /u01/oracle11gR2/oradata/orcl/temp01.dbf in control file

renamed tempfile 2 to /u01/oracle11gR2/oradata/orcl/ORCL/datafile/o1_mf_temp1_7vb4dcv5_.tmp in control file

renamed tempfile 3 to /u01/oracle11gR2/oradata/orcl/ORCL/datafile/o1_mf_temp2_7vb4djq8_.tmp in control file

 

cataloged datafile copy

datafile copy file name=/u01/oracle11gR2/oradata/v112/sysaux01.dbf RECID=1 STAMP=785007628

cataloged datafile copy

datafile copy file name=/u01/oracle11gR2/oradata/v112/undotbs01.dbf RECID=2 STAMP=785007628

cataloged datafile copy

datafile copy file name=/u01/oracle11gR2/oradata/v112/users01.dbf RECID=3 STAMP=785007628

cataloged datafile copy

datafile copy file name=/u01/oracle11gR2/oradata/v112/mxy.dbf RECID=4 STAMP=785007628

 

datafile 2 switched to datafile copy

input datafile copy RECID=1 STAMP=785007628 file name=/u01/oracle11gR2/oradata/v112/sysaux01.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=2 STAMP=785007628 file name=/u01/oracle11gR2/oradata/v112/undotbs01.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=3 STAMP=785007628 file name=/u01/oracle11gR2/oradata/v112/users01.dbf

datafile 5 switched to datafile copy

input datafile copy RECID=4 STAMP=785007628 file name=/u01/oracle11gR2/oradata/v112/mxy.dbf

 

contents of Memory Script.:

{

   Alter clone database open resetlogs;

}

executing Memory Script

 

database opened

Finished Duplicate Db at 03-JUN-12

 

RMAN> exit

 

7. 复制结束

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22700344/viewspace-732178/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22700344/viewspace-732178/

畅卓科技
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
使用RMAN工具跨平台迁移数据库图解
03-31
使用RMAN工具跨平台迁移数据库
oracle迁移 rman,ORACLE RMAN迁移
weixin_42460182的博客
04-14 445
1.进入RMANrman target /2.关闭目标数据库shutdown immediate3.创建原始参数文件任意路径均可, 下面会用到*.audit_file_dest='C:\app\Administrator\admin\orcl\adump'*.audit_trail='db'*.compatible='11.2.0.4.0'*.control_files='C:\app\Adm...
oracle迁移数据库 rman,Oracle数据库迁移之一：RMAN
weixin_39947501的博客
04-03 302
.channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01Finished backup at 06-APR-144.查看备份情况，删除冗余备份RMAN> list backup;List of Backup Sets===================BS Key Size Device Type Ela...
oracle数据库迁移存储方案
谢可爱在学习的博客
11-19 2283
一、RAC数据库迁移方案 oracle rac主要分为两部分：数据磁盘组和OCR磁盘组。 迁移原理：利用ASM rebalance特性进行存储迁移。 停机窗口：在线完成，无需停机。 具体步骤： 1、利用rman备份数据库 全备脚本 #这个是rman全备shell脚本 #date 2019-02-27 #定义全局变量ORACLE_SID、ORACLE_HOME、ORACLE_BASE、NLS_LANG export ORACLE_SID=or11g export ORACLE_HOME=/u01/app/
oracle迁移数据库 rman,通过rman全库备份迁移数据库
weixin_29912855的博客
04-03 771
这一篇文章中，将讲述通过一个rman的完整全库备份来作数据库的迁移。(使用的备份在上一篇博文中：http://blog.itpub.net/31392094/viewspace-2128466/)---设备：主机：oracle(HOST = 192.168.2.4)作为A库：target database: ORA11GR2 (DBID=238796283)主机：enmo(HOST = 192....
Oracle 11gR2 使用RMAN 复制搭建物理Data Guard
10-09
大牛出手，全是干货，Oracle 11gR2 使用RMAN 复制搭建物理Data Guard。 注：文档打开密码见压缩包注释
Oracle 11.2.0.3 单实例 迁移到 11gR2 RAC 案例-- 使用RMAN 异机恢复
10-08
Oracle 11.2.0.3 单实例 迁移到 11gR2 RAC 案例-- 使用RMAN 异机恢复 注：文档打开密码见压缩包注释
Oracle 11gR2 RMAN 官方参考手册
03-26
Oracle 11gR2 RMAN 官方参考手册
Oracle 11.2.0.3 单实例 迁移到 11gR2 RAC 案例- 使用RMAN 异机恢复
04-20
Oracle 11.2.0.3 单实例 迁移到 11gR2 RAC 案例-- 使用RMAN 异机恢复
Oracle-使用RMAN从10g直接迁移到11G
08-11
Oracle-使用RMAN-将-DB-从10g-直接-Restore-到11g-示例
Oracle 11g RMAN备份异机恢复 迁移数据 案例.
10-03
大牛总结的文档，全是干货！ Rman的异机恢复的作用很多，比如数据库迁移，数据库恢复，基于数据库架构调整的还原恢复(比如从RAC-->>单实例，ASM-->>文件系统)，有时候搭建测试环境也会用到，不过，这种情况下相信选择数据库复制方式比较方便。 文档打开密码见压缩包注释。
Oracle 利用RMAN 完成数据迁移
weixin_33671935的博客
12-12 738
整体流程：对A机的数据库来一个热备，并且是一个全备，然后通过scp命令把备份传到B机，然后把A库停掉（注意关库不会触发归档），之后再把归档日志和redo日志传给B机，最后再在B库上 restore 和recover数据文件，控制文件，参数文件 的恢复过程：根据数据库的启动流程，可以知道最先读取数据文件，所以应该先还原参数文件，然后会读控制文件，所以你要...
数据库迁移方案之DG方式迁移
weixin_34419326的博客
04-09 818
一：环境信息1)主库（单实例）主机平台：AIX6.1数据库版本：11.2.0.3（psu5）2)备库（部署了crs）主机平台：AIX6.1数据库版本：11.2.0.3（psu5）二：方案背景由于业务量增加，数据库需要由单实例，改成两节点rac。为了减少停机时间，采用DG方式迁移。三迁移方案：1.检查数据库是否支持DataGuard（只有企业版才支持DG）SQL> ...
oracle的rman异机迁移
mtb的博客
07-03 1063
1.查看数据库是否处于归档模式：SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log ...
使用RMAN迁移数据库到异机
热门推荐
乐沙弥的世界
10-16 2万+
迁移数据库的方法有多种，较为常用的则是使用RMAN来迁移。使用RMAN迁移数据库属于数据库的物理备份与恢复范畴，整个过程中数据库的相关信息是完整地镜像。因此，基于此种方式还原恢复的数据库用于测试会使得与真实的生产环境差异相对较小。本文描述了使用RMAN来还原Oracle 10g数据库的过程。 一、主要步骤     1、备份数据库     2、ftp备份到目的服务器     3、为目标数据库创建项目
oracle迁移 rman,在Oracle11gR2上使用RMAN实现整库迁移
weixin_35034536的博客
04-14 308
在Oracle 11gR2上使用RMAN实现整库迁移 背景： 数据库 IP SID 端口 数据库版本 Target DB 192.168.1.133 orcl 152在Oracle 11gR2上使用RMAN实现整库迁移背景：数据库IPSID端口数据库版本Target DB192.168.1.133orcl152111.2.0.1.0Auxiliary DB192.168.1.133(可以是同一机器...
oracle运维之--RMAN 异构平台迁移（修改中）
11-04 5864
 如题: 最近公司有个项目中涉及了数据迁移的问题: 源库的环境是:redhat as 4  oracle 10.2.0.1(64位)单实例 (裸设备) ,硬件平台(IBM X3650) 目标库是:aix 5.3 . oracle 10.2.0.4(64位) RAC (裸设备)  ,硬件平台 (IBM P595) 数据量有700个G左右 想用rman 来做迁移,把源库的数据迁移到目标库上去. 请高手
Oracle Study之--Oracle 11gR2通过RMAN克隆数据库
天涯客*Blog
03-25 2209
Oracle Study之--Oracle 11gR2通过RMAN克隆数据库 Purpose of Database Duplication A duplicate database is useful for a variety of purposes, most of which involve testing. You can perform the following tasks
oracle整库迁移到新机器
最新发布
05-12
4. 恢复备份文件：在新服务器上使用 Oracle RMAN 工具恢复备份文件到目标数据库。 5. 更新目标数据库的配置：在目标数据库上更新数据库配置，例如监听器、参数文件等。 6. 测试目标数据库：在目标数据库上执行测试...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值