RMAN系列-基于scn恢复

最新推荐文章于 2025-10-19 23:09:35 发布
转载 最新推荐文章于 2025-10-19 23:09:35 发布 · 570 阅读 · 0
标签
#数据库
本文展示了使用RMAN进行Oracle数据库的备份与恢复操作的具体过程，包括全备与增量备份、数据文件与控制文件的备份、归档日志的备份及数据库恢复到指定SCN的操作。
RMAN> list backup;


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    581.66M    DISK        00:00:32     16-JAN-11      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20110116T092444
        Piece Name: /oracle/orabak/databak/20110116_02m28b6s.dbf
  List of Datafiles in backup set 2
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 484150     16-JAN-11 /oracle/oradata/orcl/system01.dbf
  2       Full 484150     16-JAN-11 /oracle/oradata/orcl/undotbs01.dbf
  3       Full 484150     16-JAN-11 /oracle/oradata/orcl/sysaux01.dbf
  4       Full 484150     16-JAN-11 /oracle/oradata/orcl/users01.dbf
  5       Full 484150     16-JAN-11 /oracle/oradata/orcl/example01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:01     16-JAN-11      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20110116T092522
        Piece Name: /oracle/orabak/ctlbak/c-1268348214-20110116-00
  Control File Included: Ckp SCN: 484217       Ckp time: 16-JAN-11
  SPFILE Included: Modification time: 16-JAN-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Full    6.80M      DISK        00:00:01     16-JAN-11      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20110116T092643
        Piece Name: /oracle/orabak/ctlbak/c-1268348214-20110116-01
  Control File Included: Ckp SCN: 484288       Ckp time: 16-JAN-11
  SPFILE Included: Modification time: 16-JAN-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    88.00K     DISK        00:00:00     16-JAN-11      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20110116T092719
        Piece Name: /oracle/flash_recovery_area/ORCL/backupset/2011_01_16/o1_mf_nnndf_TAG20110116T092719_6m4lcq82_.bkp
  List of Datafiles in backup set 6
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  6       Full 484316     16-JAN-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7       Full    6.80M      DISK        00:00:00     16-JAN-11      
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20110116T092720
        Piece Name: /oracle/orabak/ctlbak/c-1268348214-20110116-02
  Control File Included: Ckp SCN: 484321       Ckp time: 16-JAN-11
  SPFILE Included: Modification time: 16-JAN-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    88.00K     DISK        00:00:00     16-JAN-11      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20110116T092810
        Piece Name: /oracle/orabak/databak/20110116_08m28bdb.dbf
  List of Datafiles in backup set 8
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  6       Full 484356     16-JAN-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
9       Full    6.80M      DISK        00:00:00     16-JAN-11      
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20110116T092812
        Piece Name: /oracle/orabak/ctlbak/c-1268348214-20110116-03
  Control File Included: Ckp SCN: 484360       Ckp time: 16-JAN-11
  SPFILE Included: Modification time: 16-JAN-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10      Full    6.80M      DISK        00:00:00     16-JAN-11      
        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: TAG20110116T093130
        Piece Name: /oracle/orabak/ctlbak/c-1268348214-20110116-04
  Control File Included: Ckp SCN: 484545       Ckp time: 16-JAN-11
  SPFILE Included: Modification time: 16-JAN-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Full    6.80M      DISK        00:00:01     16-JAN-11      
        BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: TAG20110116T093145
        Piece Name: /oracle/orabak/ctlbak/c-1268348214-20110116-05
  Control File Included: Ckp SCN: 484564       Ckp time: 16-JAN-11
  SPFILE Included: Modification time: 16-JAN-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Full    6.80M      DISK        00:00:01     16-JAN-11      
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: TAG20110116T093400
        Piece Name: /oracle/orabak/ctlbak/c-1268348214-20110116-06
  Control File Included: Ckp SCN: 484635       Ckp time: 16-JAN-11
  SPFILE Included: Modification time: 16-JAN-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
