Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle backup/recovery
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
![]() |
![]() |