Oracle RMAN Tutorial Part 3 Recovery Operation

Block Media Recovery


check the corrupted block using following sql command.
SQL> select * from v$ database_block_corruption;

Oracle RMAN Tutorial Part 2 BACKUP OPERATION

Full database backup using RMAN


RMAN> backup as backupset database spfile;
RMAN> sql 'alter system archive log current';

Oracle RMAN Tutorial Part 1 Creating and configuring RMAN repository

Here are the basic description on RMAN configuration and setup. By reading this article you can configure a RMAN by yourself in a very practical manner. I have only concentrated on RMAN practical implementation perspective here.

Brief steps for Installing and Configuring RAC oracle database on ASM

software that is required
1. oracle database [11]
2. oracle clusterware

How to change the init parameter when oracle database is using SPFILE

first check db is running in SPFILE or PFILE using the following script.

SQL> SELECT  instance_name,