oracle 10g通过 RMAN 克隆数据库（duplicate）

最新推荐文章于 2024-09-14 19:55:29 发布
最新推荐文章于 2024-09-14 19:55:29 发布
阅读量184 收藏
点赞数
文章标签： 数据库 网络 操作系统

1 、做一些操作便于克隆后的验证
14:10:17 SYS@ prod>conn scott/tiger
Connected.
14:10:21 SCOTT@ prod>create table emp1 as select * from emp;

2 、备份目标数据库
[oracle@rh55 ~]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jul 21 14:14:23 2015
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: PROD (DBID=199802235)
//备份全库，所有的归档，当前的控制文件
RMAN> run{
2> allocate channel c1 type disk;
3> allocate channel c2 type disk;
4> backup full database format '/disk1/rman/%d_%s_%t.bak';
5> backup archivelog all format '/disk1/rman/arch_%s.bak';
6> backup current controlfile format '/disk1/rman/ctl_%s.bak';
7> }


3 、查看目标库数据文件存放信息
16:11:46 SYS@ prod>col member for a50
16:15:35 SYS@ prod>select GROUP#,MEMBER from v$logfile; // 查看目标库日志文件存放位置
GROUP# MEMBER
---------- --------------------------------------------------
3 /disk1/oradata/prod/redo03a.log
2 /disk1/oradata/prod/redo02a.log
1 /disk1/oradata/prod/redo01a.log
1 /disk2/oradata/prod/redolog01b.log
2 /disk2/oradata/prod/redolog02b.log
3 /disk2/oradata/prod/redolog03b.log
6 rows selected.
// 查看每个日志文件的大小
16:29:21 SYS@ prod>select GROUP#,THREAD#,SEQUENCE#,STATUS,BYTES/1024/1024 from v$log;
GROUP# THREAD# SEQUENCE# STATUS BYTES/1024/1024
---------- ---------- ---------- ---------------- ---------------
1 1 29 INACTIVE 50
2 1 30 CURRENT 50
3 1 28 INACTIVE 50
//查看目标库数据文件存放位置
16:15:42 SYS@ prod>col FILE_NAME for a50
16:16:01 SYS@ prod>select FILE_ID,FILE_NAME,TABLESPACE_NAME from dba_data_files;
FILE_ID FILE_NAME TABLESPACE_NAME
---------- -------------------------------------------------- ----------------
4 /u01/app/oracle/oradata/prod/users01.dbf USERS
3 /u01/app/oracle/oradata/prod/sysaux01.dbf SYSAUX
2 /u01/app/oracle/oradata/prod/undotbs01.dbf UNDOTBS1
1 /u01/app/oracle/oradata/prod/system01.dbf SYSTEM
5 /u01/app/oracle/oradata/prod/example01.dbf EXAMPLE
8 /u01/app/oracle/oradata/prod/test3.dbf TEST3


4 、配置辅助库参数
14:25:03 SYS@ prod>show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /u01/app/oracle/product/10.2.0
/db_1/dbs/spfileprod.ora
14:25:10 SYS@ prod>exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@rh55 ~]$ cd /u01/app/oracle/product/10.2.0/db_1/dbs/
[oracle@rh55 dbs]$ ls
alert_prod.log c-199802235-20120812-22 hc_test1.dat inittest1.ora orapwcatdb
spfilecatdb.ora
alert_test1.log c-199802235-20120822-04 initdw.ora lkCATDB orapwprod
spfileprod.ora
c-199802235-20120812-1d hc_catdb.dat init.ora lkPROD orapwtest1
spfiletest1.ora
c-199802235-20120812-20 hc_prod.dat initprod.ora lkTEST1
snapcf_prod.f
[oracle@rh55 dbs]$ cp initprod.ora initclprod.ora
[oracle@rh55 dbs]$ vi initclprod.ora
%s/prod/clprod 将所有的 prod 替换为 clprod，修改所有相关目录，最后加上两句话

