使用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'
...全文
281 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级或更低级的备份之后被更改的数据块累积增量备份：只复制在执行最后一次N-1级或更低级备份之后更改的数据块0级就是对数据库的一个完整备份-----------------------------------Oracle的差异增...
ORACLE备份恢复
目录 一、关于备份与恢复 二、逻辑备份（expdp和impdp） 三、物理备份 四、数据库日常备份计划及脚本参考 一、关于备份与恢复 1、备份定义 备份就是把数据库复制到转储设备的过程。其中，转储设备是指用于放置数据库副本的磁带或磁盘。通常也将存放于转储设备中的数据库的副本称为原数据库的备份或转储。备份是一份数据副本 2、备份分类 从物理与逻辑的角度来分类： 从物理与逻辑的，备份可以分为物理备份和逻辑备份。物理备份：对数据库操作系统的物理文件（数据文件，控制文件和日志文件）的备份。物...
RMAN的备份与恢复
1 物理备份 1.1 完全备份（full） 全备份是一个或多个数据文件中使用过的数据块的的备份。没有使用过的数据块是不被备份的，也就是说，oracle进行备份集合的压缩。 把所有有数据的数据块都备份了，包括表、view、序列都是定义，都存在数据字典，数据字典在system表空间。 只备份有数据的数据块。所以rman是块级的备份，也是物理备份。 rman全库备份只需要通过backup databas...
Windows下面基于pgsql15的备份和恢复
上面的方式简单是简单，但是每次备份都要重新备份整个库，库大的情况下，太过于浪费时间，推荐使用增量备份，每天进行一次归档保存，恢复的时候，只需要把基础数据恢复一次，然后逐次恢复归档数据就可以了。红色字体为说明，可看可不看归档备份的原理：PostgreSQL在执行写入操作时，对数据文件的任何修改信息，首先会写入WAL日志，然后才会对数据文件做物理修改。如果数据库服务器掉电或意外宕机，则PostgreSQL重新启动后首先会读取WAL日志，然后根据日志对数据进行恢复。
PostgreSQL备份和恢复
1.简介 由于数据库中包含着有价值的数据，PostgreSQL数据库应当被定期地备份。虽然过程相当简单，但清晰地理解其底层技术和假设是非常重要的。 2.PostgreSQL数据备份方式 数据库的备份有多种分类方式。按照备份后的文件类型，可以分为物理备份（文件系统级别的备份）和逻辑备份（备份后的文件是sql文件或特定格式的导出文件）；按照备份过程中是否停止数据库服务，可分为冷备份（备份过程中停止数据...
Oracle 高级技术

3,494

社区成员

18,710

社区内容

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

加载中

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

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

+ 用AI写文章