Enable block change tracking

In this article we will enable block change tracking Now, what is block change tracking? Block change tracking is a mechanism of Oracle database to record changed blocks in a file. It helps us in taking incremental backups. While tracking incremental backups, instead of scanning all datafiles for changed blocks RMAN can simply read change […]

Read More

KEEP FOREVER Database Backup

We know that when we take backup using RMAN it has its configuration for Retention Policy. Every backup has its retention policy either in days or in a number of back-ups. And backups are stored in the Fast recovery area. Once a backup exceeds from its retention policy it becomes obsolete. But today we will […]

Read More

Backup Archive log files

We know that archive logs are very important files of a database when it comes to recovery. Let’s see how we can take backup of archive log files. Step 1: Connect to RMAN

Step 2: Take a backup using the following script

To know the difference between delete input and delete all input […]

Read More

Backup the Control File

We can set CONTROLFILE AUTOBACKUP on to make a backup of control file every time we take backup using RMAN. But today we will see how we can manually make a backup of controlfile. Step 1: Login to SQL prompt of database

Step 2: Take a backup using the backup controlfile command

Step […]

Read More

Configuring setting in RMAN

Recovery Manager [RMAN] is a very powerful tool when it comes to Backup, Restore or recovering your database. Today we will see Configuration of RMAN and how we can set them. Let’s start from scratch. 1: Connecting to RMAN To connect with rman we need to specify a target database name, username and password.

[…]

Read More

RMAN backup in Noarchive log mode

Today we will see how to take backup of Oracle Database when your database is in NOARCHIVELOG mode. Step 1: Check your database details

In the above output, we can see that the database is in NOARCHIVELOG mode and we have checked the db_recovery_file_dest_size parameter where we can see that it has enough space […]

Read More

Change Default Temporary Tablespace in Oracle

Being Oracle DBA we all are well known about the tablespace. Oracle RDBMS have multiple kinds of a tablespace with a different kind of purpose. We are going to have look on steps use for “Change Default Temporary Tablespace”. Check the current default temporary tablespace

Create another TEMP tablespace

Stop the database and remove tempfile […]

Read More

Incomplete Time Based Recovery in Oracle

Oracle provides different multiple options to have a “backup& recovery” as per the organization’s requirements. Incomplete recovery is one of the types of recovery. Let’s have look on the incomplete recovery. Check the archive log status

Create a test table with some records

Begin the backup mode

end the backup mode

create another […]

Read More

Hot Backup with RMAN in Oracle

We are going to have look on the backup of Oracle, Which is common in DBA’s life. HOT Backup is the most common way to have a backup. Let’s have look on the steps of Oracle’s HOT Backup. Check the archive status

Create a test table

Check the datafile name and begin the backup […]

Read More

Cold Backup and Recovery From Archivelog

Let’s have look on the steps used for Cold Backup and Recovery From Archivelog. Check the archive log status

Enable the archive logs

create a table for the testing purpose

Shutdown the database and make of necessary files

Start the database and insert some records

Shut down the database and […]

Read More