ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RMAN压缩备份本地数据库,进行异地恢复操作

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

原创 Linux操作系统 作者:bulls_523 时间:2013-07-05 08:57:16 0 删除 编辑

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 <    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;

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

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

上一篇: 总结
请登录后发表评论 登录
全部评论

注册时间:2013-06-18

  • 博文量
    10
  • 访问量
    37928