13      Full    6.80M      DISK        00:00:00     16-JAN-11      
        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20110116T093934
        Piece Name: /oracle/orabak/ctlbak/c-1268348214-20110116-07
  Control File Included: Ckp SCN: 485199       Ckp time: 16-JAN-11
  SPFILE Included: Modification time: 16-JAN-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Full    6.77M      DISK        00:00:02     16-JAN-11      
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20110116T100750
        Piece Name: /oracle/orabak/ctlbak/c-1268348214-20110116-09
  Control File Included: Ckp SCN: 484437       Ckp time: 16-JAN-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17      Full    581.71M    DISK        00:00:29     16-JAN-11      
        BP Key: 17   Status: AVAILABLE  Compressed: NO  Tag: TAG20110116T101114
        Piece Name: /oracle/orabak/databak/20110116_0jm28du2.dbf
  List of Datafiles in backup set 17
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 484591     16-JAN-11 /oracle/oradata/orcl/system01.dbf
  2       Full 484591     16-JAN-11 /oracle/oradata/orcl/undotbs01.dbf
  3       Full 484591     16-JAN-11 /oracle/oradata/orcl/sysaux01.dbf
  4       Full 484591     16-JAN-11 /oracle/oradata/orcl/users01.dbf
  5       Full 484591     16-JAN-11 /oracle/oradata/orcl/example01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19      Full    6.77M      DISK        00:00:00     16-JAN-11      
        BP Key: 19   Status: AVAILABLE  Compressed: NO  Tag: TAG20110116T101152
        Piece Name: /oracle/orabak/ctlbak/c-1268348214-20110116-0a
  Control File Included: Ckp SCN: 484611       Ckp time: 16-JAN-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
20      Full    6.77M      DISK        00:00:00     16-JAN-11      
        BP Key: 20   Status: AVAILABLE  Compressed: NO  Tag: TAG20110116T101321
        Piece Name: /oracle/orabak/ctlbak/c-1268348214-20110116-0b
  Control File Included: Ckp SCN: 484688       Ckp time: 16-JAN-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
21      Full    6.80M      DISK        00:00:00     16-JAN-11      
        BP Key: 21   Status: AVAILABLE  Compressed: NO  Tag: TAG20110116T103611
        Piece Name: /oracle/orabak/ctlbak/c-1268348214-20110116-0c
  Control File Included: Ckp SCN: 486939       Ckp time: 16-JAN-11
  SPFILE Included: Modification time: 16-JAN-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
22      Full    6.80M      DISK        00:00:01     16-JAN-11      
        BP Key: 22   Status: AVAILABLE  Compressed: NO  Tag: TAG20110116T104438
        Piece Name: /oracle/orabak/ctlbak/c-1268348214-20110116-0d
  Control File Included: Ckp SCN: 487410       Ckp time: 16-JAN-11
  SPFILE Included: Modification time: 16-JAN-11

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
26      78.50K     DISK        00:00:01     16-JAN-11      
        BP Key: 26   Status: AVAILABLE  Compressed: NO  Tag: TAG20110116T104511
        Piece Name: /oracle/orabak/logbak/20110116_0sm28ftt.arc

  List of Archived Logs in backup set 26
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1       487220     16-JAN-11 487455     16-JAN-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27      Full    584.91M    DISK        00:00:29     16-JAN-11      
        BP Key: 27   Status: AVAILABLE  Compressed: NO  Tag: TAG20110116T104519
        Piece Name: /oracle/orabak/databak/20110116_0tm28fu0.dbf
  List of Datafiles in backup set 27
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 487463     16-JAN-11 /oracle/oradata/orcl/system01.dbf
  2       Full 487463     16-JAN-11 /oracle/oradata/orcl/undotbs01.dbf
  3       Full 487463     16-JAN-11 /oracle/oradata/orcl/sysaux01.dbf
  4       Full 487463     16-JAN-11 /oracle/oradata/orcl/users01.dbf
  5       Full 487463     16-JAN-11 /oracle/oradata/orcl/example01.dbf
  6       Full 487463     16-JAN-11 /oracle/oradata/orcl/jason01.dbf

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
28      6.50K      DISK        00:00:01     16-JAN-11      
        BP Key: 28   Status: AVAILABLE  Compressed: NO  Tag: TAG20110116T104555
        Piece Name: /oracle/orabak/logbak/20110116_0um28fv3.arc

  List of Archived Logs in backup set 28
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    2       487455     16-JAN-11 487483     16-JAN-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
29      Full    6.80M      DISK        00:00:01     16-JAN-11      
        BP Key: 29   Status: AVAILABLE  Compressed: NO  Tag: TAG20110116T104557
        Piece Name: /oracle/orabak/ctlbak/c-1268348214-20110116-0e
  Control File Included: Ckp SCN: 487489       Ckp time: 16-JAN-11
  SPFILE Included: Modification time: 16-JAN-11

