In the following scenario, We are going to learn about those steps which use to recover duplicate a production database on a different server maintaining the same SID and directory structures with ‘duplicate‘ RMAN command I simply want to have a copy of my production database to a different server preserving the same database directory structures and […]
Articles Tagged: Restore
Recover contiguous corrupted data blocks
Being a DBA we all have good knowledge on feature of its database. As we know that Oracle has introduced a new feature in 11g which can be used to get assistance in case of loss or corruption of datafiles, redo log files or controlfiles. This tool is called data recovery advisor and is accessible from […]
Recover a never backed up tablespace after losing its datafile
In this post, we are going to learn steps which are use recover a never backed up tablespace after losing its datafile and even the current controlfile after the autobackup feature completes its job. This crash involves the lost of the “never backed up” tablespace and of the current controlfile. Let’s start with an example. Our […]
Restore from a loss of a subset of the current control files
Oracle database without control file is just like a human body without a backbone. Control file plays the role of the backbone of the database . Being an oracle dba we must know about controlfile . The control file is a file that the Oracle DBMS maintains to manage the state of the database, and it is […]
Restore a lost non-system datafile on a different location while the database is open
We are going to have a look on those steps which are required to restore a lost nonsystem datafile on a different location during the Oracle a database is in open stage. We are going to lose datafiles of a non-system critical tablespace and restore them, while the database is open, to a location other […]