Re: lost redo logs, but have consitent offline backup

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,

Following is from the Oracle7 Server Administrator's Guide, chapter entitled "Backing Up a Database". Take note of #2. Online redo logs are necessary.

To Perform a Full Backup

1. Shut down the database with normal or immediate priority.

     To make a full backup, all database files must be closed by shutting down the database. Do not make a full backup

     when the instance is aborted or stopped because of a failure. Reopen the database and shut it down cleanly

     before making a full backup.

     2. Back up all files that constitute the database.

     Use operating system commands or a backup utility to make backups of all datafiles, online redo log files, and a

     single control file of the database. If you are multiplexing the online redo log, back up all members of each group,

     because it is not guaranteed that any one member of a group is complete. Also back up the parameter files

     associated with the database.

     Operating system backups can be performed:

     within Server Manager, using the HOST command

     outside Server Manager, with the operating system commands or a backup utility

     3. Restart the database.

     After you have finished backing up all datafiles, online redo log files, and a single control file of the database, you

     can restart the database.

--
Chuck Hamilton
chuckh_at_safeaccess.net

"Therefore the Lord Himself will give you a sign: Behold, a virgin will be with child, and bear a son, and she will call His name Immanuel." (Isa 7:14 NASB) Received on Fri Nov 13 1998 - 09:27:54 CST