RMAN> shutdown immediate

database closed
database dismounted
Oracle instance shut down

RMAN> startup mount

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area     285212672 bytes

Fixed Size                     1218968 bytes
Variable Size                 88082024 bytes
Database Buffers             188743680 bytes
Redo Buffers                   7168000 bytes

RMAN> restore database until scn 487489;

Starting restore at 16-JAN-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oracle/oradata/orcl/system01.dbf
restoring datafile 00002 to /oracle/oradata/orcl/undotbs01.dbf
restoring datafile 00003 to /oracle/oradata/orcl/sysaux01.dbf
restoring datafile 00004 to /oracle/oradata/orcl/users01.dbf
restoring datafile 00005 to /oracle/oradata/orcl/example01.dbf
restoring datafile 00006 to /oracle/oradata/orcl/jason01.dbf
channel ORA_DISK_1: reading from backup piece /oracle/orabak/databak/20110116_0tm28fu0.dbf
channel ORA_DISK_1: restored backup piece 1
piece handle=/oracle/orabak/databak/20110116_0tm28fu0.dbf tag=TAG20110116T104519
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
Finished restore at 16-JAN-11

RMAN> recover database until scn 487489;

Starting recover at 16-JAN-11
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:04

Finished recover at 16-JAN-11

RMAN> alter database open resetlogs;

database opened

RMAN>

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

转载于:http://blog.itpub.net/22741583/viewspace-683921/

