Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: lost redo logs, but have consitent offline backup
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
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
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. Received on Fri Nov 13 1998 - 10:13:29 CST