Recreate Database Using Only Datafile and Logfile

Let’s have look on the steps are used by Oracle DBA  for “Recreate Database Using Only Datafile and Logfile”. Backup of the control file in trace

create password file and service

set the environment and start the database in nomount

Create the controlfile

NOTE- If you want to set the new name […]

Read More

Recover From Redo Log File

This post explains about the steps are used by DBA for recovery From Redo Log File. Check the archive log status

List the tablespaces

Create new tablespace and create a table with some dummy data

Shutdown the database

Delete the datafile and try to start the database

Recreate the datafile and […]

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

Cold Backup with Rman in Oracle

Today we are going to have look on Cold Backup. Being DBA we are aware of the importance of Backup in Oracle. Different kind of backup has a different kind of uses. Let’s have look on Cold Backup. Steps for Cold Backup

Today’s thought… “The only way to get ahead is […]

Read More

RMAN Recovery From Missing All Control File

Today we are going to have look on the steps which are used by “DBA” for RMAN Recovery From Missing All Control File.

Delete control files and start the database

Today’s thought The foundation stones for a balanced success are honesty, character, integrity, faith, love, and loyalty. Zig Ziglar Thank […]

Read More

RMAN Backup With Archivelog

This post is  about how to take RMAN Backup With Archivelog

Note: This will backup all archivelog file and delete those from a target location. If we physically delete some archivelog file before backup then we have to execute the following command before backup-

Some other Options:

Today’s thought Positive thinking […]

Read More

Catalog Database in RMAN

Purpose of Catalog Database A base recovery catalog is a database schema that contains RMAN metadata for a set of target databases. A virtual private catalog is a set of synonyms and views that enable user access to a subset of a base recovery catalog. Catalog Database can be two types Base recovery catalog Virtual […]

Read More