使用level=0的基础备份后不能恢复，提示数据文件是从老备份里恢复的，请各位帮忙看看

xyzhh 2007-01-25 05:03:58
使用level=0的基础备份后不能恢复，提示数据文件是从老备份里恢复的，请各位帮忙看看


操作如下：

[oracle@test]$ rman target / catalog rman/rman@rman

Recovery Manager: Release 10.2.0.1.0 - Production on ÐÇÆÚËÄ 1ÔÂ 25 16:40:30 2007

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

connected to target database: ORCL (DBID=1140318224)
connected to recovery catalog database

RMAN> backup incremental level=0 database format '/home/oracle/backup/%u';

Starting backup at 25-1ÔÂ -07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=158 devtype=DISK
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/opt/oracle/oradata/orcl/system01.dbf
input datafile fno=00003 name=/opt/oracle/oradata/orcl/sysaux01.dbf
input datafile fno=00002 name=/opt/oracle/oradata/orcl/undotbs01.dbf
input datafile fno=00004 name=/opt/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 25-1ÔÂ -07
channel ORA_DISK_1: finished piece 1 at 25-1ÔÂ -07
piece handle=/home/oracle/backup/06i8de4s tag=TAG20070125T164100 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting incremental level 0 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 25-1ÔÂ -07
channel ORA_DISK_1: finished piece 1 at 25-1ÔÂ -07
piece handle=/home/oracle/backup/07i8de69 tag=TAG20070125T164100 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 25-1ÔÂ -07

