Xref: alice comp.databases.oracle.server:47274 Path: alice!news-feed.fnsi.net!netnews.com!newspeer1.nac.net!news.maxwell.syr.edu!nntp2.dejanews.com!nnrp1.dejanews.com!not-for-mail From: gmei@my-dejanews.com Newsgroups: comp.databases.oracle.server Subject: Oracle Recovery Error Date: Mon, 26 Apr 1999 17:19:53 GMT Organization: Deja News - The Leader in Internet Discussion Lines: 89 Message-ID: <7g277j$nqh$1@nnrp1.dejanews.com> X-Article-Creation-Date: Mon Apr 26 17:19:53 1999 GMT X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT) X-Http-Proxy: 1.1 x2.dejanews.com:80 (Squid/1.1.22) for client 209.51.243.142 Hi: A couple of days ago, I posted a message asking about how to do recovery using control file. Thanks for the people who answered my questions. Now I have tried to go through a recovery process to see if everything works on our system. 1. First I checked if there is any archived redo log files : orasrv1> pwd /ora02/oradata/PAV1_logarchive orasrv1> ls -ltr -rw-r----- 1 oracle dba 1049600 Apr 26 09:13 pav1archS0000000144.arc 2. I shutdown the database, did a cold backup of all the files (datafiles, control files, logfils, init.ora). saved the backup files and “startup open” the db again. 3. I run a oracle package which run a “update” statatement for 300 times and “commit” them so that several redo log files have been generated: orasrv1> ls -ltr total 4128 -rw-r----- 1 oracle dba 1049600 Apr 26 09:13 pav1archS0000000144.arc -rw-r----- 1 oracle dba 1049600 Apr 26 10:47 pav1archS0000000145.arc -rw-r----- 1 oracle dba 1049600 Apr 26 10:47 pav1archS0000000146.arc -rw-r----- 1 oracle dba 1049600 Apr 26 10:48 pav1archS0000000147.arc 4. I shutdown the db, copy the db control file to my directory: /home/oracle/pav1ctl.ora 5. I replaced all db files with the saved backup files from Step 2. 6. I copied the latest control files to where it should be: cp /home/oracle/mycontrol.ora /ora02/oradata/PAV1/pav1ctl.ora cp /home/oracle/mycontrol.ora /ora03/oradata/PAV1/pav1ctl.ora 7. I used svrmgrl, connect internal and startup mount, I got SVRMGR> startup mount ORACLE instance started. Total System Global Area 5074288 bytes Fixed Size 60784 bytes Variable Size 4456448 bytes Database Buffers 409600 bytes Redo Buffers 147456 bytes Database mounted. So far so good. 8. I then issued RECOVER DATABASE and hit return and got: SVRMGR> RECOVER DATABASE ORA-00279: change 47446 generated at 04/26/99 09:22:20 needed for thread 1 ORA-00289: suggestion : /ora02/oradata/PAV1_logarchive/pav1archS0000000145.arc ORA-00280: change 47446 for thread 1 is in sequence #145 Specify log: {=suggested | filename | AUTO | CANCEL} Log applied. ORA-00279: change 47518 generated at 04/26/99 10:47:17 needed for thread 1 ORA-00289: suggestion : /ora02/oradata/PAV1_logarchive/pav1archS0000000146.arc ORA-00280: change 47518 for thread 1 is in sequence #146 ORA-00278: log file '/ora02/oradata/PAV1_logarchive/pav1archS0000000145.arc' noy Specify log: {=suggested | filename | AUTO | CANCEL} ORA-00283: recovery session canceled due to errors ORA-00314: log 1 of thread 1, expected sequence# 147 doesn't match 145 ORA-00312: online log 1 thread 1: '/ora03/oradata/PAV1/pav1log1.ora' ORA-00314: log 1 of thread 1, expected sequence# 147 doesn't match 145 ORA-00312: online log 1 thread 1: '/ora02/oradata/PAV1/pav1log1.ora' I also tried a couple of other ways such as RECOVER DATABASE UNTIL TIME '1999-04-26:10:45:00' ; And got the same error. So my question is: Why did I get this error? Did some of my step(s) are incorrect? I think I am not missing any archived redo log files. Redo log files seems to be opend OK. Looking at Oracle doc does not provide any clue to me. If you reply, please send a copy to zlmei@hotmail.com Thanks in advance. Guang -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own