RMAN CLONING

1) connect catalog ,target and auxuliary database:

$ rman catalog ruser/ruser target sys/pwd@to_prod auxiliary sys/pwd1@to_auxi

2) rman>duplicate target database to clonedb

size of db,T/S,user,table

FULL DATABASE SIZE:
__________________

sys>select sum(bytes)/1024/1024 from dba_data_files group by tablespace_name;

TABLESPACE SIZE:
---------------------
sys>select tablespace-name,sum(bytes)/1024/1024 from dba_data_files group by tablespace_name;

USER SIZE:
------------
sys>select owner,sum(bytes)/1024/1024 from dba_segments group by owner;

TABLE SIZE:
--------------
sys>select owner,segment_name,sum(bytes)/1024/1024 from dba_segments where owner='U1' and segment_name='EMP';


NOTE:
sum(bytes)/1024 = size in KBs
sum(bytes)/1024/1024= size in MBs
sum(bytes)/1024/1024/1024=size in GBs

RMAN COMMANDS

RMAN> list backupset;

RMAN> list backupset of database;

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

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 'C:\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_15:28:14' ;

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';

BASIC UNIX commands

1)ls (list)

2) cd(change directory)

3)cat ,touch,vi (these cmds used for create file)

4)mkdir (make directory)

5)rmdir (remove empty directory)

6)chmod (change mode)

7)cp (copy)

8)rm (remove)

9)mv(move)

10)ps -x (process)

dba

database administartor