Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: how to changes the sequence no for the redologs
we have an EBU/veritas netbackup script which takes
only 6 digits from the right for the redologs to be
backed up. As changing the backup class and testing
the scripts is more work i am looking for the ways to
accomplish this.
thank you all for your valuable input.
--sarath.
--- Michael P Sale <Michael.Sale_at_oracle.com> wrote:
> 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
>
-- 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).Received on Thu May 30 2002 - 00:43:21 CDT
![]() |
![]() |