RMAN Command reference

Table Of Contents

Connect

# RMAN
RMAN> TARGET "sbu@prod  AS SYSBACKUP" AUXILIARY "sbu@dupdb AS SYSBACKUP";
RMAN> CONNECT TARGET "sbu@inst1 AS SYSBACKUP";
RMAN> CONNECT TARGET "sbu@prod AS SYSDBA";

# OS
rman target /
rman AUXILIARY SYS/PWD@AUX_STRING

RMAN TARGET "sbu@prod  AS SYSDBA" AUXILIARY "sbu@dupdb AS SYSDBA";

Allocate Channel

RMAN> ALLOCATE CHANNEL c1 DEVICE TYPE ‘SBT_TAPE’;

RMAN> ALLOCATE CHANNEL c1 DEVICE TYPE DISK
FORMAT ‘c:\\oraclebkp\\db_u%’;

RMAN> ALLOCATE CHANNEL t1 DEVICE TYPE DISK
CONNECT 'sys/pwd@bkp1’;

RMAN> ALLOCATE CHANNEL c1 DEVICE TYPE ‘SBT_TAPE’
PARMS 'ENV=(OB_MEDIA_FAMILY=wholedb_mf)';

RMAN> ALLOCATE CHANNEL t1 DEVICE TYPE SBT_TAPE
PARMS 'ENV=(OB_DEVICE_1=tape1, OB_DEVICE_2=tape3)';

RMAN> ALLOCATE CHANNEL t1 TYPE 'SBT_TAPE' PARMS='SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so.1';

RMAN> ALLOCATE CHANNEL t1 TYPE 'SBT_TAPE'
SEND "NB_ORA_CLIENT=CLIENT_MACHINE_NAME";

RMAN> ALLOCATE CHANNEL 'dev1' TYPE 'SBT_TAPE'
PARMS 'ENV=OB2BARTYPE=ORACLE8, OB2APPNAME=ORCL, OB2BARLIST=MACHINENAME_ORCL_ARCHLOGS)';

RMAN> ALLOCATE CHANNEL y1 TYPE DISK RATE 70M;

RMAN> ALLOCATE AUXILIARY CHANNEL ac1 TYPE DISK;

RMAN> ALLOCATE AUXILIARY CHANNEL ac2
DEVICE TYPE SBT;

***To simulate SBT_TAPE with Oracle internal API*
*The internal API accepts sbt calls just as any media library. The output is redirected to BACKUP_DIR.***

RMAN> ALLOCATE CHANNEL t1
DEVICE TYPE sbt PARMS='sbt_library=oracle.disksbt,
ENV=(backup_dir=/tmp)';

Allocate Channel For Maintenence

RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;

RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK FORMAT "/disk2/%U";

***See: formatSpec for RMAN substitution variables.***
RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK CONNECT '@test1';

RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt;

RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt PARMS 'SBT_LIBRARY=/usr/local/oracle/backup/lib/libobk.so, ENV=(OB_DEVICE_1=tape2)';

RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE 'SBT_TAPE' PARMS='SBT_LIBRARY=ORACLE.DISKSBT, ENV=(BACKUP_DIR=/TMP)';

Backup

RMAN> BACKUP DATABASE;

RMAN> BACKUP DATABASE TAG=’test backup’;

RMAN> BACKUP TAG 'Weekly_Full_DB_Backup' DATABASE MAXSETSIZE 10M;

RMAN> BACKUP MAXSETSIZE 500M DATABASE PLUS ARCHIVELOG;

RMAN> BACKUP DURATION 00:60 DATABASE;

RMAN> BACKUP DURATION 00:30 MINIMIZE TIME DATABASE;

RMAN> BACKUP DURATION 00:45 MINIMIZE LOAD DATABASE;

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

RMAN> BACKUP DATABASE KEEP FOREVER;

RMAN> BACKUP DATABASE KEEP UNTIL TIME=’SYSDATE+30’;

RMAN> BACKUP DATABASE UNTIL 'SYSDATE+365' NOLOGS;

RMAN> BACKUP DATABASE NOEXCLUDE;

RMAN> BACKUP DATABASE NOEXCLUDE KEEP FOREVER TAG=’abc’;

RMAN> BACKUP DATABASE SKIP READONLY;

RMAN> BACKUP DATABASE SKIP OFFLINE;

RMAN> BACKUP DATABASE SKIP INACCESSIBLE;

RMAN> BACKUP DATABASE SKIP READONLY SKIP OFFLINE SKIP INACCESSIBLE;

