使用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'
...全文
282 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
spring-boot-2.3.0.RC1.jar中文-英文对照文档.zip
1、压缩文件中包含： 中文-英文对照文档、jar包下载地址、Maven依赖、Gradle依赖、源代码下载地址。 2、使用方法： 解压最外层zip，再解压其中的zip包，双击 【index.html】 文件，即可用浏览器打开、进行查看。 3、特殊说明： （1）本文档为人性化翻译，精心制作，请放心使用； （2）只翻译了该翻译的内容，如：注释、说明、描述、用法讲解 等； （3）不该翻译的内容保持原样，如：类名、方法名、包名、类型、关键字、代码 等。 4、温馨提示： （1）为了防止解压后路径太长导致浏览器无法打开，推荐在解压时选择“解压到当前文件夹”（放心，自带文件夹，文件不会散落一地）； （2）有时，一套Java组件会有多个jar，所以在下载前，请仔细阅读本篇描述，以确保这就是你需要的文件。 5、本文件关键字： jar中文-英文对照文档.zip,java,jar包,Maven,第三方jar包,组件,开源组件,第三方组件,Gradle,中文API文档,手册,开发手册,使用手册,参考手册。
presto-jdbc-0.238.1.jar中文文档.zip
1、压缩文件中包含： 中文文档、jar包下载地址、Maven依赖、Gradle依赖、源代码下载地址。 2、使用方法： 解压最外层zip，再解压其中的zip包，双击 【index.html】 文件，即可用浏览器打开、进行查看。 3、特殊说明： （1）本文档为人性化翻译，精心制作，请放心使用； （2）只翻译了该翻译的内容，如：注释、说明、描述、用法讲解 等； （3）不该翻译的内容保持原样，如：类名、方法名、包名、类型、关键字、代码 等。 4、温馨提示： （1）为了防止解压后路径太长导致浏览器无法打开，推荐在解压时选择“解压到当前文件夹”（放心，自带文件夹，文件不会散落一地）； （2）有时，一套Java组件会有多个jar，所以在下载前，请仔细阅读本篇描述，以确保这就是你需要的文件。 5、本文件关键字： jar中文文档.zip,java,jar包,Maven,第三方jar包,组件,开源组件,第三方组件,Gradle,中文API文档,手册,开发手册,使用手册,参考手册。
Linux_SID_开发指南.pdf
Linux_SID_开发指南
基于 python 3.7 + django 2.2.3 + 运维devops管理系统
基于 python 3.7 + django 2.2.3 + channels 2.2.0 + celery 4.3.0 + ansible 2.8.5 + AdminLTE-3.0.0 实现的运维devops管理系统。
拉格朗日插值法处理缺失数据
资源下载链接为： https://pan.quark.cn/s/abbae039bf2a 拉格朗日插值法是一种数学方法，能够在给定的若干个不同位置的观测值时，找到一个多项式，使得该多项式在这些观测点上恰好取到相应的观测值。这种多项式被称为拉格朗日（插值）多项式。从数学的角度来看，拉格朗日插值法可以构建一个多项式函数，使其精确地穿过二维平面上的若干个已知点。本文将介绍如何利用拉格朗日插值法来填补缺失值。为了更好地理解这一方法，我们先通过一组简单的数据来展示拉格朗日插值法的实现过程。以下是实现拉格朗日插值法的代码示例：
Oracle 高级技术

3,495

社区成员

18,710

社区内容

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

加载中

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

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

+ 用AI写文章