RMAN> quit
[oracle@test]$ dbsthut
rm /opt/oracle/oradata/orcl/* -rf
[oracle@test]$ dbstart
Processing Database instance "orcl": log file /opt/oracle/product/10.2.0/db_1/startup.log
Processing Database instance "rman": log file /opt/oracle/product/10.2.0/db_1/startup.log
[oracle@test]$ rman target / catalog rman/rman@rman

Recovery Manager: Release 10.2.0.1.0 - Production on ÐÇÆÚËÄ 1ÔÂ 25 16:51:34 2007

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

connected to target database: orcl

RMAN> restore controlfile;

Starting restore at 25-1ÔÂ -07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: reading from backup piece /home/oracle/backup/07i8de69
channel ORA_DISK_1: restored backup piece 1
piece handle=/home/oracle/backup/07i8de69 tag=TAG20070125T164100
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output filename=/opt/oracle/oradata/orcl/control01.ctl
output filename=/opt/oracle/oradata/orcl/control02.ctl
output filename=/opt/oracle/oradata/orcl/control03.ctl
Finished restore at 25-1ÔÂ -07

RMAN> restore database;

Starting restore at 25-1ÔÂ -07
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /opt/oracle/oradata/orcl/system01.dbf
restoring datafile 00002 to /opt/oracle/oradata/orcl/undotbs01.dbf
restoring datafile 00003 to /opt/oracle/oradata/orcl/sysaux01.dbf
restoring datafile 00004 to /opt/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/backup/06i8de4s
channel ORA_DISK_1: restored backup piece 1
piece handle=/home/oracle/backup/06i8de4s tag=TAG20070125T164100
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
Finished restore at 25-1ÔÂ -07
RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> recover database;

Starting recover at 25-1ÔÂ -07
Starting implicit crosscheck backup at 25-1ÔÂ -07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
Crosschecked 2 objects
Finished implicit crosscheck backup at 25-1ÔÂ -07

Starting implicit crosscheck copy at 25-1ÔÂ -07
using channel ORA_DISK_1
Crosschecked 4 objects
Finished implicit crosscheck copy at 25-1ÔÂ -07

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /opt/oracle/flash_recovery_area/ORCL/backupset/2007_01_25/o1_mf_nnnd1_TAG20070125T164151_2vjvbkmh_.bkp

using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /opt/oracle/oradata/orcl/system01.dbf
destination for restore of datafile 00002: /opt/oracle/oradata/orcl/undotbs01.dbf
destination for restore of datafile 00003: /opt/oracle/oradata/orcl/sysaux01.dbf
destination for restore of datafile 00004: /opt/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: reading from backup piece /opt/oracle/flash_recovery_area/ORCL/backupset/2007_01_25/o1_mf_nnnd1_TAG20070125T164151_2vjvbkmh_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/opt/oracle/flash_recovery_area/ORCL/backupset/2007_01_25/o1_mf_nnnd1_TAG20070125T164151_2vjvbkmh_.bkp tag=TAG20070125T164151
channel ORA_DISK_1: restore complete, elapsed time: 00:00:16

starting media recovery

unable to find archive log
archive log thread=1 sequence=3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/25/2007 16:53:55
RMAN-06054: media recovery requesting unknown log: thread 1 seq 3 lowscn 477629

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 01/25/2007 16:54:09
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/opt/oracle/oradata/orcl/system01.dbf'
...全文
277 5 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
5 条回复
切换为时间正序
请发表友善的回复…
发表回复
hem 2007-01-29
  • 打赏
  • 举报
 回复
应该是使用日志文件恢复数据文件时，找不到所需要的联机日志文件吧
hem 2007-01-29
  • 打赏
  • 举报
 回复
恢复完控制文件之后应该shutdown immediate 然后startup mount 吧，否则现在使用的控制文件信息应该不对吧。
xyzhh 2007-01-26
  • 打赏
  • 举报
 回复
如果备份的时候备份出归档日志就没问题
第二次做实验时在备份前把这个数据库的undotbs重建了，按照上面流程走一边也没有问题。难道是undotbs有什么问题
glkgdj 2007-01-26
  • 打赏
  • 举报
 回复
先把数据文件从RMAN备份里面提取出来，然后根据数据文件直接恢复！如果根据数据文件直接恢复不行，再根据错误提示采取相应的方法去解决！

www.sosdb.com
qq:9417901
msn:glkgdj@hotmail.com
xyzhh 2007-01-25
  • 打赏
  • 举报
 回复

RMAN> list backup
2> ;


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

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
29 Incr 0 534.77M DISK 00:00:43 25-1ÔÂ -07
BP Key: 33 Status: AVAILABLE Compressed: NO Tag: TAG20070125T164100
Piece Name: /home/oracle/backup/06i8de4s
List of Datafiles in backup set 29
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------- ----
1 0 Incr 477483 25-1ÔÂ -07 /opt/oracle/oradata/orcl/system01.dbf
2 0 Incr 477483 25-1ÔÂ -07 /opt/oracle/oradata/orcl/undotbs01.dbf
3 0 Incr 477483 25-1ÔÂ -07 /opt/oracle/oradata/orcl/sysaux01.dbf
4 0 Incr 477483 25-1ÔÂ -07 /opt/oracle/oradata/orcl/users01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
30 Incr 0 6.80M DISK 00:00:02 25-1ÔÂ -07
BP Key: 34 Status: AVAILABLE Compressed: NO Tag: TAG20070125T164100
Piece Name: /home/oracle/backup/07i8de69
Control File Included: Ckp SCN: 477629 Ckp time: 25-1ÔÂ -07
SPFILE Included: Modification time: 25-1ÔÂ -07

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
52 Incr 1 31.73M DISK 00:00:00 25-1ÔÂ -07
BP Key: 53 Status: AVAILABLE Compressed: NO Tag: TAG20070125T164151
Piece Name: /opt/oracle/flash_recovery_area/ORCL/backupset/2007_01_25/o1_mf_nnnd1_TAG20070125T164151_2vjvbkmh_.bkp
List of Datafiles in backup set 52
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------- ----
1 1 Incr 478458 25-1ÔÂ -07 /opt/oracle/oradata/orcl/system01.dbf
2 1 Incr 478458 25-1ÔÂ -07 /opt/oracle/oradata/orcl/undotbs01.dbf
3 1 Incr 478458 25-1ÔÂ -07 /opt/oracle/oradata/orcl/sysaux01.dbf
4 1 Incr 478458 25-1ÔÂ -07 /opt/oracle/oradata/orcl/users01.dbf
oracle 0级 1级备份,关于备份级别(level0/level1/...)
关于备份级别(level0/level1/...)2018-12-17增量备份有五种级别 即 0到4级两种类型差异增量备份累积增量备份差异增量备份：只复制执行最后一次N级或更低级的备份之后被更改的数据块累积增量备份：只复制在执行最后一...
ORACLE备份恢复
目录 一、关于备份与恢复 二、逻辑备份（expdp和impdp） 三、物理备份 四、数据库日常备份计划及脚本参考 ...物理备份：对数据库操作系统的物理文件（数据文件，控制文件和日志文件）的备份。物...
RMAN的备份与恢复
全备份是一个或多个数据文件中使用过的数据块的的备份。没有使用过的数据块是不被备份的，也就是说，oracle进行备份集合的压缩。 把所有有数据的数据块都备份了，包括表、view、序列都是定义，都存在数据字典，数据...
Windows下面基于pgsql15的备份和恢复
上面的方式简单是简单，但是每次备份都要重新备份整个库，库大的情况下，太过于浪费时间，推荐使用增量备份，每天进行一次归档保存，恢复的时候，只需要把基础数据恢复一次，然后逐次恢复归档数据就可以了。...
PostgreSQL备份和恢复
按照备份后的文件类型，可以分为物理备份（文件系统级别的备份）和逻辑备份（备份后的文件是sql文件或特定格式的导出文件）；按照备份过程中是否停止数据库服务，可分为冷备份（备份过程中停止数据...
Oracle 高级技术

3,494

社区成员

18,710

社区内容

发帖
与我相关
我的任务
社区描述
Oracle 高级技术相关讨论专区
社区管理员
  • 高级技术社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章