To back up a read-only database regardless of optimization

RMAN> BACKUP DATABASE FORCE;

RMAN> BACKUP DATABASE NOT BACKED UP;

RMAN> BACKUP DATABASE NOT BACKED UP SINCE TIME=’SYSDATE–3’;

RMAN> BACKUP NOT BACKED UP SINCE TIME 'SYSDATE-10'
MAXSETSIZE 500M DATABASE PLUS ARCHIVELOG;

RMAN> BACKUP DATABASE COPIES=2;

RMAN> BACKUP DATABASE FORMAT '/DISK1/BACKUPS/DB_%U.BCK' TAG quarterly KEEP UNTIL TIME 'SYSDATE+365' RESTORE POINT Q1FY12;

***See: formatSpec for RMAN substitution variables.***
RMAN> BACKUP DEVICE TYPE DISK DATABASE;

RMAN> BACKUP DEVICE TYPE SBT DATABASE PLUS ARCHIVELOG;

RMAN> BACKUP DEVICE TYPE SBT DATAFILECOPY FROM TAG 'Latest'
FORMAT 'DF%F_%D';

***See formatSpec for RMAN substitution variables.***
RMAN> BACKUP DEVICE TYPE SBT ARCHIVELOG LIKE '/disk%arc%'
DELETE ALL INPUT;

RMAN> BACKUP DEVICE TYPE SBT BACKUPSET COMPLETED BEFORE 'SYSDATE-14'
DELETE INPUT;

RMAN> BACKUP TABLESPACE TEST;

RMAN> BACKUP TABLESPACE SYSTEM, USERS, TOOLS;

RMAN> BACKUP TABLESPACE 4;

RMAN> BACKUP TABLESPACE USERS PLUS ARCHIVELOG;

RMAN> BACKUP TABLESPACE USERS INCLUDE CURRENT CONTROLFILE;

RMAN> BACKUP TABLESPACE USERS INCLUDE CURRENT CONTROLFILE
PLUS ARCHIVELOG;

RMAN> BACKUP TABLESPACE USERS SECTION SIZE 100M;

RMAN> BACKUP SECTION SIZE 250M TABLESPACE USERS;

RMAN> BACKUP DATAFILE 9;

RMAN> BACKUP DATAFILE ‘/U01/DATA/...’;

RMAN> BACKUP DATAFILE 1 PLUS ARCHIVELOG;

RMAN> BACKUP KEEP FOREVER FORMAT '?/DBS/%U_LONGTERM.CPY'
TAG 'Longterm_bck' DATAFILE 1 DATAFILE 2;

***See formatSpec for RMAN substitution variables.***
RMAN> BACKUP SECTION SIZE 500M DATAFILE 6;

RMAN> BACKUP ARCHIVELOG ALL;

RMAN> BACKUP ARCHIVELOG ALL DELETE INPUT;

RMAN> BACKUP ARCHIVELOG LIKE '/arch%' DELETE ALL INPUT;

RMAN> BACKUP ARCHIVELOG FROM TIME ‘SYSDATE–3’;

RMAN> BACKUP ARCHIVELOG FROM SEQUENCE 100;

RMAN> BACKUP ARCHIVELOG FROM SEQUENCE 999 DELETE INPUT;

RMAN> BACKUP ARCHIVELOG FROM SEQUENCE 123 DELETE ALL INPUT;

RMAN> BACKUP ARCHIVELOG FROM SEQUENCE 21531 UNTIL SEQUENCE 21590
FORMAT '/tmp/archive_backup.bkp';

RMAN> BACKUP ARCHIVELOG ALL FROM SEQUENCE 1200 DELETE ALL INPUT;

RMAN> BACKUP CHECK LOGICAL DATABASE;

RMAN> BACKUP ARCHIVELOG NOT BACKED UP 2 TIMES;

RMAN> BACKUP ARCHIVELOG COMPLETION TIME BETWEEN 'SYSDATE-28'
AND 'SYSDATE-7';

RMAN> BACKUP FORMAT='AL_%D/%T/%S/%P' ARCHIVELOG LIKE '%arc_dest%';

***See formatSpec for RMAN substitution variables.***
RMAN> BACKUP CURRENT CONTROLFILE TO '/backup/cntrlfile.copy';

RMAN> BACKUP AS COPY CURRENT CONTROLFILE FORMAT '/tmp/controlfile_copy.ctl';

RMAN> BACKUP CONTROLFILECOPY ‘/u10/backup/control.bkp’;