db_file_name_convert=('/u01/app/oracle/oradata/prod','/u01/database/clprod/oradata/')
log_file_name_convert=('/disk1/oradata/prod/','/u01/database/clprod/redo','/disk2/oradata/
prod','/u01/database/clprod/redo')


5 、创建相应的 dump  文件夹

[oracle@rh55 ~]$ mkdir -p /u01/database
[oracle@rh55 ~]$ mkdir -p /u01/database/clprod/adump
[oracle@rh55 ~]$ mkdir -p /u01/database/clprod/flash_recovery_area
[oracle@rh55 ~]$ mkdir -p /u01/database/clprod/oradata
[oracle@rh55 ~]$ mkdir -p /u01/database/clprod/redo
[oracle@rh55 ~]$ mkdir -p /u01/database/clprod/pfile
[oracle@rh55 ~]$ mkdir -p /u01/database/clprod/bdump
[oracle@rh55 ~]$ mkdir -p /u01/database/clprod/cdump
[oracle@rh55 ~]$ mkdir -p /u01/database/clprod/udump
[oracle@rh55 ~]$ mkdir -p /u01/database/clprod/logmnr




6 、生成辅助实例密码文件 （两个库密码最好相同）
[oracle@rh55 dbs]$ orapwd file=$ORACLE_HOME/dbs/orapwclprod password=oracle entries=10



7 、启动辅助库到 nomount  状态
[oracle@rh55 dbs]$ export ORACLE_SID=clprod
[oracle@rh55 dbs]$ !sql
sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 21 15:32:45 2015
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
15:32:45 SYS@ clprod>startup nomount
pfile=/u01/app/oracle/product/10.2.0/db_1/dbs/initclprod.ora;
ORACLE instance started.
Total System Global Area 272629760 bytes
Fixed Size 1218944 bytes
Variable Size 67110528 bytes
Database Buffers 201326592 bytes
Redo Buffers 2973696 bytes



8 、配置监听
[oracle@rh55 ~]$ cd /u01/app/oracle/product/10.2.0/db_1/network/admin/
[oracle@rh55 admin]$ ls
listener.ora samples shrept.lst sqlnet.log tnsnames.ora
[oracle@rh55 admin]$ cat listener.ora


# listener.ora Network Configuration File:
/u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rh55)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
LISTENER_CLPROD =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.48)(PORT = 1521))
)
)
LISTENER_PROD =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rh55)(PORT = 1521))
)
)
[oracle@rh55 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File:
/u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
PROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rh55)(PORT = 1521)

)
(CONNECT_DATA =
(SERVICE_NAME = prod)
)
)
CLPROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.48)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = clprod)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
[oracle@rh55 admin]$ lsnrctl start // 启动监听
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 22-JUL-2015 10:06:24
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rh55)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rh55)(PORT=1521)))
STATUS of the LISTENER
-----------------------

Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 22-JUL-2015 10:06:24
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rh55)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully



