RE: how to changes the sequence no for the redologs

From: Michael P Sale <Michael.Sale_at_oracle.com>
Date: Wed, 29 May 2002 15:13:31 -0800
Message-ID: <F001.0046EF6B.20020529151331@fatcity.com>

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: {<RET>=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_at_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_at_infonet.com        `~`~
    ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~



 

                      sarath kumar

                      <sarath_kumar0_at_ya        To:       Multiple
recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>            
                      hoo.com>                 cc:

                      Sent by:                 Subject:  how to changes
the sequence no for the redologs                        
                      root_at_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_at_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_at_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_at_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_at_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_at_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_at_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).

Received on Wed May 29 2002 - 18:13:31 CDT