RMAN> BACKUP SPFILE;

RMAN> BACKUP DEVICE TYPE SBT SPFILE ARCHIVELOG ALL;

RMAN> BACKUP DEVICE TYPE SBT DATAFILECOPY ALL NODUPLICATES;

RMAN> BACKUP RECOVERY FILES;

RMAN> BACKUP PLUGGABLE DATABASE pdb1,pdb2;

***Backup - Validate Target***
RMAN> BACKUP VALIDATE CHECK LOGICAL DATABASE;

RMAN> BACKUP VALIDATE DATABASE;

RMAN> BACKUP VALIDATE DATABASE ARCHIVELOG ALL;

RMAN> BACKUP CHECK LOGICAL VALIDATE TABLESPACE DATA;

***For bigfile tablespace data files***
RMAN> BACKUP CHECK LOGICAL VALIDATE TABLESPACE DATA SECTION SIZE 64G;

Block Level Recover

RMAN> RECOVER CORRUPTION LIST;

RMAN> RECOVER DATAFILE 8 block 22;

RMAN> RECOVER DATAFILE 7 block 233,235 DATAFILE 4 block 101;

RMAN> RECOVER DATAFILE 2 block 12,13 DATAFILE 3 block 5,98,99
DATAFILE 4 block 19;

RMAN> RECOVER DATAFILE 3 block 2,4,5 TABLESPACE sales DBA 4194405,4194412 FROM DATAFILECOPY;

RMAN> RECOVER TABLESPACE DATA DBA 4194404,4194405 FROM TAG "weekly";

RMAN> RECOVER TABLESPACE DATA DBA 94404 RESTORE UNTIL TIME 'SYSDATE-2';

RMAN> RECOVER DATAFILE 40 block 1089408 NOFILEUPDATE SAVE all blocks;

Catalog

RMAN> CATALOG DATAFILECOPY '/disk2/backup/users01.bak';

RMAN> CATALOG DATAFILECOPY '/disk2/backup/users01.bak' LEVEL 0;

RMAN> CATALOG CONTROLFILECOPY '/disk3/backup/cf_copy.bkp';

RMAN> CATALOG ARCHIVELOG '<arch location>’;

RMAN> CATALOG BACKUPPIECE '/disk1/c-874220581-20131128-01’;

RMAN> CATALOG START WITH '/fs2/arch';

RMAN> CATALOG START WITH '/disk2/archlog' noprompt;

RMAN> CATALOG START WITH '+flash';

RMAN> CATALOG RECOVERY AREA;

Change

RMAN> CHANGE BACKUPSET 333 KEEP FOREVER;

RMAN> CHANGE BACKUPSET 431 KEEP FOREVER NOLOGS;

RMAN> CHANGE BACKUPSET 100 UNAVAILABLE;

RMAN> CHANGE BACKUPSET 123 NOKEEP;

RMAN> CHANGE BACKUPSET 121,122,127,203,300 UNCATALOG;

RMAN> CHANGE BACKUP OF DATABASE TAG=’abc’ UNAVAILABLE;

RMAN> CHANGE BACKUP OF DATABASE DEVICE TYPE DISK UNAVAILABLE;

RMAN> CHANGE COPY OF DATABASE CONTROLFILE NOKEEP;

RMAN> CHANGE BACKUP OF SPFILE COMPLETED BEFORE 'SYSDATE-3' UNAVAILABLE;

RMAN> CHANGE BACKUP TAG 'consistent_db_bkup' KEEP FOREVER;

RMAN> CHANGE BACKUP TAG 'consistent_db_bkup' DATABASE KEEP FOREVER;

RMAN> CHANGE BACKUP TAG 'consistent_db_bkup' KEEP FOREVER NOLOGS;

RMAN> CHANGE BACKUP TAG 'consistent_db_bkup' NOKEEP;

RMAN> CHANGE ARCHIVELOG ALL UNCATALOG;

RMAN> CHANGE CONTROLFILECOPY '/tmp/cf.cpy' UNCATALOG;

RMAN> CHANGE FAILURE 5 PRIORITY LOW;

RMAN> CHANGE BACKUP FOR DB_UNIQUE_NAME standby1 RESET DB_UNIQUE_NAME;

RMAN> CHANGE BACKUP
FOR DB_UNIQUE_NAME standby3
RESET DB_UNIQUE_NAME TO standby2;

RMAN> CHANGE DB_UNIQUE_NAME
FROM rdbms4
TO rdbms_dev;

