Recovery-(How to restore from a loss of all current control files to a non default location using a backup piece)

This post is about the steps which use restore from a loss of all current control files to a non-default location using a backup piece. First of all just create a location outside the flash recovery area where to save the backup piece containing the current control file: [oracle@localhost oracle]$ pwd /home/oracle/app/oracle/ [oracle@localhost oracle]$ mkdir controlfile_copy […]

Read More

Recovery-(How to perform a time-based incomplete recovery)

Every incomplete recovery is followed by a resetlogs command before opening the database: each time you use a resetlogs command, a new incarnation of the database is created. While performing incomplete recovery it should be known the target point at which the recovery process needs to terminate: there are several ways to establish and set […]

Read More

Recovery-(How to recover duplicate a production database on a different server mantaining the same SID and directory structures with ‘duplicate’ RMAN command)

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 […]

Read More

Recovery-(RMAN: how to duplicate a database on the same host)

This post explains the steps which are used for RMAN: how to duplicate a database on the same host.       We need to duplicate a database. There are many possibilities to complete this task and I choose to use RMAN and its commands: in particular, I decided (to be honest it was just a […]

Read More

Recovery – (How to recover corrupted data blocks using ‘recover datafile’ RMAN syntax on a system critical datafile)

As we know that SYSTEM – stores the data dictionary.  Being an Oracle DBA we all know the importance of SYSTEM tablespace.  In these below lines, we can have actual technical knowledge about system’s information. SYSTEM – a tablespace that is always used to store SYSTEM data that includes data about tables, indexes, sequences, and other objects – this metadata […]

Read More

Recovery – (How to recover a never backed up tablespace after losing its datafile and even the current controlfile after the autobackup feature completes its job)

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 […]

Read More

Recovery -(How to recover a never backed up tablespace after losing its datafile and even the current controlfile but before the autobackup feature completes its job)

  This post is about the steps which are used to recover a never backed up tablespace after losing its datafile and even the current controlfile but before the autobackup feature completes its job. The question is: what does it happen if you lose your new tablespace before your nightly backup script is successfully executed? Think […]

Read More