源服务器和目标服务器的操作系统,oracle版本均为11.2.0.4.0 - 64bit
源服务器:192.168.1.9目的服务器:192.168.1.10,只需要安装oracle软件即可,不需要建库操作
一、源库操作:
1、在源库和目标库分别建立备份恢复目录
[oracle@Opt10 oracle]$ mkdir /u01/backup
2、在源服务器上使用rman备份数据库,包括数据文件,归档日志文件和控制文件,参数文件的备份
[oracle@Opt10 archivelog]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Sep 23 13:12:27 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: STOOPT (DBID=2518750428)
run {
allocate channel c1 device type disk;
backup incremental level 0
format '/u01/backup/db_full_%U.bkp'
tag '2016-09-23-FULL'
database plus archivelog;
release channel c1;
}
RMAN> backup current controlfile format '/u01/backup/control20160923.bak';
RMAN> backup spfile format '/u01/backup/spfile20160923.bak';
3、把备份内容拷贝至目标服务器
[oracle@Opt10 backup]$ scp * 192.168.1.10:/u01/backup
二、目标库操作:
[oracle@Opt12 database]$ mkdir -p /u01/app/oracle/oradata/stoopt/
[oracle@Opt12 database]$ mkdir -p data/oracle/st/
[oracle@Opt12 database]$ mkdir -p /u01/app/oracle/fast_recovery_area/STOOPT/autobackup/
[oracle@Opt12 database]$ mkdir -p /data/oracle/st/
[oracle@Opt12 dbs]$ echo 'db_name=stoopt' > $ORACLE_HOME/dbs/initorcl.ora
export ORACLE_SID=orcl
[oracle@Opt12 backup]$