Re: full database restore

From: Sean Fitzgerald <sfitzgerald_at_centurytel.net>
Date: 20 Sep 2001 11:29:01 -0700
Message-ID: <605a2fd5.0109201029.3d89b671_at_posting.google.com>

Pay no attention to the previous answer. It is not correct.

If you do a cold backup, the database is not running (you have done a shutdown). You backup up datafiles, control files and archive logs (not online redo logs).

If you lose the entire machine/disk subsystem and restore everything you backed up, you will be able to recover to the point of the last archive log that you have.

When you issue the recover command you tell oracle you are using a backup control file. Thus, you will be able to roll through all the archive logs you have from the point of the last backup. You will lose what was in the current online redo logs (not yet archived).

You will have to open the database with the resetlogs option. Received on Thu Sep 20 2001 - 20:29:01 CEST

This message: [ Message body ]
Next message: godmann: "Re: Installing Oracle 8i with Developer 6 or 6i on WIndows 2000 Profesional Edition"
Previous message: Craig S. Ledbetter: "Re: java stored procedure - how do I connect?"
Maybe in reply to: Stephen Hess: "full database restore"
Next in thread: godmann: "Re: Installing Oracle 8i with Developer 6 or 6i on WIndows 2000 Profesional Edition"
Reply: FaheemRao: "Re: full database restore"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message