跪求大神帮忙
点击联系发帖人
时间：2017-10-01 19:30
本帖子已过去太久远了，不再提供回复功能。跪求大神帮忙_图拉丁吧_百度贴吧
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&签到排名：今日本吧第个签到，本吧因你更精彩，明天继续来努力！
本吧签到人数：0成为超级会员，使用一键签到本月漏签0次！成为超级会员，赠送8张补签卡连续签到：天&&累计签到：天超级会员单次开通12个月以上，赠送连续签到卡3张
关注：1,438,978贴子：
跪求大神帮忙收藏
笔记本下边有一道白，浅颜色壁纸看不出来黑色能显出来。感觉整个屏幕有点发白。
车型齐全,品牌齐全,现车供应!
福利图，性欲强?快开车
翘屏漏光了
好的【拿到，把控制强度调到最大】
收集整理二十部重口味禁片电影 心里承受不足者请 慎入 1.
magnet:?xt=urn:btih:8f8fcfc480fb10e0a243e4d883d0d 东京残酷警察2. magnet:?xt=urn:btih:a1207b1accd8f691ab9 深喉3. magnet:?xt=urn:btih:7ad9501b16efb84f8bea18a7156f9 女虐5 magnet:?xt=urn:btih:e582e1ad4fba3b42a08 箱中女１+２(日语中字)6 magnet:?xt=urn:btih:50abee3546e6bbfd99838e9adef5cdf705c8daed 一个人和他的猪7 magnet:?xt=urn:btih:2bbb09d2b67881cc15
楢山节考8 magnet:?xt=urn:btih:010b02f170ad36afd9
鬼伎回忆录9 magnet:?xt=urn:btih:553f3eca2c393ad0da
切肤之爱10 magnet:?xt=urn:btih:a22a3b448f1d166dddf4d46abd1f9c3d4e572b37 地狱解剖11 magnet:?xt=urn:btih:ab3b733eabc63c5fa6c1
橡皮头12 magnet:?xt=urn:btih:2c19c94b0d80f008f 以藏13 magnet:?xt=urn:btih:468ac02edc0a2a7a03dfabfebdfcde 我唾弃你的坟墓3部全集14 magnet:?xt=urn:btih:e913aee1d044b02b242c杀人不分左右15 magnet:?xt=urn:btih:641cc7abb82c9ba36353cbeeb1d69b
刀的哲学16 magnet:?xt=urn:btih:02e57af296a001b08cae2 屠宰呕吐娃娃17 magnet:?xt=urn:btih:cc1d1ebb6e95d07b5fc3 慢性折磨呕吐室18 magnet:?xt=urn:btih:ca62d035fe0b76b50f 起源19 magnet:?xt=urn:btih:41df27d4d1ed516abcbfc94ab0f7e2 匹诺曹964号20 magnet:?xt=urn:btih:716e797feabb2b82d55c9bf370ecb5e4ef209c72 不死族
我是来问你门屏幕的问题怎么成开车了
登录百度帐号推荐应用查看: 2454|回复: 6
ORACLE11的ORA-01589，跪求大神帮帮忙
论坛徽章:0
本帖最后由 cghcgh950623 于
02:17 编辑
昨天正在用ORACLE的时候电脑突然蓝屏了，好不容易把电脑修好今天继续的时候发现用不了。然后看了一下结果就是：
3cb70e15a705cfa84bd.png (52.32 KB, 下载次数: 0)
02:15 上传
这个情况，百度了一下但是多数都像是9、10的。和11G的似乎不一样。
8d0d6a63f3c8eef81a4c500fa280.png (3.88 KB, 下载次数: 0)
02:15 上传
大多数都是通过recover解决，不过我的输出是这样的：
6f6435a85edf8db15a9f9cd80c23dd.png (38.85 KB, 下载次数: 0)
02:15 上传
ORA-00289的提示和百度上的不同，在这个路径下没有文件。
而继续下去百度的结果是：
ad2be4c086e06f00c.png (3.27 KB, 下载次数: 0)
02:15 上传
我在11G的路径下找到了REDO01.LOG、REDO02.LOG、REDO03.LOG依次的结果是：
ad2be2c26f15ac014c086f06f0b3.jpg (34.24 KB, 下载次数: 0)
02:14 上传
bfdfa513d.jpg (34.21 KB, 下载次数: 0)
02:14 上传
ce1bec8a786c9175c59.jpg (32.06 KB, 下载次数: 0)
02:14 上传
最后查看的结果还是：
QQ图片28.png (34.97 KB, 下载次数: 0)
02:14 上传
求问各位大神，是不是11G版本的不同才有这种情况
另外原本REDO03那里不知道为什么显示00339，原本今天一开始提示我的是日志文件损坏这类的问题，提示的是0，我百度搞定了，但现在是不是又错了。求大神帮忙
(34.97 KB, 下载次数: 32)
02:14 上传
(32.06 KB, 下载次数: 32)
02:14 上传
(34.21 KB, 下载次数: 32)
02:14 上传
(34.24 KB, 下载次数: 32)
02:14 上传
认证徽章论坛徽章:41
使用&&收集html信息发送过来
论坛徽章:5
STARTUP 时报&&ORA-1589时，你直接使用Alter database open NORESETLOGS 应该就可以正常打开数据库。
现在你可以试下使用Alter database open NORESETLOGS 是否可以正常打开数据库，如果打不开就要使用
recover database until cancel 进行恢复数据，不要使用&&recover database using backup controlfile 进行恢复
论坛徽章:5
ORA-376, ORA-01110 while Attempting to Open Database - NOARCHIVELOG Mode (文档 ID )
***Checked for relevance on 17-Jul-2014***
Problem Description
-------------------
Attempting to start the database results in the following at mount stage:
ORA-00604: Error occurred at recursive SQL level 1
ORA-00376: File 2 cannot be read at this time
ORA-01110: data file 2: 'd:\oracle\oradata\oracle\RBS01.dbf'
Database is running in NOARCHIVELOG mode, no corruption, and there is no cold backup.
Solution Explantion
--------------------
One option available is to fake a recovery to see what file(s) Oracle requires
to recover the database.&&If Oracle only requires the online redo logs then
database can be recovered and opened with no data loss.
From SQL*PLUS or SVRMGL:
Run the following query to determine sequence number of online redo logs:
SQL&select v1.group#,member,sequence#,first_change#
& &&&from v$log v1, v$logfile v2
& &&&where&&v1.group# = v2.group#;
Note the sequence number and member columns are of importance.
Next, attempt to recover database to see what file Oracle requires:
SQL&recover d
Again note the sequence number.&&Ignore the suggested logfile name.&&The name
will appear in the form of an archived log, but this is really the name of the
online redo log not yet archived.
If the lowest sequence number from the query results is the same as the
sequence number Oracle requires to recover database, then database can be
recovered.
Simply copy the exact path and filename from the member column as the filename
required by the RECOVER DATABASE command.
Repeat the process for each online redo log.
Oracle will return prompt, recovery completed.
At this point you can issue:
SQL& Alter database open
If ORA-1589 &must use RESETLOGS or NORESETLOGS option for database open&
SQL& & Alter database open NORESETLOGS
NOTE: The open may take a while to process.
References
----------
Additional Search Words
-----------------------
ORA-1110 recovery online redo logs noarchive
论坛徽章:5
Recover a ArcServe Backup of Oracle
此问题已回答。
nkammerer Newbie
Hai, we use ArcServe for our Backups. Now i try to recover a Oracle Database which is backed up with ArcServe.
Unfortunately it doesn´t work.
Here what i tried:
i created a database. with same name, same configuration ...
then i shutdown the oracle tasks (windows system) and delete all files of this &temp&-database
then i restored the database out of our ArcServe backup.
finaly i tried to start the database.
i got the following messages:
SQL& startup
ORACLE instance started.
Total System Global Area&& bytes
Fixed Size& && && && && && &1298184 bytes
Variable Size& && && && &
Database Buffers& && && &
Redo Buffers& && && && && & 2895872 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL& alter dat
alter database open resetlogs
ERROR at line 1:
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'E:\ORADATA\TEST\SYSTEM01.DBF'
SQL& recover datafile 1;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL& recover database usin
ORA-00279: change 459494 generated at 07/04/:32 needed for thread 1
ORA-00289: suggestion : F:\ORADATA\TEST\ARCH\ARC
ORA-00280: change 459494 for thread 1 is in sequence #22
Specify log: {&RET&=suggested | filename | AUTO | CANCEL}
ORA-00279: change 459659 generated at 07/04/:25 needed for thread 1
ORA-00289: suggestion : F:\ORADATA\TEST\ARCH\ARC
ORA-00280: change 459659 for thread 1 is in sequence #23
ORA-00278: log file 'F:\ORADATA\TEST\ARCH\ARC' no longer
needed for this recovery
Specify log: {&RET&=suggested | filename | AUTO | CANCEL}
Media recovery cancelled.
alter database open
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL& alter dat
alter database open resetlogs
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'E:\ORADATA\TEST\SYSTEM01.DBF'
The problem is, that there never was a sequence 23 of archive-logs.
somebody an idea how to recover the database?
or is it the wrong way for database recovery?
thanks a lot!
system: Windows Server 2003 R2
database: Oracle 10.2.0.4
正确答案 作者： nkammerer 在
I tested some things and now i know what happend.Apparently i used &recover database& without &until cancel&.
After that i were not able to open database without redolog.
Thank you all for your help!
查看上下文中的回答
& & 191 查看
& & 标签：
平均用户评级: 无评分 (0 评级)
平均用户评级
我的评级：
评分 差(1 / 5)
评分 中下(2 / 5)
评分 中等(3 / 5)
评分 中上(4 / 5)
评分 优(5 / 5)
& & 1. Re: Recover a ArcServe Backup of Oracle
& & VenkatB Legend
& & VenkatB
下午10:53 （回复 nkammerer）
& & Sequence 23 is already applied to the database.
& & Can you do exactly the following and show us the results? Instead of manual interaction, just set autorecovery on and do the recovery
& & Please make sure the database is MOUNTED.
& & SQL& set autorecovery ON
& & SQL& select * from v$
& & SQL& recover database using backup cont
& & Regards
& && &&&喜爱
& && &&&显示 0 喜欢
& && &&&(0) 回复
& && &&&操作
& & 2. Re: Recover a ArcServe Backup of Oracle
& & nkammerer Newbie
& & nkammerer
下午11:46 （回复 VenkatB）
& &&&Hai VenkatB,
& & here´s the output:
& & SQL& select status from v$
& & STATUS
& & ------------
& & MOUNTED
& & SQL& set autorecovery on
& & SQL& select * from v$
& && &&&GROUP#& & THREAD#&&SEQUENCE#& && &BYTES& & MEMBERS ARC STATUS
& & ---------- ---------- ---------- ---------- ---------- --- ----------------
& & FIRST_CHANGE# FIRST_TIM
& & ------------- ---------
& && && && & 1& && && & 1& && && &22& && && && & 1 NO&&CURRENT
& && && &&&-JUL-11
& && && && & 3& && && & 1& && && &21& && && && & 1 YES INACTIVE
& && && &&&-JUL-11
& && && && & 2& && && & 1& && && &20& && && && & 1 YES INACTIVE
& && && &&&-JUL-11
& & SQL& recover database using backup cont
& & ORA-00279: change 459659 generated at 07/04/:25 needed for thread 1
& & ORA-00289: suggestion : F:\ORADATA\TEST\ARCH\ARC
& & ORA-00280: change 459659 for thread 1 is in sequence #23
& & ORA-00308: cannot open archived log
& & 'F:\ORADATA\TEST\ARCH\ARC'
& & ORA-27041: unable to open file
& & OSD-04002: unable to open file
& & O/S-Error: (OS 2) The system cannot find the file specified.
& && &&&喜爱
& && &&&显示 0 喜欢
& && &&&(0) 回复
& && &&&操作
& & 3. Re: Recover a ArcServe Backup of Oracle
& & VenkatB Legend
& & VenkatB
上午12:03 （回复 nkammerer）
& & Think the change is still in the redo log and not archived yet. And backup controlfile will not know about this. So please try this
& & SQL& select member from v$logfile where group#=1;
& & Note down the log file with full path (For example, C:\ORACLE\ORADATA\REDO01.LOG)
& & SQL& set autorecovery off
& & SQL& recover database using backup cont
& & When it&&says Specify log: {&RET&=suggested | filename | AUTO | CANCEL}, just do this
& & Specify the full path of the log file. Example C:\ORACLE\ORADATA\REDO01.LOG
& & This should fix the recovery. Once successfully applied, do CANCEL (cancel the recovery) and open resetlogs
& & Regards
& && &&&喜爱
& && &&&显示 0 喜欢
& && &&&(0) 回复
& && &&&操作
& & 4. Re: Recover a ArcServe Backup of Oracle
& & user712697-Oracle Newbie
& & user712697-Oracle
上午12:17 （回复 nkammerer）
& & If there was never a seq 23 then the problem might be& && &
& & this backup was taken after a shutdown abort.& && &
& & You can also check if &archive log list& shows& && &
& & current log sequence as 1.&&If so, apply the online& && &
& & log.&&The minimum and maximum Seq needed should& && &
& & be in this query &select min(fhrba_Seq), max(fhrba_Seq)&&from X$KCVFH;&
& && &&&喜爱
& && &&&显示 0 喜欢
& && &&&(0) 回复
& && &&&操作
& & 5. Re: Recover a ArcServe Backup of Oracle
& & nkammerer Newbie
& & nkammerer
下午5:10 （回复 VenkatB）
& &&&Hai, which redo log should i use?
& & from the original database or from the temp database?
& & The redo log of the original database doesn´t exist.
& && &&&喜爱
& && &&&显示 0 喜欢
& && &&&(0) 回复
& && &&&操作
& & 6. Re: Recover a ArcServe Backup of Oracle
& & nkammerer Newbie
& & nkammerer
下午5:12 （回复 user712697-Oracle）
& & Hai, i used your query to check which seq i need.
& & here´s the output:
& & SQL& select min(fhrba_Seq), max(fhrba_Seq)&&from X$KCVFH;
& & MIN(FHRBA_SEQ) MAX(FHRBA_SEQ)
& & --------------& && && && && &--------------
& & 23& && && && && && && && &&&23
& && &&&喜爱
& && &&&显示 0 喜欢
& && &&&(0) 回复
& && &&&操作
& & 7. Re: Recover a ArcServe Backup of Oracle
& & user Rookie
& & user1-7-6 上午2:09 （回复 nkammerer）
& &&&You have to apply the current redo log as Venkatb said .
& & select a.member, b.status from v$logfile a, v$log b
& & where a.group# = b.group# and b.status='CURRENT'
& & -- this select will give you current redo to apply in recovery process
& && &&&喜爱
& && &&&显示 0 喜欢
& && &&&(0) 回复
& && &&&操作
& & 8. Re: Recover a ArcServe Backup of Oracle
& & nkammerer Newbie
& & nkammerer
下午6:58 （回复 user）
& &&&Hai, i do what Venkatb said.
& & Here´s the output:
& & SQL& select member from v$logfile where group#=1;
& & MEMBER
& & --------------------------------------------------------------------------------
& & E:\ORADATA\TEST\REDO01.LOG
& & SQL& set autorecovery off
& & SQL& recover database using backup cont
& & ORA-00279: change 459659 generated at 07/04/:25 needed for thread 1
& & ORA-00289: suggestion : F:\ORADATA\TEST\ARCH\ARC
& & ORA-00280: change 459659 for thread 1 is in sequence #23
& & Specify log: {&RET&=suggested | filename | AUTO | CANCEL}
& & E:\oradata\test\REDO01.LOG
& & ORA-00310: archived log contains sequence 22; sequence 23 required
& & ORA-00334: archived log: 'E:\ORADATA\TEST\REDO01.LOG'
& & Then i used the select from Oracle First .. SQL Server Later and this is the output:
& & SQL& select a.member, b.status from v$logfile a, v$log b
& && &2&&where a.group# = b.group# and b.status='CURRENT' ;
& & MEMBER
& & --------------------------------------------------------------------------------
& & STATUS
& & ----------------
& & E:\ORADATA\TEST\REDO01.LOG
& & CURRENT
& & Somebody an idea, what i can do now?
& && &&&喜爱
& && &&&显示 0 喜欢
& && &&&(0) 回复
& && &&&操作
& & 9. Re: Recover a ArcServe Backup of Oracle
& & user Rookie
& & user1-7-6 下午7:35 （回复 nkammerer）
& & I would do 2 things .&&( yo have allready tried a lot & && &).
& & 1 ) read this Note . I think it can help you .
& & How to recover and open the database if the archivelog required for recovery is either missing, lost or corrupted? [ID ]& && && &&&
& && && && &&&
& & 2 )& && && &&&
& & It has been suggested in another post on this thread that a &shutdown abort& has ocurred . So maybe Arcserve was issuing a backup ( begin backup ..end backup for all tablespaces ) , and some of your datafiles remains in backup mode .& && && &&&
& && && && &&&
& & I have seen case , that db would not open if datafiles/tablespaces are in backup mode .& && && && &
& && && && &&&
& & SQL& STARTUP MOUNT .& && && &&&
& & sql & SELECT * FROM V$BACKUP WHERE STATUS ='ACTIVE'& &--- will give you datafiles in backup mode .& && && &&&
& & SQL&&&ALTER DATAFILE 'C:/ORACLE/ ETC&&ETC ' END BACKUP;&&or even&&ALTER DATABASE END BACKUP;& && && &&&
& & SQL & ALTER DATABASE OPEN:& && && &&&
& && && && &&&
& & Good Luck&&nkammerer& && && && && && && && && && && && &
& && && && &&&
& && && && &&&
& && && && &&&
& && && && &&&
& && && && &&&
& && && && &&&
& && && && &&&
& && && && &&&
& && && && &&&
& && && && &&&
& && &&&喜爱
& && &&&显示 0 喜欢
& && &&&(0) 回复
& && &&&操作
& & 10. Re: Recover a ArcServe Backup of Oracle
& & nkammerer Newbie
& & nkammerer
下午8:38 （回复 user）
& & 1. i will read this note.
& & 2. select * from v$backup where status='active' brings &no rows selected&
& & can this select work? i try to recover a database out of our arcserve backup into a new / emtpy database.
& & so i created a new database and replace all files with the files in the arcserve backup.
& & another question.
& & is this the right way for a recovery?
& && &&&喜爱
& && &&&显示 0 喜欢
& && &&&(0) 回复
& && &&&操作
& & 11. Re: Recover a ArcServe Backup of Oracle
& & nkammerer Newbie
& & nkammerer
下午11:30 （回复 nkammerer）
& &&&Now it works!
& & i tested to recover with all redo-logs.
& & here´s the output:
& & SQL& select a.member, b.status from v$logfile a, v$log b
& && &2&&where a.group# = b.group# and b.status='CURRENT' ;
& & MEMBER
& & --------------------------------------------------------------------------------
& & STATUS
& & ----------------
& & E:\ORADATA\TEST\REDO01.LOG
& & CURRENT
& & SQL& recover database using backup cont
& & ORA-00279: change 459659 generated at 07/04/:25 needed for thread 1
& & ORA-00289: suggestion : F:\ORADATA\TEST\ARCH\ARC
& & ORA-00280: change 459659 for thread 1 is in sequence #23
& & Specify log: {&RET&=suggested | filename | AUTO | CANCEL}
& & E:\oradata\test\REDO01.LOG
& & ORA-00310: archived log contains sequence 22; sequence 23 required
& & ORA-00334: archived log: 'E:\ORADATA\TEST\REDO01.LOG'
& & SQL& recover database using backup cont
& & ORA-00279: change 459659 generated at 07/04/:25 needed for thread 1
& & ORA-00289: suggestion : F:\ORADATA\TEST\ARCH\ARC
& & ORA-00280: change 459659 for thread 1 is in sequence #23
& & Specify log: {&RET&=suggested | filename | AUTO | CANCEL}
& & E:\oradata\test\REDO02.LOG
& & ORA-00279: change 495621 generated at 07/05/:46 needed for thread 1
& & ORA-00289: suggestion : F:\ORADATA\TEST\ARCH\ARC
& & ORA-00280: change 495621 for thread 1 is in sequence #24
& & ORA-00278: log file 'E:\oradata\test\REDO02.LOG' no longer needed for this
& & recovery
& & Specify log: {&RET&=suggested | filename | AUTO | CANCEL}
& & E:\oradata\test\REDO03.LOG
& & Log applied.
& & Media recovery complete.
& & SQL& alter dat
& & Database altered.
& & somebody an idea, how this works?
& & i thought the current redolog have to be newer than the other...
& && &&&喜爱
& && &&&显示 0 喜欢
& && &&&(0) 回复
& && &&&操作
& & 正确答案 12. Re: Recover a ArcServe Backup of Oracle
& & nkammerer Newbie
& & nkammerer
下午5:57 （回复 nkammerer）
& & I tested some things and now i know what happend.Apparently i used &recover database& without &until cancel&.
& & After that i were not able to open database without redolog.
& & Thank you all for your help!
论坛徽章:5
To take tablespaces out of backup mode simultaneously:
1.& & & & Mount but do not open the database. For example, enter:
2.& & & & SQL& STARTUP MOUNT
3.& & & & If you are performing this procedure manually (that is, not as part of a failure recovery script), query the V$BACKUP view to list the data files of the tablespaces that were being backed up before the database was restarted:
4.& & & & SQL&&&SELECT * FROM V$BACKUP WHERE STATUS = 'ACTIVE';
5.& & & & FILE#& && &STATUS& && && && & CHANGE#& & TIME& &&&
6.& & & & ---------- ------------------ ---------- ---------
7.& & & && && && &12 ACTIVE& && && && && && &20863 25-NOV-02
8.& & & && && && &13 ACTIVE& && && && && && &20863 25-NOV-02
9.& & & && && && &20 ACTIVE& && && && && && &20863 25-NOV-02
10.& & & &&&3 rows selected.
11.& & & & Issue the ALTER DATABASE END BACKUP statement to take all data files currently in backup mode out of backup mode. For example, enter:
12.& & & & SQL& ALTER DATABASE END BACKUP;
认证徽章论坛徽章:0
这个问题我以前好像也遇到过，可能是备份集中日志文件和控制文件不匹配的问题，建议从这里找一下问题。
itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有
北京市公安局海淀分局网监中心备案编号：10 广播电视节目制作经营许可证：编号（京）字第1149号}
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&签到排名：今日本吧第个签到，本吧因你更精彩，明天继续来努力！
本吧签到人数：0成为超级会员，使用一键签到本月漏签0次！成为超级会员，赠送8张补签卡连续签到：天&&累计签到：天超级会员单次开通12个月以上，赠送连续签到卡3张
关注：1,438,978贴子：
跪求大神帮忙收藏
笔记本下边有一道白，浅颜色壁纸看不出来黑色能显出来。感觉整个屏幕有点发白。
车型齐全,品牌齐全,现车供应!
福利图，性欲强?快开车
翘屏漏光了
好的【拿到，把控制强度调到最大】
收集整理二十部重口味禁片电影 心里承受不足者请 慎入 1.
magnet:?xt=urn:btih:8f8fcfc480fb10e0a243e4d883d0d 东京残酷警察2. magnet:?xt=urn:btih:a1207b1accd8f691ab9 深喉3. magnet:?xt=urn:btih:7ad9501b16efb84f8bea18a7156f9 女虐5 magnet:?xt=urn:btih:e582e1ad4fba3b42a08 箱中女１+２(日语中字)6 magnet:?xt=urn:btih:50abee3546e6bbfd99838e9adef5cdf705c8daed 一个人和他的猪7 magnet:?xt=urn:btih:2bbb09d2b67881cc15
楢山节考8 magnet:?xt=urn:btih:010b02f170ad36afd9
鬼伎回忆录9 magnet:?xt=urn:btih:553f3eca2c393ad0da
切肤之爱10 magnet:?xt=urn:btih:a22a3b448f1d166dddf4d46abd1f9c3d4e572b37 地狱解剖11 magnet:?xt=urn:btih:ab3b733eabc63c5fa6c1
橡皮头12 magnet:?xt=urn:btih:2c19c94b0d80f008f 以藏13 magnet:?xt=urn:btih:468ac02edc0a2a7a03dfabfebdfcde 我唾弃你的坟墓3部全集14 magnet:?xt=urn:btih:e913aee1d044b02b242c杀人不分左右15 magnet:?xt=urn:btih:641cc7abb82c9ba36353cbeeb1d69b
刀的哲学16 magnet:?xt=urn:btih:02e57af296a001b08cae2 屠宰呕吐娃娃17 magnet:?xt=urn:btih:cc1d1ebb6e95d07b5fc3 慢性折磨呕吐室18 magnet:?xt=urn:btih:ca62d035fe0b76b50f 起源19 magnet:?xt=urn:btih:41df27d4d1ed516abcbfc94ab0f7e2 匹诺曹964号20 magnet:?xt=urn:btih:716e797feabb2b82d55c9bf370ecb5e4ef209c72 不死族
我是来问你门屏幕的问题怎么成开车了
登录百度帐号推荐应用查看: 2454|回复: 6
ORACLE11的ORA-01589，跪求大神帮帮忙
论坛徽章:0
本帖最后由 cghcgh950623 于
02:17 编辑
昨天正在用ORACLE的时候电脑突然蓝屏了，好不容易把电脑修好今天继续的时候发现用不了。然后看了一下结果就是：
3cb70e15a705cfa84bd.png (52.32 KB, 下载次数: 0)
02:15 上传
这个情况，百度了一下但是多数都像是9、10的。和11G的似乎不一样。
8d0d6a63f3c8eef81a4c500fa280.png (3.88 KB, 下载次数: 0)
02:15 上传
大多数都是通过recover解决，不过我的输出是这样的：
6f6435a85edf8db15a9f9cd80c23dd.png (38.85 KB, 下载次数: 0)
02:15 上传
ORA-00289的提示和百度上的不同，在这个路径下没有文件。
而继续下去百度的结果是：
ad2be4c086e06f00c.png (3.27 KB, 下载次数: 0)
02:15 上传
我在11G的路径下找到了REDO01.LOG、REDO02.LOG、REDO03.LOG依次的结果是：
ad2be2c26f15ac014c086f06f0b3.jpg (34.24 KB, 下载次数: 0)
02:14 上传
bfdfa513d.jpg (34.21 KB, 下载次数: 0)
02:14 上传
ce1bec8a786c9175c59.jpg (32.06 KB, 下载次数: 0)
02:14 上传
最后查看的结果还是：
QQ图片28.png (34.97 KB, 下载次数: 0)
02:14 上传
求问各位大神，是不是11G版本的不同才有这种情况
另外原本REDO03那里不知道为什么显示00339，原本今天一开始提示我的是日志文件损坏这类的问题，提示的是0，我百度搞定了，但现在是不是又错了。求大神帮忙
(34.97 KB, 下载次数: 32)
02:14 上传
(32.06 KB, 下载次数: 32)
02:14 上传
(34.21 KB, 下载次数: 32)
02:14 上传
(34.24 KB, 下载次数: 32)
02:14 上传
认证徽章论坛徽章:41
使用&&收集html信息发送过来
论坛徽章:5
STARTUP 时报&&ORA-1589时，你直接使用Alter database open NORESETLOGS 应该就可以正常打开数据库。
现在你可以试下使用Alter database open NORESETLOGS 是否可以正常打开数据库，如果打不开就要使用
recover database until cancel 进行恢复数据，不要使用&&recover database using backup controlfile 进行恢复
论坛徽章:5
ORA-376, ORA-01110 while Attempting to Open Database - NOARCHIVELOG Mode (文档 ID )
***Checked for relevance on 17-Jul-2014***
Problem Description
-------------------
Attempting to start the database results in the following at mount stage:
ORA-00604: Error occurred at recursive SQL level 1
ORA-00376: File 2 cannot be read at this time
ORA-01110: data file 2: 'd:\oracle\oradata\oracle\RBS01.dbf'
Database is running in NOARCHIVELOG mode, no corruption, and there is no cold backup.
Solution Explantion
--------------------
One option available is to fake a recovery to see what file(s) Oracle requires
to recover the database.&&If Oracle only requires the online redo logs then
database can be recovered and opened with no data loss.
From SQL*PLUS or SVRMGL:
Run the following query to determine sequence number of online redo logs:
SQL&select v1.group#,member,sequence#,first_change#
& &&&from v$log v1, v$logfile v2
& &&&where&&v1.group# = v2.group#;
Note the sequence number and member columns are of importance.
Next, attempt to recover database to see what file Oracle requires:
SQL&recover d
Again note the sequence number.&&Ignore the suggested logfile name.&&The name
will appear in the form of an archived log, but this is really the name of the
online redo log not yet archived.
If the lowest sequence number from the query results is the same as the
sequence number Oracle requires to recover database, then database can be
recovered.
Simply copy the exact path and filename from the member column as the filename
required by the RECOVER DATABASE command.
Repeat the process for each online redo log.
Oracle will return prompt, recovery completed.
At this point you can issue:
SQL& Alter database open
If ORA-1589 &must use RESETLOGS or NORESETLOGS option for database open&
SQL& & Alter database open NORESETLOGS
NOTE: The open may take a while to process.
References
----------
Additional Search Words
-----------------------
ORA-1110 recovery online redo logs noarchive
论坛徽章:5
Recover a ArcServe Backup of Oracle
此问题已回答。
nkammerer Newbie
Hai, we use ArcServe for our Backups. Now i try to recover a Oracle Database which is backed up with ArcServe.
Unfortunately it doesn´t work.
Here what i tried:
i created a database. with same name, same configuration ...
then i shutdown the oracle tasks (windows system) and delete all files of this &temp&-database
then i restored the database out of our ArcServe backup.
finaly i tried to start the database.
i got the following messages:
SQL& startup
ORACLE instance started.
Total System Global Area&& bytes
Fixed Size& && && && && && &1298184 bytes
Variable Size& && && && &
Database Buffers& && && &
Redo Buffers& && && && && & 2895872 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL& alter dat
alter database open resetlogs
ERROR at line 1:
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'E:\ORADATA\TEST\SYSTEM01.DBF'
SQL& recover datafile 1;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL& recover database usin
ORA-00279: change 459494 generated at 07/04/:32 needed for thread 1
ORA-00289: suggestion : F:\ORADATA\TEST\ARCH\ARC
ORA-00280: change 459494 for thread 1 is in sequence #22
Specify log: {&RET&=suggested | filename | AUTO | CANCEL}
ORA-00279: change 459659 generated at 07/04/:25 needed for thread 1
ORA-00289: suggestion : F:\ORADATA\TEST\ARCH\ARC
ORA-00280: change 459659 for thread 1 is in sequence #23
ORA-00278: log file 'F:\ORADATA\TEST\ARCH\ARC' no longer
needed for this recovery
Specify log: {&RET&=suggested | filename | AUTO | CANCEL}
Media recovery cancelled.
alter database open
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL& alter dat
alter database open resetlogs
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'E:\ORADATA\TEST\SYSTEM01.DBF'
The problem is, that there never was a sequence 23 of archive-logs.
somebody an idea how to recover the database?
or is it the wrong way for database recovery?
thanks a lot!
system: Windows Server 2003 R2
database: Oracle 10.2.0.4
正确答案 作者： nkammerer 在
I tested some things and now i know what happend.Apparently i used &recover database& without &until cancel&.
After that i were not able to open database without redolog.
Thank you all for your help!
查看上下文中的回答
& & 191 查看
& & 标签：
平均用户评级: 无评分 (0 评级)
平均用户评级
我的评级：
评分 差(1 / 5)
评分 中下(2 / 5)
评分 中等(3 / 5)
评分 中上(4 / 5)
评分 优(5 / 5)
& & 1. Re: Recover a ArcServe Backup of Oracle
& & VenkatB Legend
& & VenkatB
下午10:53 （回复 nkammerer）
& & Sequence 23 is already applied to the database.
& & Can you do exactly the following and show us the results? Instead of manual interaction, just set autorecovery on and do the recovery
& & Please make sure the database is MOUNTED.
& & SQL& set autorecovery ON
& & SQL& select * from v$
& & SQL& recover database using backup cont
& & Regards
& && &&&喜爱
& && &&&显示 0 喜欢
& && &&&(0) 回复
& && &&&操作
& & 2. Re: Recover a ArcServe Backup of Oracle
& & nkammerer Newbie
& & nkammerer
下午11:46 （回复 VenkatB）
& &&&Hai VenkatB,
& & here´s the output:
& & SQL& select status from v$
& & STATUS
& & ------------
& & MOUNTED
& & SQL& set autorecovery on
& & SQL& select * from v$
& && &&&GROUP#& & THREAD#&&SEQUENCE#& && &BYTES& & MEMBERS ARC STATUS
& & ---------- ---------- ---------- ---------- ---------- --- ----------------
& & FIRST_CHANGE# FIRST_TIM
& & ------------- ---------
& && && && & 1& && && & 1& && && &22& && && && & 1 NO&&CURRENT
& && && &&&-JUL-11
& && && && & 3& && && & 1& && && &21& && && && & 1 YES INACTIVE
& && && &&&-JUL-11
& && && && & 2& && && & 1& && && &20& && && && & 1 YES INACTIVE
& && && &&&-JUL-11
& & SQL& recover database using backup cont
& & ORA-00279: change 459659 generated at 07/04/:25 needed for thread 1
& & ORA-00289: suggestion : F:\ORADATA\TEST\ARCH\ARC
& & ORA-00280: change 459659 for thread 1 is in sequence #23
& & ORA-00308: cannot open archived log
& & 'F:\ORADATA\TEST\ARCH\ARC'
& & ORA-27041: unable to open file
& & OSD-04002: unable to open file
& & O/S-Error: (OS 2) The system cannot find the file specified.
& && &&&喜爱
& && &&&显示 0 喜欢
& && &&&(0) 回复
& && &&&操作
& & 3. Re: Recover a ArcServe Backup of Oracle
& & VenkatB Legend
& & VenkatB
上午12:03 （回复 nkammerer）
& & Think the change is still in the redo log and not archived yet. And backup controlfile will not know about this. So please try this
& & SQL& select member from v$logfile where group#=1;
& & Note down the log file with full path (For example, C:\ORACLE\ORADATA\REDO01.LOG)
& & SQL& set autorecovery off
& & SQL& recover database using backup cont
& & When it&&says Specify log: {&RET&=suggested | filename | AUTO | CANCEL}, just do this
& & Specify the full path of the log file. Example C:\ORACLE\ORADATA\REDO01.LOG
& & This should fix the recovery. Once successfully applied, do CANCEL (cancel the recovery) and open resetlogs
& & Regards
& && &&&喜爱
& && &&&显示 0 喜欢
& && &&&(0) 回复
& && &&&操作
& & 4. Re: Recover a ArcServe Backup of Oracle
& & user712697-Oracle Newbie
& & user712697-Oracle
上午12:17 （回复 nkammerer）
& & If there was never a seq 23 then the problem might be& && &
& & this backup was taken after a shutdown abort.& && &
& & You can also check if &archive log list& shows& && &
& & current log sequence as 1.&&If so, apply the online& && &
& & log.&&The minimum and maximum Seq needed should& && &
& & be in this query &select min(fhrba_Seq), max(fhrba_Seq)&&from X$KCVFH;&
& && &&&喜爱
& && &&&显示 0 喜欢
& && &&&(0) 回复
& && &&&操作
& & 5. Re: Recover a ArcServe Backup of Oracle
& & nkammerer Newbie
& & nkammerer
下午5:10 （回复 VenkatB）
& &&&Hai, which redo log should i use?
& & from the original database or from the temp database?
& & The redo log of the original database doesn´t exist.
& && &&&喜爱
& && &&&显示 0 喜欢
& && &&&(0) 回复
& && &&&操作
& & 6. Re: Recover a ArcServe Backup of Oracle
& & nkammerer Newbie
& & nkammerer
下午5:12 （回复 user712697-Oracle）
& & Hai, i used your query to check which seq i need.
& & here´s the output:
& & SQL& select min(fhrba_Seq), max(fhrba_Seq)&&from X$KCVFH;
& & MIN(FHRBA_SEQ) MAX(FHRBA_SEQ)
& & --------------& && && && && &--------------
& & 23& && && && && && && && &&&23
& && &&&喜爱
& && &&&显示 0 喜欢
& && &&&(0) 回复
& && &&&操作
& & 7. Re: Recover a ArcServe Backup of Oracle
& & user Rookie
& & user1-7-6 上午2:09 （回复 nkammerer）
& &&&You have to apply the current redo log as Venkatb said .
& & select a.member, b.status from v$logfile a, v$log b
& & where a.group# = b.group# and b.status='CURRENT'
& & -- this select will give you current redo to apply in recovery process
& && &&&喜爱
& && &&&显示 0 喜欢
& && &&&(0) 回复
& && &&&操作
& & 8. Re: Recover a ArcServe Backup of Oracle
& & nkammerer Newbie
& & nkammerer
下午6:58 （回复 user）
& &&&Hai, i do what Venkatb said.
& & Here´s the output:
& & SQL& select member from v$logfile where group#=1;
& & MEMBER
& & --------------------------------------------------------------------------------
& & E:\ORADATA\TEST\REDO01.LOG
& & SQL& set autorecovery off
& & SQL& recover database using backup cont
& & ORA-00279: change 459659 generated at 07/04/:25 needed for thread 1
& & ORA-00289: suggestion : F:\ORADATA\TEST\ARCH\ARC
& & ORA-00280: change 459659 for thread 1 is in sequence #23
& & Specify log: {&RET&=suggested | filename | AUTO | CANCEL}
& & E:\oradata\test\REDO01.LOG
& & ORA-00310: archived log contains sequence 22; sequence 23 required
& & ORA-00334: archived log: 'E:\ORADATA\TEST\REDO01.LOG'
& & Then i used the select from Oracle First .. SQL Server Later and this is the output:
& & SQL& select a.member, b.status from v$logfile a, v$log b
& && &2&&where a.group# = b.group# and b.status='CURRENT' ;
& & MEMBER
& & --------------------------------------------------------------------------------
& & STATUS
& & ----------------
& & E:\ORADATA\TEST\REDO01.LOG
& & CURRENT
& & Somebody an idea, what i can do now?
& && &&&喜爱
& && &&&显示 0 喜欢
& && &&&(0) 回复
& && &&&操作
& & 9. Re: Recover a ArcServe Backup of Oracle
& & user Rookie
& & user1-7-6 下午7:35 （回复 nkammerer）
& & I would do 2 things .&&( yo have allready tried a lot & && &).
& & 1 ) read this Note . I think it can help you .
& & How to recover and open the database if the archivelog required for recovery is either missing, lost or corrupted? [ID ]& && && &&&
& && && && &&&
& & 2 )& && && &&&
& & It has been suggested in another post on this thread that a &shutdown abort& has ocurred . So maybe Arcserve was issuing a backup ( begin backup ..end backup for all tablespaces ) , and some of your datafiles remains in backup mode .& && && &&&
& && && && &&&
& & I have seen case , that db would not open if datafiles/tablespaces are in backup mode .& && && && &
& && && && &&&
& & SQL& STARTUP MOUNT .& && && &&&
& & sql & SELECT * FROM V$BACKUP WHERE STATUS ='ACTIVE'& &--- will give you datafiles in backup mode .& && && &&&
& & SQL&&&ALTER DATAFILE 'C:/ORACLE/ ETC&&ETC ' END BACKUP;&&or even&&ALTER DATABASE END BACKUP;& && && &&&
& & SQL & ALTER DATABASE OPEN:& && && &&&
& && && && &&&
& & Good Luck&&nkammerer& && && && && && && && && && && && &
& && && && &&&
& && && && &&&
& && && && &&&
& && && && &&&
& && && && &&&
& && && && &&&
& && && && &&&
& && && && &&&
& && && && &&&
& && && && &&&
& && &&&喜爱
& && &&&显示 0 喜欢
& && &&&(0) 回复
& && &&&操作
& & 10. Re: Recover a ArcServe Backup of Oracle
& & nkammerer Newbie
& & nkammerer
下午8:38 （回复 user）
& & 1. i will read this note.
& & 2. select * from v$backup where status='active' brings &no rows selected&
& & can this select work? i try to recover a database out of our arcserve backup into a new / emtpy database.
& & so i created a new database and replace all files with the files in the arcserve backup.
& & another question.
& & is this the right way for a recovery?
& && &&&喜爱
& && &&&显示 0 喜欢
& && &&&(0) 回复
& && &&&操作
& & 11. Re: Recover a ArcServe Backup of Oracle
& & nkammerer Newbie
& & nkammerer
下午11:30 （回复 nkammerer）
& &&&Now it works!
& & i tested to recover with all redo-logs.
& & here´s the output:
& & SQL& select a.member, b.status from v$logfile a, v$log b
& && &2&&where a.group# = b.group# and b.status='CURRENT' ;
& & MEMBER
& & --------------------------------------------------------------------------------
& & STATUS
& & ----------------
& & E:\ORADATA\TEST\REDO01.LOG
& & CURRENT
& & SQL& recover database using backup cont
& & ORA-00279: change 459659 generated at 07/04/:25 needed for thread 1
& & ORA-00289: suggestion : F:\ORADATA\TEST\ARCH\ARC
& & ORA-00280: change 459659 for thread 1 is in sequence #23
& & Specify log: {&RET&=suggested | filename | AUTO | CANCEL}
& & E:\oradata\test\REDO01.LOG
& & ORA-00310: archived log contains sequence 22; sequence 23 required
& & ORA-00334: archived log: 'E:\ORADATA\TEST\REDO01.LOG'
& & SQL& recover database using backup cont
& & ORA-00279: change 459659 generated at 07/04/:25 needed for thread 1
& & ORA-00289: suggestion : F:\ORADATA\TEST\ARCH\ARC
& & ORA-00280: change 459659 for thread 1 is in sequence #23
& & Specify log: {&RET&=suggested | filename | AUTO | CANCEL}
& & E:\oradata\test\REDO02.LOG
& & ORA-00279: change 495621 generated at 07/05/:46 needed for thread 1
& & ORA-00289: suggestion : F:\ORADATA\TEST\ARCH\ARC
& & ORA-00280: change 495621 for thread 1 is in sequence #24
& & ORA-00278: log file 'E:\oradata\test\REDO02.LOG' no longer needed for this
& & recovery
& & Specify log: {&RET&=suggested | filename | AUTO | CANCEL}
& & E:\oradata\test\REDO03.LOG
& & Log applied.
& & Media recovery complete.
& & SQL& alter dat
& & Database altered.
& & somebody an idea, how this works?
& & i thought the current redolog have to be newer than the other...
& && &&&喜爱
& && &&&显示 0 喜欢
& && &&&(0) 回复
& && &&&操作
& & 正确答案 12. Re: Recover a ArcServe Backup of Oracle
& & nkammerer Newbie
& & nkammerer
下午5:57 （回复 nkammerer）
& & I tested some things and now i know what happend.Apparently i used &recover database& without &until cancel&.
& & After that i were not able to open database without redolog.
& & Thank you all for your help!
论坛徽章:5
To take tablespaces out of backup mode simultaneously:
1.& & & & Mount but do not open the database. For example, enter:
2.& & & & SQL& STARTUP MOUNT
3.& & & & If you are performing this procedure manually (that is, not as part of a failure recovery script), query the V$BACKUP view to list the data files of the tablespaces that were being backed up before the database was restarted:
4.& & & & SQL&&&SELECT * FROM V$BACKUP WHERE STATUS = 'ACTIVE';
5.& & & & FILE#& && &STATUS& && && && & CHANGE#& & TIME& &&&
6.& & & & ---------- ------------------ ---------- ---------
7.& & & && && && &12 ACTIVE& && && && && && &20863 25-NOV-02
8.& & & && && && &13 ACTIVE& && && && && && &20863 25-NOV-02
9.& & & && && && &20 ACTIVE& && && && && && &20863 25-NOV-02
10.& & & &&&3 rows selected.
11.& & & & Issue the ALTER DATABASE END BACKUP statement to take all data files currently in backup mode out of backup mode. For example, enter:
12.& & & & SQL& ALTER DATABASE END BACKUP;
认证徽章论坛徽章:0
这个问题我以前好像也遇到过，可能是备份集中日志文件和控制文件不匹配的问题，建议从这里找一下问题。
itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有
北京市公安局海淀分局网监中心备案编号：10 广播电视节目制作经营许可证：编号（京）字第1149号}
我要回帖
更多推荐
- ·一枪毙命封神榜游戏攻略图文双火焰枪在哪的略
- ·王者荣耀什么英雄可以压制王昭君君怎么对付？
- ·原神如何做任务必要手续任务怎么做_必要手续任务完成攻略
- ·请问，这是哪部电视剧所有女演员名单，女演员是谁。谢谢！
- ·香港火葬场火化炉和殡仪馆的区别
- ·1、2、3。和1、2、3。哪个标点符号的正确用法图正确
- ·宝宝脸很红,有点烧,一直喊头疼头晕是怎么回事,精神不振,还说肚子疼
- ·科目二打转向灯三考试起步是打左转向灯还是右转向灯？
- ·se-no是美剧中no翻译的是是为1、2还是1、2、3
- ·在国外 可以做雅思教师官方培训课程吗？
- ·8+410分之3和6分之1通分就是 是1分之8+410分之3和6分之1通分通分是410分之3和6分之1通分2+410分之3和6分之1通分对吗 加起来是 410分之3和6分之1通分5 是吧
- ·se-no的日文的怎么写怎么写
- ·小右手臂胀痛是早期癌症酸胀痛侧身睡稍有点压到就更严重是怎么了？
- ·5个字php去掉最后一个字符是后字
- ·水塔花1的水如下图流入水塔花2，为什么？
- ·大艺家用电钻品牌是牌子吗
- ·汕头新太阳理疗美女的鹏发理疗中心在金沙乡哪里，有没有具体地址，高德地图能查到的，附近的也行
- ·大艺锂大艺12v充电电钻怎么样样
- ·亚急性硬膜外血肿ct特点下血肿可以保守治疗吗
- ·跪求大神帮忙
- ·11086beijingsaiche【江苏7江苏体彩七位数走势图图】中二位数多少钱?
- ·混泥土板面能否用圆钢代替圆钢与螺纹钢的符号
- ·不懂就问，学自动控制原理课程设计应该先学好哪些课
- ·关于科希曼空气能电器有限公司：两年前， 购 了一台200L科希曼空气能 空气能热水器，如今出了问题，大家看看。
- ·招行信用卡逾期一天几天算正常还款？
- ·改得是机制,变得是思想联通机制。下一句是什么
- ·求积分，如图求种
- ·2013款1.6速腾前宝马1系车轮异响有异响，就像宝马1系车轮异响里搅进铁丝的声音，行驶一段时间会消失
- ·ios10下载企业级软件时，显示ios此时无法安装程序下载APP，可选择按钮，完成重试
- ·宝宝十个月口有味白带有味道是怎么回事事
- ·林超伦实战口译好吗用英语怎么说
- ·十年烟龄的肺不到三年我妈带我去医院检查肺，会不会被发现
- ·丙谷谷丙转氨酶比值偏低偏高，高密度脂蛋白偏低是什么原因
- ·广渠路34号院什么项目7号院？
