RMAN> report schema;
oracle@venu2> cd /u02/app/oracle/venu
oracle@venu2 venu> ls
oracle@venu2 venu> rm -rf*
RMAN> validate database;
RMAN> shutdown abort
RMAN> exit
oracle@venu1> rman catalog rmanuser/rmanuser target sys/rac@to_hrms
RMAN> startup nomount
RMAN> restore controlfile;
RMAN> alter database mount;
RMAN> restore database;
RMAN> recover database;
RMAN> sql 'alter database open resetlogs';
RMAN> report schema;
RMAN> backup section size 2m tablespace USERS;
RMAN> list backup;
RMAN> list backup of datafile 4;
RMAN> list script names;
There are 2 types of scripts :
1.local scripts : Local script is only for specific database.
2.Global scripts : Global script is for all the datbases.
RMAN> create script venubkp
{ backup datafile 4; }
RMAN> list script names;
RMAN> create global script venubkp1
{ backup datafile 4; }
RMAN> list script names;
RMAN> print script venubkp;
RMAN> print script venubkp1;
RMAN> run { execute script venubkp; }
