Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
1#
发表于 2017-4-16 15:18:14 | 查看: 2071| 回复: 0

报错如下:
SQL> startup
ORACLE instance started.

Total System Global Area  118255568 bytes
Fixed Size                   282576 bytes
Variable Size              83886080 bytes
Database Buffers           33554432 bytes
Redo Buffers                 532480 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

我用rman:
RMAN> sql 'alter database open resetlogs';

using target database controlfile instead of recovery catalog
sql statement: alter database open resetlogs
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00579: the following error occurred at 11/26/2007 09:57:53
RMAN-03006: non-retryable error occurred during execution of command: sql
RMAN-12004: unhandled exception during command execution on channel default
RMAN-20000: abnormal termination of job step
RMAN-11003: failure during parse/execution of SQL statement: alter database open
resetlogs
RMAN-11001: Oracle Error: ORA-01152: file 1 was not restored from a sufficiently
old backup
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\DEMO\SYSTEM01.DBF'



补充,
我有过备份,但是所有的数据库文件备份都丢失掉,以前的归档日志都存在,备份的控制文件文件也存在。

我现在就无法做'D:\ORACLE\ORADATA\DEMO\SYSTEM01.DBF'的restore;
请问这中情况能把数据库给开启吗?

所有的备份集都丢失了。。。。郁闷!

所有的控制文件存在,能否用控制文件和归档日志来进行恢复啊?

我有过备份,但是所有的数据库文件备份都丢失掉,以前的归档日志都存在,备份的控制文件文件也存在。
指的是:我以前对数据库作了全备份,但是现在已经丢失了。
因为数据库是自动进行归档的,以前的归档日志还在,控制文件也在。。


出错:
RMAN> restore database using backup controlfile until cancel;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00579: the following error occurred at 11/26/2007 10:46:07
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "archivelog, ch
nnel, check, controlfile, clone, database, datafile, device, from, force, high,
(, parms, ;, skip, standby, tablespace, until, validate"
RMAN-01008: the bad identifier was: using
RMAN-01007: at line 1 column 18 file: standard input



从建数据库以来的所有归档都在??
不是所有的归档,因为是测试db,以前好像有过删除



我现在手头是有最近的controlfile,最近所有的归档日志(不是全部),所有的备份全部丢失,

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1128168 generated at 11/26/2007 08:47:23 needed for thread 1
ORA-00289: suggestion : D:\ORACLE\ORADATA\DEMO\ARCHIVE\ARC00048.001
ORA-00280: change 1128168 for thread 1 is in sequence #48


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
D:\ORACLE\ORADATA\DEMO\SYSTEM01.DBF
ORA-00317: file type 0 in header is not log file
ORA-00334: archived log: 'D:\ORACLE\ORADATA\DEMO\SYSTEM01.DBF'


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\DEMO\SYSTEM01.DBF'

现在数据库可以到mount状态,请问可不可以重新创建'D:\ORACLE\ORADATA\DEMO\SYSTEM01.DBF'文件啊,如果可以的话,那会不会导致数据丢失?

所有的datafile都在


我按照操作出错:
SQL> alter database recover database using backup controlfile until cancel;
alter database recover database using backup controlfile until cancel
*
ERROR at line 1:
ORA-00279: change 1128592 generated at 11/26/2007 11:49:46 needed for thread 1
ORA-00289: suggestion : D:\ORACLE\ORADATA\DEMO\ARCHIVE\ARC00052.001
ORA-00280: change 1128592 for thread 1 is in sequence #52


gnalled during: ALTER DATABASE   MOUNT...
Mon Nov 26 14:50:58 2007
alter database mount
Mon Nov 26 14:51:03 2007
Successful mount of redo thread 1, with mount id 3383766290.
Mon Nov 26 14:51:03 2007
Database mounted in Exclusive Mode.
Completed: alter database mount
Mon Nov 26 14:52:42 2007
alter database recover database using backup controlfile until cancel
Mon Nov 26 14:52:42 2007
Media Recovery Start
Successfully started datafile 1 media recovery
Datafile #1: 'D:\ORACLE\ORADATA\DEMO\SYSTEM01.DBF'
Successfully started datafile 2 media recovery
Datafile #2: 'D:\ORACLE\ORADATA\DEMO\UNDOTBS01.DBF'
Successfully started datafile 3 media recovery
Datafile #3: 'D:\ORACLE\ORADATA\DEMO\CWMLITE01.DBF'
Successfully started datafile 4 media recovery
Datafile #4: 'D:\ORACLE\ORADATA\DEMO\DRSYS01.DBF'
Successfully started datafile 5 media recovery
Datafile #5: 'D:\ORACLE\ORADATA\DEMO\EXAMPLE01.DBF'
Successfully started datafile 6 media recovery
Datafile #6: 'D:\ORACLE\ORADATA\DEMO\INDX01.DBF'
Successfully started datafile 7 media recovery
Datafile #7: 'D:\ORACLE\ORADATA\DEMO\TOOLS01.DBF'
Successfully started datafile 8 media recovery
Datafile #8: 'D:\ORACLE\ORADATA\DEMO\CATALOG.DBF'
Successfully started datafile 9 media recovery
Datafile #9: 'D:\ORACLE\ORADATA\DEMO\PERFSTAT.DBF'
Successfully started datafile 10 media recovery
Datafile #10: 'D:\ORACLE\ORADATA\DEMO\USERS01.DBF'
Media Recovery Log
ORA-279 signalled during: alter database recover database using backup contr...
Mon Nov 26 14:53:36 2007
alter database recover database using backup controlfile until cancel
Mon Nov 26 14:53:36 2007
ORA-1153 signalled during: alter database recover database using backup contr...
Mon Nov 26 15:01:29 2007
alter database recover database using backup controlfile until cancel
Mon Nov 26 15:01:29 2007
ORA-1153 signalled during: alter database recover database using backup contr...
Mon Nov 26 15:01:43 2007
alter database recover database using backup controlfile until cancel
Mon Nov 26 15:01:43 2007
ORA-1153 signalled during: alter database recover database using backup contr...



还是报错:
SQL> recover database using backup controlfile until cancel;
ORA-01153: an incompatible media recovery is active


报错:
SQL> recover cancel;
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\DEMO\SYSTEM01.DBF'
我作:
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1128592 generated at 11/26/2007 11:49:46 needed for thread 1
ORA-00289: suggestion : D:\ORACLE\ORADATA\DEMO\ARCHIVE\ARC00052.001
ORA-00280: change 1128592 for thread 1 is in sequence #52


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

请问这要输入什么?

版主,
请问Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
是不是要输入对应的system表空间对应的数据文件?

那就输入online redo log的文件名
一个一个试……
请问这一步是为了找出在线的那个redo log吗?
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-23 15:41 , Processed in 0.049678 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569