RMAN压缩备份本地数据库,进行异地恢复操作-阿里云开发者社区

开发者社区> 数据库> 正文
登录阅读全文

RMAN压缩备份本地数据库,进行异地恢复操作

简介:

 

RMAN压缩备份本地数据库,进行异地恢复操作:

原来数据库IP: A:172.21.1.30 
要恢复的库IP: B:172.21.1.40

服务器A:172.21.1.30上的操作如下:

1.删除/bk下的所有备份文件,删除/arc下的归档文件 
[oracle@dg ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Aug 2 10:59:27 2011 
Copyright (c) 1982, 2005, Oracle. All rights reserved. 
connected to target database: DG01 (DBID=370021178) 

RMAN>delete noprompt expired backup; 
RMAN>delete noprompt expired copy;

2.执行脚本 rmanback.sh,对数据库进行压缩备份: 

脚本内容如下: 
rman target / log=/bk/rmanbackup.log <<EOF 
backup as compressed backupset filesperset 3 database format '/bk/%u'; 
backup archivelog all delete input format '/bk/arc_%u.bk'; 
delete noprompt obsolete; 
backup current controlfile format '/bk/%u.ctl'; 
EOF 

[oracle@dg ~]$sh /bk/rmanback.sh 
[oracle@dg bk]$ ls

08mivn8k 09mivnci 0amivnd1 0bmivndq 0cmivne9 0emivneh.ctl arc_0dmivnee.bk rmanback.sh rmanbackup.log 

[oracle@dg bk]$ tar cvfz bk30.tar.gz ./* --exclude=*.sh --exclude=*.log 
[oracle@dg bk]$ scp -r bk30.tar.gz 172.21.1.40:/disk/


3.一致性停数据库:

[oracle@dg ~]$ sqlplus / as sysdba

SYS_S:142_P:13539_dg01>shutdown immediate; 

服务器B:172.21.1.40 的操作步骤:

1.解压备份文件: 
[oracle@vcdog disk]$ tar xvfz bk30.tar.gz ./ 
[oracle@vcdog disk]$ ls 
08mivn8k 09mivnci 0amivnd1 0bmivndq 0cmivne9 0emivneh.ctl arc_0dmivnee.bk 

2.恢复controlfile及spfile: 
[oracle@vcdog disk]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Aug 2 11:22:07 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved. 

RMAN>startup nomount; 
RMAN>restore controlfile from '/disk/0emivneh.ctl'; 
RMAN>restore spfile from '/disk/0cmivne9'; 

[oracle@vcdog disk]$ cp $ORACLE_HOME/dbs/cntrlorcl.dbf $ORACLE_BASE/oradata/dg01/control01.ctl 
[oracle@vcdog disk]$ cp $ORACLE_HOME/dbs/cntrlorcl.dbf $ORACLE_BASE/oradata/dg01/control02.ctl 
[oracle@vcdog disk]$ cp $ORACLE_HOME/dbs/cntrlorcl.dbf $ORACLE_BASE/oradata/dg01/control03.ctl 
[oracle@vcdog disk]$strings $ORACLE_HOME/dbs/spfiledg01.ora > $ORACLE_HOME/dbs/initdg01.ora 
[oracle@vcdog disk]$ vim /data/oracle/product/10.2.0.1.0/db_01/dbs/initdg01.ora 
*.audit_file_dest='/data/oracle/admin/dg01/adump' 
*.background_dump_dest='/data/oracle/admin/dg01/bdump' 
*.compatible='10.2.0.1.0' 
*.control_files='/data/oracle/oradata/dg01/control01.ctl','/data/oracle/oradata/dg01/control02.ctl','/data/oracle/oradata/dg01/control03.ctl'#Restore Controlfile 
*.core_dump_dest='/data/oracle/admin/dg01/cdump' 
*.db_block_size=8192 
*.db_cache_size=62914560 
*.db_file_multiblock_read_count=16 
*.db_name='dg01' 
*.job_queue_processes=2 
*.large_pool_size=20971520 
*.pga_aggregate_target=16777216 
*.processes=150 
*.sga_max_size=314572800 
*.sga_target=293601280 
*.shared_pool_size=96468992 
*.undo_management='AUTO' 
*.undo_tablespace='UNDOTBS1' 
*.user_dump_dest='/data/oracle/admin/dg01/udump' 

保存退出。 

3.启动数据库到mount状态: 

[oracle@vcdog dbs]$ sqlplus / as sysdba

SYS_S:159_P:5659_dg01> alter database mount; 

SYS_S:159_P:5659_dg01>select 'set newname for datafile '||file#|| ' to '''||replace(name,'u01','data')||''';' from v$datafile; 

set newname for datafile 1 to '/data/oracle/oradata/dg01/system01.dbf'; 
set newname for datafile 2 to '/data/oracle/oradata/dg01/undotbs01.dbf'; 
set newname for datafile 3 to '/data/oracle/oradata/dg01/sysaux01.dbf'; 
set newname for datafile 4 to '/data/oracle/oradata/dg01/users01.dbf'; 
set newname for datafile 5 to '/data/oracle/oradata/dg01/example01.dbf'; 
set newname for datafile 6 to '/data/oracle/oradata/dg01/vc.dbf'; 
set newname for datafile 7 to '/data/oracle/oradata/dg01/mytest01.dbf'; 
set newname for datafile 8 to '/data/oracle/oradata/dg01/mytest02.dbf'; 
set newname for datafile 9 to '/data/oracle/oradata/dg01/mytbs01.dbf'; 
set newname for datafile 10 to '/data/oracle/oradata/dg01/ind_tbs01.dbf'; 
set newname for datafile 11 to '/data/oracle/oradata/dg01/wd01.dbf'; 

4.RMAN下执行脚本: 

RMAN> catalog start with '/disk/'; 
RMAN>run{ 
set newname for datafile 1 to '/data/oracle/oradata/dg01/system01.dbf'; 
set newname for datafile 2 to '/data/oracle/oradata/dg01/undotbs01.dbf'; 
set newname for datafile 3 to '/data/oracle/oradata/dg01/sysaux01.dbf'; 
set newname for datafile 4 to '/data/oracle/oradata/dg01/users01.dbf'; 
set newname for datafile 5 to '/data/oracle/oradata/dg01/example01.dbf'; 
set newname for datafile 6 to '/data/oracle/oradata/dg01/vc.dbf'; 
set newname for datafile 7 to '/data/oracle/oradata/dg01/mytest01.dbf'; 
set newname for datafile 8 to '/data/oracle/oradata/dg01/mytest02.dbf'; 
set newname for datafile 9 to '/data/oracle/oradata/dg01/mytbs01.dbf'; 
set newname for datafile 10 to '/data/oracle/oradata/dg01/ind_tbs01.dbf'; 
set newname for datafile 11 to '/data/oracle/oradata/dg01/wd01.dbf'; 
restore database; 
switch datafile all; 
recover database; 


5.rename logfile日志文件: 

[oracle@vcdog dbs]$scp -r 172.21.1.30:/u01/oracle/oradata/dg01/redo01.log /data/oracle/oradata/dg01/redo01.log 
[oracle@vcdog dbs]$scp -r 172.21.1.30:/u01/oracle/oradata/dg01/redo03.log /data/oracle/oradata/dg01/redo03.log 
SYS_S:159_P:5659_dg01>alter database rename file '/u01/oracle/oradata/dg01/redo01.log' to '/data/oracle/oradata/dg01/redo01.log'; 
SYS_S:159_P:5659_dg01>alter database rename file '/u01/oracle/oradata/dg01/redo03.log' to '/data/oracle/oradata/dg01/redo03.log'; 

此时,由于原来备份时,redo02.log文件是current状态,不能直接归档。在服务器A:172.21.1.30上执行如下命令: 
SYS_S:159_P:5659_dg01>alter system switch logfile; 

[oracle@vcdog dbs]$scp -r 172.21.1.30:/u01/oracle/oradata/dg01/redo02.log /data/oracle/oradata/dg01/redo02.log 
SYS_S:159_P:5659_dg01>alter database rename file '/u01/oracle/oradata/dg01/redo02.log' to '/data/oracle/oradata/dg01/redo02.log'; 

6.打开数据库到open状态: 

SYS_S:159_P:5659_dg01> alter database open resetlogs;

此时,数据库的异地恢复完成。

 

 


    本文转自vcdog 51CTO博客,原文链接:http://blog.51cto.com/255361/837647,如需转载请自行联系原作者




版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

分享:
数据库
使用钉钉扫一扫加入圈子
+ 订阅

分享数据库前沿,解构实战干货,推动数据库技术变革

其他文章
最新文章
相关文章