Skip tablespaces while restore and recovery of database

NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
USERS
TEMP
EXAMPLE
DEV_IAS_ORASDPM
DEV_MDS
DEV_SOAINFRA
DEV_IAS_TEMP
DEV_ORABAM

NAME
------------------------------
DEV_PORTAL_LOG
DEV_PORTAL_DOC
DEV_PORTAL_IDX
DEV_IAS_PORTLET
DEV_PORTAL

16 rows selected.

Rman> connect target u/p@s

Rman>
set until time 

"to_date('2011-12-30:00:00:00', 'yyyy-mm-dd:hh24:mi:ss')"; 

Rman> restore database skip tablespace
'DEV_IAS_ORASDPM','DEV_SOAINFRA',

'DEV_IAS_TEMP','DEV_ORABAM','DEV_PORTAL_LOG',

'DEV_PORTAL_DOC','DEV_PORTAL_IDX',

'DEV_IAS_PORTLET','DEV_PORTAL';

Rman> recover database skip tablespce 'DEV_IAS_ORASDPM','DEV_SOAINFRA',

'DEV_IAS_TEMP','DEV_ORABAM','DEV_PORTAL_LOG',

'DEV_PORTAL_DOC','DEV_PORTAL_IDX','DEV_IAS_PORTLET','

DEV_PORTAL';

Sql>alter database open resetlogs;

Sql>select name, status from v$datafile;


First get metadata for schema and then take a expdp backup.

Scp ur backup to target db server.

Create a schema and then impdp.

Compile invalid objects if any.

RMAN Command cheat sheet

RMAN> list backupset;

RMAN> list backupset of database;

RMAN> list backupset of database completed before '22-NOV-00';

RMAN> list backupset of archivelog all;

RMAN> list backupset of tablespace users;

RMAN> list backupset of datafile 1;
RMAN> list backup summary;

RMAN> list backup;

RMAN> list backup of controlfile;

RMAN> list backup of tablespace SYSTEM;

RMAN> list backup by file;

RMAN> list backup of archivelog all ;
RMAN> list copy of database;

RMAN> list copy of database archivelog all;
RMAN> allocate channel for maintenance type disk;

RMAN> configure channel device type disk clear ;
RMAN> report need backup days=2 database;

RMAN> report need backup days=10 tablespace TEMP;

RMAN> report need backup days=4 
                           datafile 'D:\ORACLE\ORADATA\OR816\TEMP01.DBF';
RMAN> report schema;

RMAN> report obsolete;
RMAN> crosscheck backup;

RMAN> crosscheck backupset;

RMAN> crosscheck copy;

RMAN> crosscheck archivelog all;

RMAN> crosscheck controlfilecopy '/ora01/oracle/admin/BACKUP/demo/
                                  demo_controlfile_bak_03-15-11_19:59:11' ;
RMAN> delete noprompt expired backup ;

RMAN> delete noprompt obsolete;

RMAN> delete archivelog all;

RMAN> delete expired archivelog all;

RMAN> delete archivelog all completed before 'sysdate -1';

RMAN> delete noprompt archivelog until time 'sysdate - 1';

RMAN> delete archivelog all backed up 1 times to device type disk 
                                 completed before 'sysdate-1';