9 、用 RMAN  克隆数据库
[oracle@rh55 admin]$ !exp
export ORACLE_SID=clprod
[oracle@rh55 dbs]$ rman target sys/oracle@prod auxiliary sys/oracle // 连接目标库和辅助库
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jul 21 19:34:57 2015
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: PROD (DBID=199802235)
connected to auxiliary database: CLPROD (not mounted)
RMAN> duplicate target database to clprod;
Starting Duplicate Db at 21-JUL-15
using target database control file instead of recovery catalog // 使用原数据库的控制文件
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=156 devtype=DISK
contents of Memory Script:
{
set until scn 2865854;
set newname for datafile 1 to
"/u01/database/clprod/oradata//system01.dbf";
set newname for datafile 2 to
"/u01/database/clprod/oradata//undotbs01.dbf";

set newname for datafile 3 to
"/u01/database/clprod/oradata//sysaux01.dbf";
set newname for datafile 4 to
"/u01/database/clprod/oradata//users01.dbf";
set newname for datafile 5 to
"/u01/database/clprod/oradata//example01.dbf";
set newname for datafile 8 to
"/u01/database/clprod/oradata//test3.dbf";
restore
check readonly
clone database
;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 21-JUL-15 // 开始 restore 数据文件
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/database/clprod/oradata/system01.dbf
restoring datafile 00004 to /u01/database/clprod/oradata/users01.dbf
restoring datafile 00008 to /u01/database/clprod/oradata/test3.dbf
channel ORA_AUX_DISK_1: reading from backup piece /disk1/rman/PROD_410_885671332.bak
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/disk1/rman/PROD_410_885671332.bak tag=TAG20150721T194851
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:26
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /u01/database/clprod/oradata/undotbs01.dbf

restoring datafile 00003 to /u01/database/clprod/oradata/sysaux01.dbf
restoring datafile 00005 to /u01/database/clprod/oradata/example01.dbf
channel ORA_AUX_DISK_1: reading from backup piece /disk1/rman/PROD_411_885671332.bak
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/disk1/rman/PROD_411_885671332.bak tag=TAG20150721T194851
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:25
Finished restore at 21-JUL-15
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "CLPROD" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 715
LOGFILE
GROUP 1 ( '/u01/database/clprod/redoredo01a.log',
'/u01/database/clprod/redo/redolog01b.log' ) SIZE 50 M REUSE,
GROUP 2 ( '/u01/database/clprod/redo/redolog02b.log',
'/u01/database/clprod/redoredo02a.log' ) SIZE 50 M REUSE,
GROUP 3 ( '/u01/database/clprod/redo/redolog03b.log',
'/u01/database/clprod/redoredo03a.log' ) SIZE 50 M REUSE
DATAFILE
'/u01/database/clprod/oradata/system01.dbf'
CHARACTER SET ZHS16GBK
contents of Memory Script: // 下面的脚本是将新的数据文件全部更新到控制文件
{
switch clone datafile all;
}
executing Memory Script
released channel: ORA_AUX_DISK_1
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=885671689
filename=/u01/database/clprod/oradata/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=885671689
filename=/u01/database/clprod/oradata/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=885671689 filename=/u01/database/clprod/oradata/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=885671689
filename=/u01/database/clprod/oradata/example01.dbf
datafile 8 switched to datafile copy

input datafile copy recid=5 stamp=885671689 filename=/u01/database/clprod/oradata/test3.dbf
contents of Memory Script: // 下面脚本 oracle 自动设置了 scn 后发布 recover 命令
{
set until scn 2865854;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 21-JUL-15
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=156 devtype=DISK // 下面使用 archivelog 进行 recover
starting media recovery
archive log thread 1 sequence 30 is already on disk as file /disk1/arch1/arch_1_30_797613178.log
archive log filename=/disk1/arch1/arch_1_30_797613178.log thread=1 sequence=30
media recovery complete, elapsed time: 00:00:01
Finished recover at 21-JUL-15
contents of Memory Script: // 重新启动库到 nomount 状态
{
shutdown clone;
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 272629760 bytes
Fixed Size 1218944 bytes
Variable Size 67110528 bytes
Database Buffers 201326592 bytes

sql statement: CREATE CONTROLFILE REUSE SET DATABASE "CLPROD" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 715
LOGFILE
GROUP 1 ( '/u01/database/clprod/redoredo01a.log',
'/u01/database/clprod/redo/redolog01b.log' ) SIZE 50 M REUSE,
GROUP 2 ( '/u01/database/clprod/redo/redolog02b.log',
'/u01/database/clprod/redoredo02a.log' ) SIZE 50 M REUSE,
GROUP 3 ( '/u01/database/clprod/redo/redolog03b.log',
'/u01/database/clprod/redoredo03a.log' ) SIZE 50 M REUSE
DATAFILE
'/u01/database/clprod/oradata/system01.dbf'
CHARACTER SET ZHS16GBK
contents of Memory Script:
{
set newname for tempfile 1 to
"/u01/database/clprod/oradata//temp01.dbf";
switch clone tempfile all;
catalog clone datafilecopy "/u01/database/clprod/oradata/undotbs01.dbf";
catalog clone datafilecopy "/u01/database/clprod/oradata/sysaux01.dbf";
catalog clone datafilecopy "/u01/database/clprod/oradata/users01.dbf";
catalog clone datafilecopy "/u01/database/clprod/oradata/example01.dbf";
catalog clone datafilecopy "/u01/database/clprod/oradata/test3.dbf";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed temporary file 1 to /u01/database/clprod/oradata//temp01.dbf in control file
cataloged datafile copy
datafile copy filename=/u01/database/clprod/oradata/undotbs01.dbf recid=1 stamp=885671712
cataloged datafile copy
datafile copy filename=/u01/database/clprod/oradata/sysaux01.dbf recid=2 stamp=885671712
cataloged datafile copy
datafile copy filename=/u01/database/clprod/oradata/users01.dbf recid=3 stamp=885671712

cataloged datafile copy
datafile copy filename=/u01/database/clprod/oradata/example01.dbf recid=4 stamp=885671712
cataloged datafile copy
datafile copy filename=/u01/database/clprod/oradata/test3.dbf recid=5 stamp=885671712
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=885671712
filename=/u01/database/clprod/oradata/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=885671712
filename=/u01/database/clprod/oradata/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=885671712 filename=/u01/database/clprod/oradata/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=885671712
filename=/u01/database/clprod/oradata/example01.dbf
datafile 8 switched to datafile copy
input datafile copy recid=5 stamp=885671712 filename=/u01/database/clprod/oradata/test3.dbf
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 21-JUL-15

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

转载于:http://blog.itpub.net/30134188/viewspace-1757121/

cilei1145
关注
使用RMAN DUPLICATE复制数据库(Oracle 10g)到本机
blockheading的博客
01-11 1806
--使用RMAN DUPLICATE复制数据库(Oracle 10g)到本机 --步骤 1.创建辅助实例的Oracle口令文件。 2.建立到辅助实例的Oracle Net连接(监听文件增加库的静态注册，本地命名增加本地远程库的名字）。 3.创建辅助实例的初始化参数文件，并创建相关目录。 4.在NOMOUNT模式下启动辅助实例。 5.装载或打开目标数据库。 6.确保备份和归档重
oracle RMAN克隆数据库
专注大规模数据处理
09-06 2752
一、环境介绍1. 主数据库环境 - 操作系统版本 : redhat5 x64 - 数据库版本 : Oracle 11.2.0.3 x64 - 数据库名 : dg1 - 数据库SID : dg1 - db_unique_name: dg1 - IP：192.168.58.5 - hostname:oradg12. 备库环境 - 操作系统版本 : redhat
10g数据库做rman duplicate
Paladin的专栏
03-27 1024
10g数据库做rman duplicate的复制功能，刚接触的时候看得一头雾水，由于之前接触过本地备份，异地还原的事。所以感觉这个功能很多余。   深入的看了下体系结构，发现其实就是个自动化执行的命令，我们事先把基本的复制环境搭建好，一执行命令就可以了，也还是那些步骤，创建控制文件，restore数据库，recover数据库，关闭打开然后open resetlogs。这些都是可以手动执行的，只不
oracle10g数据库复制,Oracle10g中Duplicate复制数据库
weixin_33903769的博客
04-04 166
Oracle 10g 中Duplicate 复制数据库，本次实验通过duplicate命令，在本机环境中创建一个复制数据库。目标数据库为hongye、复制数本次实验通过duplicate命令，在本机环境中创建一个复制数据库。目标数据库为hongye、复制数据库为catdb。环境别名设置：alias sql='rlwrap sqlplus /nolog'alias rman='rlwrap rman...
oracle10g 克隆安装,【oracle】克隆oracle 10G 数据库ORACLE
weixin_28882907的博客
04-07 162
参考文档：克隆一个oracle数据库版本：10.2.0.1.0源数据库：SID : bkeep数据库文件存储在: Automatic Storage Management (ASM) disk group目标数据库：SID : xunyiqq数据库文件存储在: Automatic Storage Management (ASM) disk group导读：第一步，获取源库的参数文件第二步，建立对应...
oracle 物理拷贝,Oracle 10g R2 数据库的克隆---物理拷贝克隆
weixin_30199299的博客
04-03 314
在日常的工作中DBA经常会遇到数据的转移，最典型的就是要将在线系统运行的数据库导入到测试环境中，以进行相关的升级测试和压力测试等。下面介绍两种方式克隆数据库。一、直接的物理拷贝克隆此种方式比较简单，只要将必要的数据文件，redo，控制文件，参数文件，监听文件等拷贝到目标服务器相同的位置即可，下面介绍具体步骤：首先，已经存在一台运行完好的数据库，可以是生产库或者练习使用的，我这里是一个练习使用的10...
使用RMAN DUPLICATE复制数据库(Oracle 11g)到本机
blockheading的博客
01-12 1527
--使用RMAN DUPLICATE复制数据库(Oracle 11g)到本机 --11g新功能：对正在运行的数据库进行克隆，不需要备份。 --步骤 1.创建辅助实例的Oracle口令文件。 2.建立到辅助实例的Oracle Net连接(监听文件增加库的静态注册，本地命名增加本地远程库的名字）。 3.创建辅助实例的初始化参数文件，并创建相关目录。 4.在NOMOUNT模式
Oracle Rman Active Database Duplicate 迁移方案V1.1.pdf
09-24
本文档主要介绍 Oracle Rman Active Database Duplicate 迁移方案，适用于 Oracle 11g/12c 版本。该方案旨在帮助数据库管理员快速迁移数据库，减少迁移时间和风险。 第 1 章概述 ================ 本文档将介绍 ...
使用RMAN DUPLICATE复制数据库(Oracle 12c)到本机
blockheading的博客
01-12 2377
--使用RMAN DUPLICATE复制数据库(Oracle 12c)到本机 --克隆CDB的方法与11g相同。 --PDB的克隆比CDB的克隆要简单且快。 --步骤 --1.克隆本机pdb --create pluggable database pdb_new from pdb_old file_name_convert=('pdb_old路径','pdb_new路径')；
通过RMAN 异机克隆数据库
Top
10-14 629
平台准备：
oracle10g数据库复制,完美使用Oracle 10g RMAN复制命令
weixin_35994939的博客
04-04 198
问：我现在在红帽企业Linux系统中运行了Oracle Database 10.2.0.4。关于Oracle 10g RMAN复制命令，我有一些问题想要请教一下专家。1、我需要用RMAN来复制一个数据库(远程主机)，10g的RMAN复制命令在恢复数据文件的时候是恢复完整的数据文件大小(比如数据文件大小为500MB，但是只使用了200MB)？还是只恢复使用过的数据文件(200MB)？2、我的数据库是...
实战10g新特性之rman duplicate复制数据库
ckml77559的博客
02-15 172
对于dba来说，有时为了测试需要或者搭建dg环境时都需要对现有数据库环境做克隆，而手工完成这个任务又十分的繁琐，10g推出的rman duplicate特性很好的解决了这个问题，只要准备工作做得充分，一条命令就可以搞定这...
oracle 10g 数据库迁移
liugw_768的博客
04-14 1539
现在遇到了数据库迁移的问题，顺便整理一下文档，以备大家使用！ 方案一：覆盖数据库文件（存储迁移） 这种情况下，数据文件、控制文件、日志文件、spfile都在存储上(一般情况下是裸设备)，我们可以直接把存储挂到新机器上，然后在新机器上启动数据库。   　　操作方法：将老库的pfile(因为里面有指向裸设备的spfile链接)，tnsnames.ora，listener.o
ORACLE之搭建DG（RMAN Duplicate方式）
Csong的专栏
03-23 6781
1.准备工作         首先得准备两个能够PING通，并且装了Oracle软件且已经建库的Linux虚拟机。操作系统不限，至少有一个虚拟机已经建好库，最好两个都建好相同SID的库，这样少很多创建目录的麻烦，这里库的SID都是orcl，Linux严格区分大小写，所以SID的大小写得注意。         我这里有两个名为PD和ST的Linux虚拟机。         PD:192.168
4.网络编程
最新发布
weixin_45476535的博客
09-14 213
程序注册端口：1024-49151。单个协议下，端口号不能冲突。公有端口0-1023。
TiDB 数据库核心原理与架构_Lesson 01 TiDB 数据库架构概述课程整理
TiDB 社区干货传送门
09-12 1069
作者： 尚雷5580 原文来源： https://tidb.net/blog/beeb9eaf ...
Oracle EBS中AR模块的财务流程概览
qq_36620997的博客
09-14 540
AR模块的财务流程概览
Oracle 12c 及以上版本补丁更新说明及下载方法
zd1320732的专栏
09-10 313
参考下面的文章，会对补丁更新的流程有一定的了解。
Oracle10g RMAN实战：复制与恢复数据库
"Oracle10g服务器管理恢复--RMAN复制数据库(练习30)" 在Oracle 10g中，数据库管理恢复是一个重要的任务，尤其是当面临数据丢失或需要在不同环境间迁移数据库时。RMAN（Recovery Manager）是Oracle提供的一种强大的...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值