I have cold backup files for an oracle database. Can someone tell me a step by step procedure on how to restore the database on my machine.I am using Oracle 11g
Restore Oracle database from cold backup files
backuporacle-11g
Related Question
- Oracle XE Backup Restore Problem
- How to restore operational Oracle 11g Database from full backup
- What is the most simple and easiest way to backup and restore on oracle 11g
- Oracle DB refresh on 11g using 10g Cold backup
- Oracle 11.2: Backup and recovery strategy based on full cold backup plus expdp
- Mongodb – How restore from .gz backup with new database name using mongorestore r3.2.9
- Oracle isn’t restoring correctly a backup
Best Answer
Cold backups, like hot backups can be taken in different ways. One is by using rman - recommended - the other is using OS tools like copy/dd. Next to that, storage based snapshots could be used. So in order to know how to restore, it is important to know how the backup has been made.
If the backup is properly made using RMAN, there is not much more to do than starting your instance, connect to the catalog, or find a snapshot controlfile that contains the backup administration, connect to the instance and issue a
restore database
command. If it is an OS tools backup, use the same tool[s] to copy the files to their original locations and start the database, once done.There are many potential pitfalls using cold OS tool backups. I have seen situations in which the admin told me ....
instead of looking further. He missed the point that the database was started during the cold backup. This is one of my reasons not to be a big fan of COLD backups. They make me shiver.
Be smart and carefully read Oracle® Database Backup and Recovery User's Guide 11g Release 2 (11.2) It is worth every minute you spend studying it. Oracle backup and recovery is not hard, there are just a lot of options.