ORA-00031: session marked for kill

Let’s have look on the steps used to solve the error Error(ORA-00031: session marked for the kill) Let’s have look on the steps Phase – 1 Find out thread id that needed to be killed from OS level

If you know the user detail you can filter the query.

Output:

Phase-2  Kill […]

Read More

RMAN Parallel Backup

Let’s have look on the commands are used for “RMAN Parallel Backup”. Run the backup

Create more allocate channel

Set the parallelism parameter and run the backup again

Thought of the day.. “You will get all you want in life if you help enough other people get what they want.” — Zig […]

Read More

RMAN Script

Today we are going to have look on the most important topic “script”.  Being human being we are using the script from the long time ago. Before the start, our technical topic has some look use in normal life. Definition A script is any particular system of writing or the written means of human communication. Script originated as simply a […]

Read More

RMAN Image Copy And Compressed Backup

Let’s have look on the steps used for “RMAN Image Copy And Compressed Backup” Backing up Particular Datafile and System file:

Backup Database:

Compressed Backup:

Today’s thought.. “Be helpful. When you see a person without a smile, give them yours.” —  Zig Ziglar Thank you for giving your valuable time to read […]

Read More

Recover From Redo Log File (After Lost Data File))

Today we are going to have look on the steps which we are going to use in Oracle for ” Recover From Redo Log File (After Lost Data File)”. The loss is loss being DBA we well understand the cost of loss “CDR” Check archive list

check the tablespaces and datafile

Create new tablespace […]

Read More

RMAN Incremental Backup

We are aware RMAN plays an important role in backup strategies  Today we are going to have a look “RMAN Incremental Backup”. Let’s have look on the steps. Create table for testing purpose

Create a incremental backup with tag option

Create another table

Create a incremental backup for next run

Create another […]

Read More

RMAN Particular Datafile Backup

Let’s have look on the steps we use for “RMAN Particular Datafile Backup” Check the datafile

Create a dummy table and insert some records.

Backup datafile

Now insert some records

Now, shutdown the database and remove the datafile

Try to start the database

We need to recover the datafile […]

Read More

RMAN Recovery From Missing All Control File

Today we are going to have look on the steps are used for “RMAN Recovery From Missing All Control File”. Take a DBID

Check the RMAN configuration

Configure control file backup

BACKUP database

Check the controlfile location

Shutdown the database and remove the controlfile.

Try to start the database […]

Read More

RMAN Backup With Archivelog

RMAN plays an important role n Oracle RDBMS. Let’s have look on the steps are used by Oracle during the “RMAN Backup With Archivelog”

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

Read More

Recovery Scenario of Database

Here we will simulate recovery scenario of database.First we will create crash situation and then we will try to recover from that. Check backup is available for your database Now connect your pluggable database Create one tablespace in pluggable database . Create one user and grant quota on this tablespace to that user. Now lets […]

Read More