用rman进行恢复数据,出现RMAN-03009,RMAN-11003,ORA-01991错误
来源:互联网 发布:珠海网络电视 编辑:程序博客网 时间:2024/06/04 17:51
C:\Documents and Settings\mzl>sqlplus "/as sysdba"SQL*Plus: Release 9.2.0.1.0 - Production on 星期六 2月 16 13:13:24 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.连接到:Oracle9i Enterprise Edition Release 9.2.0.1.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - ProductionSQL> desc v$instance; 名称 是否为空? 类型 ----------------------------------------- -------- ---------------------------- INSTANCE_NUMBER NUMBER INSTANCE_NAME VARCHAR2(16) HOST_NAME VARCHAR2(64) VERSION VARCHAR2(17) STARTUP_TIME DATE STATUS VARCHAR2(12) PARALLEL VARCHAR2(3) THREAD# NUMBER ARCHIVER VARCHAR2(7) LOG_SWITCH_WAIT VARCHAR2(11) LOGINS VARCHAR2(10) SHUTDOWN_PENDING VARCHAR2(3) DATABASE_STATUS VARCHAR2(17) INSTANCE_ROLE VARCHAR2(18) ACTIVE_STATE VARCHAR2(9)SQL> select instance_name,status from v$instance;INSTANCE_NAME STATUS---------------- ------------risesoft MOUNTEDSQL> archive log list;数据库日志模式 存档模式自动存档 禁用存档终点 C:\oracle\ora92\RDBMS最早的概要日志序列 10下一个存档日志序列 12当前日志序列 12SQL> shutdown immediate;ORA-01109: 数据库未打开已经卸载数据库。ORACLE 例程已经关闭。SQL> host del C:\oracle\oradata\risesoft\control*SQL> startup nomountORACLE 例程已经启动。Total System Global Area 126950220 bytesFixed Size 453452 bytesVariable Size 109051904 bytesDatabase Buffers 16777216 bytesRedo Buffers 667648 bytesSQL> set dbid 425358856SP2-0158: 未知的SET选项"dbid"SQL> set dbid 425358856SP2-0158: 未知的SET选项"dbid"SQL> exit从Oracle9i Enterprise Edition Release 9.2.0.1.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - Production中断开C:\Documents and Settings\mzl>rman target/恢复管理器: 版本9.2.0.1.0 - ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved.连接到目标数据库: risesoft(未安装)RMAN> set dbid 425358856正在执行命令: SET DBIDRMAN> restore controlfile from 'd:\backup\C-425358856-20080216-00';启动 restore 于 16-2月 -08正在使用目标数据库控制文件替代恢复目录分配的通道: ORA_DISK_1通道 ORA_DISK_1: sid=11 devtype=DISK通道 ORA_DISK_1: 正在恢复控制文件通道 ORA_DISK_1: 恢复完成正在复制控制文件输出文件名=C:\ORACLE\ORADATA\RISESOFT\CONTROL01.CTL输出文件名=C:\ORACLE\ORADATA\RISESOFT\CONTROL02.CTL输出文件名=C:\ORACLE\ORADATA\RISESOFT\CONTROL03.CTL完成 restore 于 16-2月 -08在这里恢复控制文件成功RMAN> sql 'alter database mount';sql 语句: alter database mountRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03009: failure of sql command on default channel at 02/16/2008 13:18:59RMAN-11003: failure during parse/execution of SQL statement: alter database mountORA-01991: 无效的口令文件'C:\oracle\ora92\DATABASE\PWDrisesoft.ORA'RMAN>删除该口令文件,后重建。C:\Documents and Settings\mzl>del C:\oracle\ora92\DATABASE\PWDrisesoft.ORAC:\Documents and Settings\mzl>orapwd file=C:\oracle\ora92\DATABASE\PWDrisesoft.ORA password=mzl重新查看RMAN> shutdown immediate;数据库已卸载Oracle 例程已关闭RMAN> startup nomount;已连接到目标数据库 (未启动)Oracle 例程已启动系统全局区域总计 126950220 字节Fixed Size 453452 字节Variable Size 109051904 字节Database Buffers 16777216 字节Redo Buffers 667648 字节RMAN> sql 'alter database mount';sql 语句: alter database mountRMAN> restore database;启动 restore 于 16-2月 -08分配的通道: ORA_DISK_1通道 ORA_DISK_1: sid=11 devtype=DISKRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of restore command at 02/16/2008 14:36:24RMAN-06026: some targets not found - aborting restoreRMAN-06023: no backup or copy of datafile 10 found to restoreRMAN-06023: no backup or copy of datafile 8 found to restoreRMAN-06023: no backup or copy of datafile 7 found to restoreRMAN-06023: no backup or copy of datafile 6 found to restoreRMAN-06023: no backup or copy of datafile 5 found to restoreRMAN-06023: no backup or copy of datafile 4 found to restoreRMAN-06023: no backup or copy of datafile 3 found to restore很多数据块没有找到,用sql查询看看datafile对应的数据文件SQL> l 1* select file#,name from v$datafileSQL> / FILE# NAME---------- -------------------------------------------------- 1 C:\ORACLE\ORADATA\RISESOFT\SYSTEM01.DBF 2 C:\ORACLE\ORADATA\RISESOFT\UNDOTBS01.DBF 3 C:\ORACLE\ORA92\DATABASE\MISSING00003 4 C:\ORACLE\ORA92\DATABASE\MISSING00004 5 C:\ORACLE\ORA92\DATABASE\MISSING00005 6 C:\ORACLE\ORA92\DATABASE\MISSING00006 7 C:\ORACLE\ORA92\DATABASE\MISSING00007 8 C:\ORACLE\ORA92\DATABASE\MISSING00008 9 C:\ORACLE\ORADATA\RISESOFT\USERS01.DBF 10 C:\ORACLE\ORA92\DATABASE\MISSING00010已选择10行。查看备份状态:RMAN> list backup of database;备份集列表===================BS 关键字 类型 LV 大小 设备类型 经过时间 完成时间------- ---- -- ---------- ----------- ------------ ----------2 Full 340M DISK 00:00:23 16-2月 -08BP 关键字: 2 状态: AVAILABLE 标记:TAG20080216T010912段名:D:\BACKUP\02J8QJ9P_1_1 备份集 2 中的数据文件列表 文件 LV 类型 Ckp SCN Ckp 时间 名称 ---- -- ---- ---------- ---------- ---- 1 Full 444212 16-2月 -08 C:\ORACLE\ORADATA\RISESOFT\SYSTEM01.DBF 2 Full 444212 16-2月 -08 C:\ORACLE\ORADATA\RISESOFT\UNDOTBS01.DBF 9 Full 444212 16-2月 -08 C:\ORACLE\ORADATA\RISESOFT\USERS01.DBF出现该错误原因是在执行recover database时应该skip 不需要恢复的表空间RMAN> recover database skip tablespace CWMLITE,DRSYS,EXAMPLE,INDX,ODM,TOOLS,XDB;启动 recover 于 16-2月 -08使用通道 ORA_DISK_1正在开始介质的恢复存档日志线程 1 序列 12 已作为文件 C:\ORACLE\ORADATA\RISESOFT\REDO02.LOG 存在于磁盘上存档日志线程 1 序列 13 已作为文件 C:\ORACLE\ORADATA\RISESOFT\REDO03.LOG 存在于磁盘上存档日志线程 1 序列 14 已作为文件 C:\ORACLE\ORADATA\RISESOFT\REDO01.LOG 存在于磁盘上通道 ORA_DISK_1: 正在启动到默认目标的存档日志恢复通道 ORA_DISK_1: 正在恢复存档日志存档日志线程 =1 序列=11通道 ORA_DISK_1: 已恢复备份段 1段 handle=D:\BACKUP\03J8QJAJ_1_1 tag=TAG20080216T010939 params=NULL通道 ORA_DISK_1: 恢复完成存档日志文件名 =C:\ORACLE\ORA92\RDBMS\ARC00011.001 线程 =1 序列 =11存档日志文件名 =C:\ORACLE\ORADATA\RISESOFT\REDO02.LOG 线程 =1 序列 =12RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of recover command at 02/16/2008 15:39:32ORA-00283: recovery session canceled due to errorsRMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile 'C:\ORACLE\ORADATA\RISESOFT\REDO02.LOG'ORA-00283: 恢复会话因错误而取消ORA-16067: 归档日志 C:\ORACLE\ORADATA\RISESOFT\REDO02.LOG 中的激活标识符匹配出错查找了一段时间,还没有解决,还是把控制文件删除了,再重建控制文件解决方法:1 在d:\backup\目录下创建了一个createControl.sql文件内容如下:STARTUP NOMOUNTCREATE CONTROLFILE REUSE DATABASE "risesoft" NORESETLOGS ARCHIVELOG-- SET STANDBY TO MAXIMIZE PERFORMANCE MAXLOGFILES 5 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 1 MAXLOGHISTORY 226LOGFILE GROUP 1 'C:\oracle\oradata\risesoft\redo01.log' SIZE 100M, GROUP 2 'C:\oracle\oradata\risesoft\redo02.log' SIZE 100M, GROUP 3 'C:\oracle\oradata\risesoft\redo03.log' SIZE 100M-- STANDBY LOGFILEDATAFILE 'C:\oracle\oradata\risesoft\system01.dbf', 'C:\oracle\oradata\risesoft\undotbs01.dbf', 'C:\oracle\oradata\risesoft\users01.dbf'CHARACTER SET ZHS16GBK;RECOVER DATABASEALTER SYSTEM ARCHIVE LOG ALL;ALTER DATABASE OPEN;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\oracle\oradata\risesoft\temp01.dbf' SIZE 41943040 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M; 2 在sqlplus中执行该文件SQL>startup nomountSQL>@d:\backup\createControl.sql控制文件已创建3 关闭后启动数据库SQL>shutdown immediate;SQL>startup......数据库已经打开
0 0
- 用rman进行恢复数据,出现RMAN-03009,RMAN-11003,ORA-01991错误
- RMAN-03009,ORA-00230错误恢复
- rman 恢复数据错误案例:RMAN-03002
- rman 恢复数据错误案例--ORA-19573 错误
- rman 恢复数据错误案例--ORA-19573 错误
- RMAN恢复报ORA-19563错误
- RMAN恢复数据库报ORA-19573错误
- RMAN进行备份恢复
- rman进行备份、恢复
- rman 备份出现ORA-00245/RMAN-08132
- 用rman进行数据迁移
- RAC RMAN 通道配置 RMAN-12001 RMAN-12001 RMAN-10008 RMAN-10003 ORA-01017 错误
- RAC RMAN 通道配置 RMAN-12001 RMAN-12001 RMAN-10008 RMAN-10003 ORA-01017 错误
- 只有spfile和控制文件情况下进行rman恢复时报ORA-00312 ORA-00313错误
- rman恢复遭遇ora-1152
- RMAN-03009 & ORA-17628
- RMAN-03009,ORA-00230
- RMAN-03009 ORA-15028
- JSP+Servlet培训班作业管理系统[1]-登录功能的简单实现
- GET与POST比较(数据大小、数据类型、传送形式)
- Longest Palindromic Substring
- 【开源】NodeJS仿WebApi路由
- 装配Bean基于XML (Bean种类、作用域、生命周期、属性依赖注入)
- 用rman进行恢复数据,出现RMAN-03009,RMAN-11003,ORA-01991错误
- 使用函数区分不同的线程
- 获取SATA盘序列号
- XML 解析生成工具
- 对蒙特卡罗方法的理解
- Unity 控制物体移动 旋转 缩放
- node.js之REPL运行环境
- 类的继承
- 针对数据库中的分类统计