Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g4U6U9q02478 for ; Thu, 30 May 2002 02:30:09 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id PAA53816; Wed, 29 May 2002 15:29:25 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b71/bab) via UUCP id 0046EF6B; Wed, 29 May 2002 15:13:31 -0800 Message-ID: Date: Wed, 29 May 2002 15:13:31 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Michael P Sale" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Michael P Sale" Subject: RE: how to changes the sequence no for the redologs Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Although I would NEVER try this on a production system without very good reason, you can fake an incomplete recovery by doing a recover until cancel and canceling on the first log. Then you can open resetlogs. Here is an example session from my 9.2 database (I've done the same thing many times in 7.3.x): WARNING DON'T DO THIS WITHOUT VERY GOOD REASON (Which I haven't seen yet) ---------------- SQL> startup mount; ORACLE instance started. Total System Global Area 135338868 bytes Fixed Size 453492 bytes Variable Size 109051904 bytes Database Buffers 25165824 bytes Redo Buffers 667648 bytes Database mounted. SQL> recover database until cancel using backup controlfile; ORA-00279: change 209286 generated at 05/29/2002 16:02:20 needed for thread 1 ORA-00289: suggestion : C:\ORACLE\ORA92\RDBMS\ARC00009.001 ORA-00280: change 209286 for thread 1 is in sequence #9 Specify log: {=suggested | filename | AUTO | CANCEL} cancel Media recovery cancelled. SQL> alter database open resetlogs; Database altered. SQL> ------------------ Regards, Michael Sale Author: Oracle9i for Windows(R) 2000 Tips & Techniques http://www.amazon.com/exec/obidos/ASIN/0072194626 -----Original Message----- Winnie_Liu@infonet.com Sent: Wednesday, May 29, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Why do you want to reset the log sequence? The resetlog options only works after an incomplete recovery. Winnie -- <\ /> ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~ (@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@ `~`~ / V \ Oracle Database Administrator `~`~ o--m-m--o Infonet Services Corporation `~`~ ##### mailto:winnie_liu@infonet.com `~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ sarath kumar hoo.com> cc: Sent by: Subject: how to changes the sequence no for the redologs root@fatcity.com 05/29/02 03:10 PM Please respond to ORACLE-L dear list, i have log sequence no like log%t_1_%s ie logTTM_1_001158967 logTTM_1_001158968 logTTM_1_001158969 logTTM_1_001158970 logTTM_1_001158971 logTTM_1_001158972. i can i reset the logs to logTTM_1_000000001 logTTM_1_000000002 and so on. i am on 7.3.4 when i give alter database open resetlogs it is not working. Sarath __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sarath kumar INET: sarath_kumar0@yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Winnie_Liu@infonet.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael P Sale INET: Michael.Sale@oracle.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).