Re: Oracle backup/recovery

From: <bdbafh_at_gmail.com>
Date: 25 Feb 2005 11:01:36 -0800
Message-ID: <1109358095.983773.144570@l41g2000cwc.googlegroups.com>

it depends.
are you backing up the controlfile as part of your user-managed backup routine?
e.g. SQL> alter database backup controlfile to 'path' reuse;

yes, it is possible to restore a hot backup set, a backup controlfile, the archived redo logs, the pfile/spfile, password file and supporting directory structures, filesystem ownership/permissions and recover it/roll it forward, assuming that the proper oracle database server software binaries/patchsets are in place.

no cold backup is required.

you could practice this by 'cloning' the database via restoring a hot backup set, archived redo logs and creating a new controlfile for this new database. this subject is covered extensively elsewhere.

-bdbafh Received on Fri Feb 25 2005 - 13:01:36 CST