DB无法open,请帮忙！
报错如下：
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吗？
页:
[1]