Convert

RMAN> CONVERT DATABASE
ON DESTINATION PLATFORM
CONVERT SCRIPT
'/tmp/convertdb/convertscript.rman'
TRANSPORT SCRIPT '/tmp/convertdb/transportscript.sql'
NEW DATABASE 'prodwin'
FORMAT '/tmp/convertdb/%U';

RMAN> CONVERT DATABASE
ON DESTINATION PLATFORM
CONVERT SCRIPT '/tmp/convertdb/convertscript.rman'
TRANSPORT SCRIPT '/tmp/convertdb/transportscript.sql'
NEW DATABASE 'prodwin'
FORMAT '/tmp/convertdb/%U';

RMAN> CONVERT DATABASE
ON DESTINATION PLATFORM
CONVERT SCRIPT '/tmp/convert_newdb.rman'
TRANSPORT SCRIPT '/tmp/transport_newdb.sql'
NEW DATABASE 'prodaix'
DB_FILE_NAME_CONVERT '/u01/oradata/datafile','+DATA';

RMAN> CONVERT TABLESPACE tbs_2 FORMAT '/tmp/tbs_2_%U.df';

RMAN> CONVERT TABLESPACE finance, hr TO PLATFORM 'Solaris[tm] OE (32-bit)';

RMAN> CONVERT TABLESPACE finance, hr
TO PLATFORM 'Solaris[tm] OE (32-bit)' FORMAT '/tmp/transport_to_solaris/%U';

RMAN> CONVERT DATAFILE '/disk1/oracle/dbs/tbs_f1.df', '/disk1/oracle/dbs/ax1.f'
FORMAT '+DATAFILE';

RMAN> CONVERT DATAFILE '/u01/oradata/datafile/system.dbf'
FROM PLATFORM 'linux x86 64-bit'
FORMAT '+DATA/system.dbf';

RMAN> CONVERT DATAFILE
'/tmp/from_solaris/fin/fin01.dbf','/tmp/from_solaris/fin/fin02.dbf','/tmp/from_solaris/hr/hr01.dbf',
'/tmp/from_solaris/hr/hr02.dbf'
DB_FILE_NAME_CONVERT
'/tmp/from_solaris/fin','/disk2/orahome/dbs/fin',
'/tmp/from_solaris/hr','/disk2/orahome/dbs/hr'
FROM PLATFORM 'Solaris[tm] OE (64-bit)';

RMAN> CONVERT DATAFILE '/tmp/psmn.dbf'
TO PLATFORM='solaris operating system (x86-64)'
FROM PLATFORM='Solaris[tm] OE (64-bit)' FORMAT '/tmp/test/%n.dbf'
DB_FILE_NAME_CONVERT='/ui/prod/oracle/oradata/searchp/data /', '/tmp/test';

***See: formatSpec for RMAN substitution variables.***

Delete

RMAN> DELETE BACKUP OF ARCHIVELOG ALL;

RMAN> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-2';

RMAN> DELETE ARCHIVELOG ALL BACKED UP 2 TIMES TO DEVICE TYPE SBT;

RMAN> DELETE ARCHIVELOG ALL LIKE '%755153075%';

RMAN> DELETE ARCHIVELOG UNTIL SEQUENCE=79228;

RMAN> DELETE FORCE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1.5';

RMAN> DELETE FORCE ARCHIVELOG UNTIL SEQUENCE=16364;

RMAN> DELETE NOPROMPT ARCHIVELOG UNTIL SEQUENCE = 7300;

RMAN> DELETE EXPIRED ARCHIVELOG ALL;

RMAN> DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;

RMAN> DELETE BACKUPSET 101, 102, 103;

RMAN> DELETE NOPROMPT BACKUPSET TAG 'weekly_bkup';

RMAN> DELETE FORCE NOPROMPT BACKUPSET TAG 'weekly_bkup';

RMAN> DELETE DATAFILECOPY "+DG_DATA/DB/DATAFILE/SYSTEM.259.699468079";

RMAN> DELETE CONTROLFILECOPY '/TMP/CNTRLFILE.COPY';

RMAN> DELETE BACKUP DEVICE TYPE SBT;

RMAN> DELETE BACKUP DEVICE TYPE DISK;

RMAN> DELETE COPY;

RMAN> DELETE EXPIRED COPY;

RMAN> DELETE COPY TAG 'latest';

Connect

Allocate Channel

Allocate Channel For Maintenence

Backup

Block Level Recover

Catalog

Change

Convert

Delete

Duplicate