RMAN
BackUp
$export ORACLE_SID = Test
$rman target /
Rman >backup database;
Rman >backup tablespace data,users;
Rman >backup datafile 10,12;
Rman>backup current control file;
Rman>backup archivelog all;
Rman>backup archivelog all delete input;
Rman>backup spfile;
Rman>backup archivelog until ‘sysdate – 1’ delete input;
Rman>backup archivelog skip inaccessible;
RECOVERY
\
Rman>sql ’alter database datafile 10 offline drop;
Rman>restore datafile 10 ;
Rman>recover datafile 10;
Rman>sql ‘ alter database datafile 10 online’;
/
\
Rman>run {
sql ’alter database datafile 10 offline drop;
restore datafile 10 ;
recover datafile 10;
sql ‘ alter database datafile 10 online’;
}
/
Recover tablespace
\
Rman >run {
Sql ‘alter tablespace data offline’;
Restore tablespace data;
Recover tablespace data;
Sql ‘alter tablespace data online’;
}
/
Read only Tablespace corrupted (recover)
\
Rman>run {
Sql ‘alter tablespace data offline’;
Restore tablespace data;
Sql ‘alter tablespace data online’;
}
/
System/Undo/ Tablespace corrupted (recover)
\
Startup mount
Rman> run {
Restore tablespace system;
Recover database;
Open database;
}
/
Database corrupted (recover)
\
Startup mount
Rman> run {
Restore database;
Recover database;
Open database;
}
/
Catalog Database
/
$ export ORACLE_SID = apps
sql>create tablespace rmanths datafile ‘/opt /oracle/rman 01.dbf’ size 100m;
sql>create user rman identified by rman default tablespace rmanths temporary tablespace temp;
sql> grant connect ,resource to rman;
sql>grant recovery_catalog_owner to rman;
$ export ORACLE_SID = test
$ rman target / catalog rman/rman@apps123
Rman>create catalog ;
Rman>register database;
Rman>backup database plus archivelog include current control file;
Rman>resync database; or rman>resync catalog;
Control file recovery
$ export ORACLE_SID = test
Rman>restore controlfile from ‘/opt/oracle/aXX ‘ ;
Rman>alter database mount ;
Rman>recover database ;
Rman>open database;
Control file recovery (Catalog database )
Startup no mount
$ export ORACLE_SID = test
$ rman target / catalog rman/rman@apps123
Rman> restore controlfile;
Rman> alter database mount;
Rman> recover database;
Rman> open database;
Incremental Backup
Rman> backup database; (level 0 backup)
Rman> backup incremental level 1 database;
Rman> backup incremental level 1 cumulative database;
RMAN Script
Rman> create script level1db
{
Backup incremental level 1 database;
Backup archivelog all delete input;
Backup current control file;
Backup spfile;
}
Rman> run { execute script level1db;}
Rman> print level1db;( display script content)
Rman> delete level1db;
SCN based (recover) database:
Rman > run {
Set until SCN ‘137’;
Retore database;
Recover database;
Open resetlogs database;
}
TIME based (recover) database:
Rman > run {
Set until TIME = ‘DD-MM-YY HH24:MI:SS’;
Retore database;
Recover database;
Open resetlogs database;
}
Log sequence based (recover) database:
Rman > run {
Set until log seq 1313 thread 1;
Retore database;
Recover database;
Open resetlogs database;
}
Restore in different location
Rman > run {
set until logseq 1313 thread 1;
set newname for datafile 1 to ‘ /U01/oracle/system01.dbf’;
set newname for datafile 2 to ‘ /U01/oracle/undo.dbf’;
set newname for datafile 3 to ‘ /U01/oracle/sysaux.dbf’;
set newname for datafile 4 to ‘ /U01/oracle/users.dbf’;
retore database;
switch datafile all;
recover database;
open resetlogs database;
}
Backup Options
Rman>backup database format ‘ /backup/rman_%d_%s_%p_%u’;
Maxset size:
Rman>backup database maxsetsize = 100m;
MAXpicesize
Rman>backup database maxpicesize = 100m;
Fileperset
Rman>backup database fileperset = 3;
Rate:
Rman>backup database rate 1m; ( 1mb data will be retrieved from 1 second)
Backup set identification:
Rman> backup database tag =’full_backup_412’;
Rman>restore database from tag ’full_backup_412’;
RMAN configuration:
Rman> Show all;
Rman> configuration retention policy to redundancy 3;
Rman> configuration retention policy to recovery window of 10 days;
Rman> report obsolete;(check whether retention (of 3 backup or 10 days backup ))
Rman> delete obsolete ;
Rman > report need backup;
Rman> configure default device type to disk;
Rman> configure default device type to ‘sbt’;
Rman> allocate channel for maintenance type disk (or) ‘sbt’;
Rman>configure channel device type disk format '/oracle/rman_bk/rmanbk_bk_%d_%u_%s_%p';
\
Rman>configure device type disk parallelism 5; (allocating channels)
Example:
Rman> run {
Allocate channel c1 type disk format ‘/opt/rman_%u;
Allocate channel c2 type disk format ‘/u2/rman_%u;
Allocate channel c3 type disk format ‘/u3/rman_%u;
Backup database;
Release channel c1;
Release channel c2;
Release channel c3;
}
/
Rman>configure controlfile autobackup on;
Rman>configure controlfile autobackup format for device type disk to ‘/backup/control_%f’;
Rman>configure device type disk backup type to backupset;
Rman>configure device type backup type to copy;(image copy backup)
Rman>configure device type backup type to compressed backupset;
Rman>comfigure backup optimization on; (only once take archive log)
Rman>configure for exclude tablespace users; (not take backup for users)
Rman> select * from v$ tablespace;
Output; name = users , Inc (include) = no
Rman> backup database noexclude;
Rman>configure for exclude tablespace users clear;
Rman>backup database skip offline skip read only;
Rman>backup archivelog all skip inaccessible;
Rman>validate backup database;(Wont take backup only verify it)
Rman>validate restore database;
Rman>list backup of database;
Rman>crosscheck backup;(check corrupted or proper)
Rman> crosscheck backup of database;
Rman>delete expired backup;
Block change tracking
Sql>alter database enable block change tracking using file ‘/opt/bcff.chg’;
Block recover
Rman>block recover datafile 10 block 121;
Rman>run{
Set maxcorrupt =3;
Backup database;
}
check only catalog users
\
Sql>conn rman/rman;
Sql>select * from rc_backup_datafile;
Sql>select * from rc_backup_redolog;
Sql>select * from rc_backup_spfile;
Sql>select * from rc_controlfile_copy;
Sql>select * from rc_backup_block_corruption;
Sql>select * from rc_resync;
Sql>select * from re_rman_configuration;
Sql> select * from rc_stored_script;
Sql>select * from rc_stored_script_line;
Provide the Oracle home details here (The oracle 10.2.0.1 home).
The installer will perform prerequisite checks on this screen. Make sure you see the message "The overall result of this check is passed" in the output.
Oracle configuration Manager allows you to associate your configuration with your metalink support account. You may skip this.
Installation Summary.
Installation progress.
Once progress shows 100%, you will be asked to perform some root specific actions.
Login as root 
Press exit and your ORACLE_HOME is patched with 10.2.0.4 patchset. All your db's working under this ORACLE_HOME will become unusable unless you upgrade your database to 10.2.04 as well.
