Re: lost redo logs, but have consitent offline backup

From: <rsvcool_at_yahoo.com>
Date: Wed, 09 Dec 1998 20:57:11 GMT
Message-ID: <74mo76$og4$1@nnrp1.dejanews.com>

Hi,

     I had the exact same problem with having to reset my redo logs. I tried to do exactly as you have suggested but I seem to have run into a new problem, following the CANCEL .. and then trying to do alter database resetlogs;

I get an error message that says

ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/usr09/oradata/mnet/system01.dbf' SVRMGR> alter database open resetlogs;  alter database open resetlogs
*
ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/usr09/oradata/mnet/system01.dbf'

Any ideas what may be wrong ..
I would appreciate any feedback.
RSV In article <3660595c.96200729_at_192.86.155.100>,   tkyte_at_us.oracle.com wrote:
> A copy of this was sent to chuckh_at_safeaccess.net (Chuck Hamilton)
> (if that email address didn't require changing)
> On Fri, 13 Nov 1998 15:23:16 GMT, you wrote:
>
> >On Thu, 12 Nov 1998 12:36:43 -0800, Jeremiah Wilton
> ><jeremiah_at_wolfenet.com> wrote:
> >
> >
> >>
> >>Actually, you are both wrong. There is no reason to back up the online
> >>redologs of a database that was backed up cold after a normal or immediate
> >>shutdown. All the user needs to do after restoring the datafiles,
> >>controlfile, and parameter files, is ALTER DATABASE OPEN RESETLOGS; and
> >>the redologs will reinitialize.
> >>
> >>Good luck,
> >
> >Try it. It doesn't work on a 7.3 database. RESETLOGS is only allowed
> >after incomplete recovery (i.e. point in time, or change# based
> >recovery). And to do incomplete recovery you need the logs... catch
> >22.
>
> Here is one way to do it in 7.3 without any logs (online or archived).... The
> docs suggest you backup online redo log files during a full colde backup
(makes
> it easier to recover when you need to -- and thats when you want things to be
> easy... You don't *need* them, but you do *want* them)
>
> My example is a 7.3 noarchive log mode database:
>
> REM -- first I got the names of all of my redo logfiles...
>
> SVRMGR> select * from v$logfile;
> GROUP# STATUS MEMBER
>
> ---------- -------
>

---

> 4 /user2/oracle73/dbs/oradata/oracle73/newredo1.log
>
> 5 /user2/oracle73/dbs/oradata/oracle73/newredo2.log
>
> 6 /user2/oracle73/dbs/oradata/oracle73/newredo3.log
>
> 3 rows selected.
>
> REM -- Then shutdown....
>
> SVRMGR> shutdown
> Database closed.
> Database dismounted.
> ORACLE instance shut down.
> SVRMGR> exit
> Server Manager complete.
>
> REM -- then I rm'ed all of my log, leaving the other datafiles on disk
> REM -- they represent my 'cold backup' that was restored...
>
> Fri Nov 13 10:36:10 EST 1998
> (oracle73_at_slackdog.us.oracle.com) /user2/oracle73/dbs/oradata/oracle73
> $ ls newredo?.log
> newredo1.log newredo2.log newredo3.log
>
> Fri Nov 13 10:36:10 EST 1998
> (oracle73_at_slackdog.us.oracle.com) /user2/oracle73/dbs/oradata/oracle73
> $ rm newredo?.log
>
> REM -- next, go into svrmgrl
> REM -- startup the database without opening
> REM -- mount the database, without opening
> REM -- perform a 'recover until cancel' command and CANCEL right away...
> REM -- no logs needed for that.
> REM -- open reset logs -- you are back in business
>
> Fri Nov 13 10:36:10 EST 1998
> (oracle73_at_slackdog.us.oracle.com) /user2/oracle73/dbs/oradata/oracle73
> $ svrmgrl
>
> Oracle Server Manager Release 2.3.4.0.0 - Production
>
> Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
>
> Oracle7 Server Release 7.3.4.0.1 - Production
> With the distributed, replication, parallel query and Spatial Data options
> PL/SQL Release 2.3.4.0.0 - Production
>
> SVRMGR> connect internal
> Connected to an idle instance.
>
> SVRMGR> startup nomount;
> ORACLE instance started.
> Total System Global Area 14724056 bytes
> Fixed Size 39816 bytes
> Variable Size 8122448 bytes
> Database Buffers 6553600 bytes
> Redo Buffers 8192 bytes
>
> SVRMGR> alter database mount;
> Statement processed.
>
> SVRMGR> recover database until cancel using backup controlfile;
> ORA-00279: Change 5331954859303 generated at 11/13/98 10:42:53 needed for
thread
> 1
> ORA-00289: Suggestion : /user2/oracle73/dbs/arch1_1.dbf
> ORA-00280: Change 5331954859303 for thread 1 is in sequence #1
> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
> cancel
> Media recovery cancelled.
>
> SVRMGR> alter database open resetlogs;
> Statement processed.
>
> SVRMGR> select * from dual;
> D
> -
> X
> 1 row selected.
> SVRMGR>
>
> Hope this helps...
>
> Thomas Kyte
> tkyte_at_us.oracle.com
> Oracle Government
> Herndon VA
>
> --
> http://govt.us.oracle.com/ -- downloadable utilities
>
> ----------------------------------------------------------------------------
> Opinions are mine and do not necessarily reflect those of Oracle Corporation
>
> Anti-Anti Spam Msg: if you want an answer emailed to you,
> you have to make it easy to get email to you. Any bounced
> email will be treated the same way i treat SPAM-- I delete it.
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 09 1998 - 14:57:11 CST