利用RMAN进行异机还原（目录相同）

利用RMAN进行异机还原（目录相同）源始库：192.168.201.2
目标库：192.168.201.3--192.168.201.2
--rman
[Oracle@db01 ~]$ rman target /Recovery Manager: Release 10.2.0.1.0 - Production on Wed Sep 18 08:52:25 2013Copyright （c） 1982, 2005, Oracle. All rights reserved.connected to target database: ORCL （DBID=1354163930）--dbid--备份数据文件
RMAN> backup database format "/u02/backup/dbf_%T_%U.bak";Starting backup at 18-SEP-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=140 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile（s） in backupset
input datafile fno=00001 name=/u02/oradata/orcl/system01.dbf
input datafile fno=00002 name=/u02/oradata/orcl/undotbs01.dbf
input datafile fno=00003 name=/u02/oradata/orcl/sysaux01.dbf
input datafile fno=00005 name=/u02/oradata/orcl/app01.dbf
input datafile fno=00004 name=/u02/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 18-SEP-13
channel ORA_DISK_1: finished piece 1 at 18-SEP-13
piece handle=/u02/backup/dbf_20130918_05ok565a_1_1.bak tag=TAG20130918T085402comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:25
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile（s） in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 18-SEP-13
channel ORA_DISK_1: finished piece 1 at 18-SEP-13
piece handle=/u02/backup/dbf_20130918_06ok567v_1_1.bak tag=TAG20130918T085402comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 18-SEP-13--备份归档日志
RMAN> backup archivelog all format "/u02/backup/arc_%T_%U.bak" delete input;Starting backup at 18-SEP-13
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log（s） in backup set
input archive log thread=1 sequence=33 recid=6 stamp=826448032
input archive log thread=1 sequence=34 recid=7 stamp=826448303
channel ORA_DISK_1: starting piece 1 at 18-SEP-13
channel ORA_DISK_1: finished piece 1 at 18-SEP-13
piece handle=/u02/backup/arc_20130918_07ok56dg_1_1.bak tag=TAG20130918T085823comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log（s）
archive log filename=/u02/archivelog/1_33_826383194.dbf recid=6 stamp=826448032
archive log filename=/u02/archivelog/1_34_826383194.dbf recid=7 stamp=826448303
Finished backup at 18-SEP-13--备份控制文件
RMAN> backup current controlfile format "/u02/backup/ctl_%T_%U.bak";Starting backup at 18-SEP-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile（s） in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 18-SEP-13
channel ORA_DISK_1: finished piece 1 at 18-SEP-13
piece handle=/u02/backup/ctl_20130918_08ok56fa_1_1.bak tag=TAG20130918T085922comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 18-SEP-13
--192.168.201.3
--关闭数据库
[oracle@db02 orcl]$ sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 18 07:39:50 2013Copyright （c） 1982, 2005, Oracle. All rights reserved.SQL> conn /as sysdba
Connected.SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.--打开数据库到nomount状态
SQL> startup nomount;
ORACLE instance started.Total System Global Area 734003200 bytes
Fixed Size 1221564 bytes
Variable Size 213912644 bytes
Database Buffers 515899392 bytes
Redo Buffers 2969600 bytes--rman
[oracle@db02 bdump]$ rman target /Recovery Manager: Release 10.2.0.1.0 - Production on Wed Sep 18 09:02:02 2013Copyright （c） 1982, 2005, Oracle. All rights reserved.connected to target database: orcl （not mounted）--设置dbid（与源库保持一致，如果与源库不同，则会无法恢复，后面再演示） 推荐阅读：Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htmRMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htmRMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htmOracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

Oracle GoldenGate 常见问题：长事务处理Oracle GoldenGate 数据同步初始化最佳实战（Data Pump）相关资讯 RMAN

RMAN故障一例（归档的备份，从不（今 20:42）
RMAN的FORMATA格式说明（03月10日）
Oracle 11g RMAN复制数据库的测试（01月19日）

RMAN数据库迁移（05月22日）
使用RMAN复制恢复开发库环境（02月17日）
Oracle 11g RMAN跨平台传输表空间（01月19日）

本文评论查看全部评论（0）