cqc770206
关注
rman基于时间点恢复
03-26
rman基于时间点恢复数据，已测试实践过！主要用于oracle数据库的备份恢复
使用RMAN,基于SCN的恢复
cuanlielian4510的博客
04-19 576
Startup mount; Restore database until scn 2257708; Recover database until scn 2257708; Alt...
Oracle恢复（八）------rman基于scn的恢复
Cages的专栏
04-10 550
查找要恢复到的scn select max(ktuxescnw * power(2, 32) +ktuxescnb) scn from x$ktuxe; 这里是测试用 所以预先可以知道scn，如果是生成系统就得查询日志 ，想办法获得scn了，如查询数据库字典表(V$archived_log or v$log_history)，或分析归档与联机日志(logmnr)等。 假如要恢复到的scn是111...
RMAN基于SCN或特定时间点的不完全恢复
weixin_34342905的博客
01-22 631
---------------------------------------by acdante-------------------------------------- 前提： 数据库已开启归档： SQL> archive log list Database log mode Archive Mode Aut...
RMAN—实验—基于SCN的恢复
LeeQB的专栏
07-24 944
基于SCN的不完全恢复使用情况跟基于时间一样，只是这里是根据scn值来恢复的。 首先模拟数据库故障。 [sql] view plaincopyprint? SQL> select current_scn from v$database;      CURRENT_SCN   -----------        475351  
RMAN备份与恢复（7）——基于SCN的不完全恢复！
事后诸葛亮的程序人生（微信：zq9017197）
10-20 5238
基于SCN的不完全恢复使用情况跟基于时间一样，只是这里是根据scn值来恢复的。 首先模拟数据库故障。 SQL> select current_scn from v$database; CURRENT_SCN ----------- 475351 SQL> select file_name from dba_data_files; FILE_NAME -
rman从aix到linux跨平台恢复,RMAN系列-基于scn恢复
weixin_29779159的博客
05-15 477
RMAN> list backup;List of Backup Sets===================BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------2...
Oracle PDB 备份恢复
loveLAxin的博客
07-10 972
【代码】Oracle PDB 备份恢复。
rman恢复时ORA-01152: file 1 was not restored from a sufficiently old backup
cuiruipan6325的博客
07-16 497
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file 1 was not rest...
从RAC恢复到单实例数据库操作步骤
yang987913的专栏
01-18 683
自己做了一次RAC数据库恢复到单实例数据库的测试，特此记录。 从RAC恢复到单实例数据库操作步骤 1、检查目标端环境变量 [Oracle@RHEL5 ~]$ env | grep ORA PATH=$PATH:$HOME/bin export TMP=/tmp export TMPDIR=$TMP export ORACLE_BASE=/u01/app export O
oracle 00283,ORA-00283: recovery session canceled due to errors
weixin_42647395的博客
04-03 2064
某客户的核心数据库存储问题导致数据库重启后无法正常启动，根据客户反馈最开始在启动数据库时报错控制文件IO错误，如下：Sun Mar 15 11:59:37 2015Errors in file /oracle/app1/oracle/admin/xxxx/bdump/xxxx2_arc1_630876.trc:ORA-00204: error in reading (block 1, # bloc...
ORACLE 11G通过SCN做增量备份修复standby库详细过程
05-18 462
背景描述：Oracle的standby库后台alert报错，如下： ORA-00354: corrupt redo log block header ORA-00353: log c...
Oracle RMAN 备份与恢复
热门推荐
独醉的博客
01-07 1万+
这里写目录标题一、RMAN 备份与恢复1.RMAN备份（1）连接数据库（2）通道分配（3）RMAN 备份类型（4）BACKUP 命令（5）FORMAT 参数替换变量2.RMAN 恢复(1)数据库进行完全介质恢复（2）表空间的恢复（3）恢复数据文件（4）恢复控制文件二级目录三级目录 一、RMAN 备份与恢复        RMAN (Recovery Manager)是 Oracle 恢复管理器的简称，是集数据库备份（Backup）、还原（
rman基于SCN的不完全恢复
Baron_ccy
06-15 1466
本文描述：通过日志挖掘来恢复被删对象的过程 试验过程： 注：试验前先将数据库全备或者0级备份 全备：backup database format 'g:\rmanbak\db_%d_%T_%s.bak' plus archivelog format 'g:\rmanbak\arch_%d_%T_%s.bak'; 0级备份：backup incremental level 0  
Oracle RMAN三种不完全恢复实战详解：归档序号、时间点与SCN恢复对比
最新发布
weixin_42329915的博客
10-19 871
本文详细介绍了Oracle数据库RMAN不完全恢复的三种方法：基于归档序号、时间点和SCN的恢复。通过实际案例演示了每种方法的操作步骤和注意事项，包括恢复前的检查、命令执行过程以及恢复后的处理。特别强调了resetlogs后必须重新备份的重要性，并对比了三种恢复方式在精度、难度和适用场景上的差异。文章为DBA提供了实用的RMAN恢复技术参考，帮助在不同故障场景下选择最合适的恢复策略，确保数据安全。
Oracle DataGuard基于SCN的增量恢复
dbhang的博客
08-31 1522
Oracle DataGuard基于SCN的增量恢复 生产环境下搭建DG，当数据库很大的情况下，比如几十T的数据量，往往进行一次全备需要很久，然后需要再进行几次增量，缩小主备的差距，最后开启主库的日志传输。 1：备库停掉MRP进程 SQL> alter database recover managed standby database cancel; 2.查询最小SCN ####生产库#### SQL> select min(f.fhscn) from x$kcvfh f,v$datafile
Oracle 知识篇+DG基于SCN的增量备份与恢复
ZZT_2009
05-08 1863
说明：本文为Oracle DG中使用RMAN进行基于SCN的增量备份与恢复指导手册 标签：基于SCN的增量备份于恢复、DG备库恢复、DG断档恢复、Rman备份恢复 温馨提示：如果您发现本文哪里写的有问题或者有更好的写法请留言或私信我进行修改优化 ※ 实验环境 系统 ：Linux 6.4 Oracle：11.2.0.3 单实例 源端 ：IP:1.1.1.7 DB_NAME:orcl SE...
RMAN系列（六）RMAN高级恢复
塞尔达的传说
04-08 350
原 RMAN 系列（六） ---- RMAN 高级恢复https://blog.csdn.net/tianlesoftware/article/details/5722174版权声明： https://blog.csdn.net/tianlesoftware/article/details/5722174 这几天心情不太好，这周连续加上3天班，有点累，但是不管怎样，学习不能放下，在当下的社会，要改...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值