RMAN CHEAT SHEET

Start command the version required by the RMAN executable.

RMAN> UPGRADE CATALOG;
$ rman
$ rman NOCATALOG
$ rman TARGET SYS/pwd@target IMPORT CATALOG command
$ rman TARGET SYS/pwd@target NOCATALOG Import the metadata from one recovery catalog into another
$ rman CATALOG rman/pwd@catdb recovery catalog.
$ rman TARGET=SYS/pwd@target CATALOG=rman/pwd@cat RMAN> IMPORT CATALOG rcat@srcdb;
$ rman TARGET / CATALOG rman/rman@cat RMAN> IMPORT CATALOG rcat@srcdb DBID=<dbid>;
$ rman | tee rman.log RMAN> IMPORT CATALOG cat@srcdb DBID=<dbid1>, <dbid2>;
$ rman help=yes RMAN> IMPORT CATALOG cat@srcdb DB_NAME=<dbname>;
RMAN> IMPORT CATALOG cat@srcdb DB_NAME=<dbname1>,
<dbname2>;
CONNECT command RMAN> IMPORT CATALOG cat@srcdb DB_NAME=<dbname> NO
Establish a connection between RMAN and a target, auxiliary, or UNREGISTER;
recovery catalog database. RMAN> IMPORT CATALOG rman/oracle@catdb1 NO UNREGISTER;
RMAN> CONNECT TARGET;
RMAN> CONNECT TARGET /
RMAN> CONNECT TARGET sys@tgt;
RMAN> CONNECT TARGET sys/pwd@tgt; REGISTER command
RMAN> CONNECT CATALOG rman@catdb; Register the target database in the recovery catalog.
RMAN> CONNECT CATALOG rman/pwd@catdb; RMAN> REGISTER DATABASE;
RMAN> CONNECT AUXILIARY / RMAN> REGISTER CATALOG;
RMAN> CONNECT AUXILIARY rman@auxdb; RMAN> REGISTER CATALOG TABLESPACE <tbs-name>;
RMAN> CONNECT AUXILIARY rman/pwd@auxdb;

UNREGISTER command
CREATE CATALOG command Unregister a Oracle database from the recovery catalog.
Create Oracle schema for the recovery catalog. RMAN> UNREGISTER DATABASE;
RMAN> CREATE CATALOG; RMAN> UNREGISTER DATABASE NOPROMPT;
RMAN> CREATE CATALOG TABLESPACE rmants; RMAN> UNREGISTER DATABASE prod1;
RMAN> CREATE VIRTUAL CATALOG; RMAN> UNREGISTER DATABASE prod2 NOPROMPT;
RMAN> SQL "EXEC RMAN> UNREGISTER DB_UNIQUE_NAME prod2;
catown.DBMS_RCVCAT.CREATE_VIRTUAL_CATALOG"; RMAN> UNREGISTER DB_UNIQUE_NAME prod1 NOPROMPT;
RMAN> UNREGISTER DB_UNIQUE_NAME prod2 INCLUDING
BACKUPS;
RMAN> UNREGISTER DB_UNIQUE_NAME prod3 INCLUDING
BACKUPS NOPROMPT;
DROP CATALOG command
Remove Oracle schema from the recovery catalog.
RMAN> DROP CATALOG; GRANT command
Grant privileges to a recovery catalog user.
RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1;
RMAN> GRANT REGISTER DATABASE TO bckop2;
RMAN> GRANT RECOVERY_CATALOG_OWNER TO rmanop1,
RESYNC CATALOG command rmanop3;
Perform a full resynchronization, which creates a snapshot control
file and then copies any new or changed information from that
snapshot control file to the recovery catalog. REVOKE command
RMAN> RESYNC CATALOG; Revoke privileges from a recovery catalog user.
RMAN> RESYNC CATALOG FROM DB_UNIQUE_NAME prod_db; RMAN> REVOKE CATALOG FOR DATABASE prod1 FROM vpc1;
RMAN> RESYNC CATALOG FROM DB_UNIQUE_NAME ALL; RMAN> REVOKE REGISTER DATABASE FROM bckop2;
RMAN> REVOKE RECOVERY_CATALOG_OWNER FROM bckop;

RESET DATABASE command

UPGRADE CATALOG command RMAN> RESET DATABASE TO INCARNATION 3;
Upgrade the recovery catalog schema from an older version to
1 TECHGOEASY.COM
 RMAN CHEAT SHEET

RMAN> LIST DB_UNIQUE_NAME ALL;

STARTUP command RMAN> LIST DB_UNIQUE_NAME OF DATABASE;
Startup the target database. RMAN> LIST BACKUP;
RMAN> STARTUP; RMAN> LIST BACKUP SUMMARY;
RMAN> STARTUP PFILE=’/tmp/pfile/init<sid>.ora’ RMAN> LIST BACKUP BY FILE;
RMAN> STARTUP NOMOUNT; RMAN> LIST BACKUP OF DATABASE;
RMAN> STARTUP MOUNT; RMAN> LIST BACKUP OF DATABASE BY BACKUP;
RMAN> STARTUP FORCE; RMAN> LIST BACKUP OF TABLESPACE <tablespace_name>
RMAN> STARTUP FORCE DBA; SUMMARY;
RMAN> STARTUP FORCE DBA PFILE=’/tmp/pfile/init<sid>.ora’ RMAN> LIST BACKUP OF DATAFILE <file #>;
RMAN> STARTUP FORCE NOMOUNT; RMAN> LIST BACKUP OF DATAFILE <file #> SUMMARY;
RMAN> STARTUP FORCE MOUNT DBA RMAN> LIST BACKUP OF CONTROLFILE;
PFILE=’/tmp/pfile/init<sid>.ora’ RMAN> LIST BACKUP OF ARCHIVELOG FROM SEQUENCE <seq_no>;
RMAN> STARTUP AUXILIARY nomount; RMAN> LIST BACKUP OF ARCHIVELOG FROM TIME 'sysdate-1';
RMAN> LIST BACKUP OF ARCHIVELOG ALL COMPLETED BEFORE
'sysdate-2';
SHUTDOWN command RMAN> LIST BACKUP RECOVERABLE;
Shutdown the target database. RMAN> LIST EXPIRED BACKUP;
RMAN> LIST EXPIRED BACKUP OF ARCHIVELOG ALL SUMMARY;
RMAN> SHUTDOWN; RMAN> LIST COPY;
RMAN> SHUTDOWN NORMAL; RMAN> LIST COPY OF DATABASE ARCHIVELOG ALL;
RMAN> SHUTDOWN TRANSACTIONAL; RMAN> LIST COPY OF TABLESPACE <tablespace name>;
RMAN> SHUTDOWN IMMEDIATE; RMAN> LIST COPY OF DATAFILE <file #>;
RMAN> SHUTDOWN ABORT; RMAN> LIST COPY OF CONTROLFILE;
RMAN> LIST EXPIRED COPY;
RMAN> LIST BACKUPSET SUMMARY;
ALTER DATABASE command RMAN> LIST BACKUPSET 109;
Mount or open a database. RMAN> LIST BACKUPSET OF DATAFILE 1;
RMAN> ALTER DATABASE MOUNT; RMAN> LIST ARCHIVELOG;
RMAN> ALTER DATABASE OPEN; RMAN> LIST ARCHIVELOG ALL LIKE '%5515%';
RMAN> ALTER DATABASE OPEN RESETLOGS; RMAN> LIST CONTROLFILECOPY "/tmp/cntrlfile.copy";
RMAN> LIST SCRIPT NAMES;
RMAN> LIST ALL SCRIPT NAMES;
SHOW command RMAN> LIST GLOBAL SCRIPT NAMES;
Display the current CONFIGURE settings.
RMAN> LIST FAILURE;
RMAN> SHOW ALL; RMAN> LIST FAILURE 420 DETAIL;
RMAN> SHOW RETENTION POLICY; RMAN> LIST FAILURE ALL;
RMAN> SHOW RETENTION POLICY FOR DB_UNIQUE_NAME ALL; RMAN> LIST RESTORE POINT ALL;
RMAN> SHOW DEVICE TYPE;
RMAN> SHOW DEVICE TYPE FOR DB_UNIQUE_NAME
<db_unique_name>
RMAN> SHOW DEFAULT DEVICE TYPE; SQL command
RMAN> SHOW CHANNEL; Execute a SQL statement from within RMAN
RMAN> SHOW MAXSETSIZE;
RMAN> SHOW BACKUP OPTIMIZATION; RMAN> SQL 'ALTER TABLESPACE users ONLINE';
RMAN> SHOW SNAPSHOT CONTROLFILE NAME; RMAN> SQL 'ALTER DATABASE DATAFILE 64 OFFLINE';
RMAN> SHOW CONTROLFILE AUTOBACKUP; RMAN> SQL "ALTER SYSTEM ARCHIVE LOG CURRENT";
RMAN> SHOW COMPRESSION ALGORITHM; RMAN> SQL "ALTER SYSTEM SWITCH LOGFILE";
RMAN> SHOW ENCRYPTION ALGORITHM; RMAN> SQL "ALTER DATABASE BACKUP CONTROLFILE TO TRACE";
RMAN> SHOW ALL FOR DB_UNIQUE_NAME ALL;
RMAN> SHOW ALL FOR DB_UNIQUE_NAME 'STANDBY'; With 12c
RMAN> SQL 'ALTER TABLESPACE users ONLINE';
RMAN> SQL 'ALTER DATABASE DATAFILE 64 OFFLINE';
LIST command RMAN> ALTER SYSTEM ARCHIVE LOG CURRENT;
Produce a detailed listing of backup sets or copies. RMAN> ALTER SYSTEM SWITCH LOGFILE;
RMAN> LIST INCARNATION;
RMAN> LIST INCARNATION OF DATABASE;
RMAN> LIST INCARNATION OF DATABASE <DB_NAME>;

2 TECHGOEASY.COM
 RMAN CHEAT SHEET

CONFIGURE command RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK DEBUG 5;

RMAN> CONFIGURE BACKUP OPTIMIZATION ON;

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; RMAN> CONFIGURE BACKUP OPTIMIZATION OFF;
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF; RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR ‘/backup/snapcf_%d.f‘;
DEVICE TYPE DISK TO 'cf%F'; RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR ‘+FRA/snap/snapcf_%d.f‘;
DEVICE TYPE DISK TO '+BACKUP'; RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR ‘/ocfs/oradata/snapcf‘;
DEVICE TYPE DISK CLEAR; RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘/dev/sda‘;
RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3; RMAN> CONFIGURE MAXSETSIZE TO 100M;
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF RMAN> CONFIGURE MAXSETSIZE TO UNLIMITED;
7 DAYS; RMAN> CONFIGURE CHANNEL DEVICE TYPE sbt MAXPIECESIZE 1G;
RMAN> CONFIGURE RETENTION POLICY CLEAR; RMAN> CONFIGURE EXCLUDE FOR TABLESPACE example;
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE RMAN> CONFIGURE EXCLUDE CLEAR;
DISK TO 2; RMAN> CONFIGURE AUXNAME FOR DATAFILE 4 TO
'/oracle/auxfiles/aux_4.f';
RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE RMAN> CONFIGURE AUXNAME FOR DATAFILE 2 CLEAR;
DISK TO 2;
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY CLEAR; RMAN> CONFIGURE COMPRESSION ALGORITHM 'BZIP2';
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; RMAN> CONFIGURE COMPRESSION ALGORITHM 'ZLIB';
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO
STANDBY; With 11gR2
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO RMAN> CONFIGURE COMPRESSION ALGORITHM 'LOW';
ALL STANDBY; RMAN> CONFIGURE COMPRESSION ALGORITHM 'MEDIUM';
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON RMAN> CONFIGURE COMPRESSION ALGORITHM 'HIGH';
STANDBY; RMAN> CONFIGURE COMPRESSION ALGORITHM 'BASIC';
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON
ALL STANDBY; RMAN> CONFIGURE DB_UNIQUE_NAME 'standby' CONNECT
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP IDENTIFIER 'standby_cs';
2 TIMES TO sbt; RMAN> CONFIGURE DEFAULT DEVICE TYPE TO DISK FOR
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP DB_UNIQUE_NAME 'standby';
3 TIMES TO disk; RMAN> CONFIGURE DEFAULT DEVICE TYPE TO DISK FOR
DB_UNIQUE_NAME ALL;
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt_tape; RMAN> CONFIGURE DEFAULT DEVICE TYPE TO SBT FOR
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO DISK; DB_UNIQUE_NAME po;
RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 3;
RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 4;
RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE
TO BACKUPSET;
RMAN> CONFIGURE CHANNEL DEVICE TYPE sbt;
RMAN> CONFIGURE CHANNEL DEVICE TYPE sbt EXECUTE SCRIPT command
PARMS='ENV=mml_env_settings'; Run an RMAN stored script.
RMAN> CONFIGURE CHANNEL DEVICE TYPE sbt PARMS RMAN> RUN {EXECUTE SCRIPT backup_whole;}
'ENV=(NSR_SERVER=bksrv1)'; RMAN> RUN {EXECUTE SCRIPT backup_ts_any USING 'example';}
RMAN> CONFIGURE CHANNEL DEVICE TYPE sbt PARMS RMAN> RUN {EXECUTE SCRIPT backup_df USING 3 test_backup df3;}
'BLKSIZE=1048576'; RMAN> RUN {EXECUTE GLOBAL SCRIPT global_backup_db;}
RMAN> CONFIGURE CHANNEL DEVICE TYPE sbt FORMAT 'bkup_%U';
RMAN> CONFIGURE CHANNEL DEVICE TYPE sbt CLEAR;
RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE sbt CONNECT
'SYS/pwd@node2' PARMS 'ENV=(NSR_SERVER=bksrv2)'; DELETE SCRIPT command
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT Delete a stored script from the recovery catalog.
'/tmp/%U'; RMAN> DELETE SCRIPT backup_db;
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT RMAN> DELETE GLOBAL SCRIPT global_backup_db;
'C:\backup\df%t_s%s_s%p';
RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT
'/backup/db_%s%d_%p';
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT CLEAR;

3 TECHGOEASY.COM
 RMAN CHEAT SHEET

SET command RMAN> BACKUP DATABASE SKIP INACCESSIBLE;

Set the value of various attributes that affect RMAN behavior for the RMAN> BACKUP DATABASE SKIP READONLY SKIP OFFLINE SKIP
duration of a RUN block or a session. INACCESSIBLE;
RMAN> BACKUP DATABASE FORCE; -- backup read only database
RMAN> SET ECHO ON; also
RMAN> SET ECHO OFF; RMAN> BACKUP DATABASE NOT BACKED UP;
RMAN> SET DATABASE <DB_NAME>; RMAN> BACKUP DATABASE NOT BACKED UP SINCE TIME=’SYSDATE–
RMAN> SET DBID=<DB_ID>; 3’;
RMAN> SET DBID <DB_ID>; RMAN> BACKUP NOT BACKED UP SINCE TIME 'SYSDATE-10'
RMAN> SET COMMAND ID TO 'rman'; MAXSETSIZE 500M DATABASE PLUS ARCHIVELOG;
RMAN> SET MAXCORRUPT FOR DATABASE TO 2;
RMAN> SET MAXCORRUPT FOR DATAFILE 15 TO 200; RMAN> BACKUP DATABASE COPIES=2;
RMAN> SET BACKUP COPIES = 2; RMAN> BACKUP DATABASE FORMAT '/disk1/backups/db_%U.bck'
TAG quarterly KEEP UNTIL TIME 'SYSDATE+365' RESTORE POINT
RMAN> SET NEWNAME FOR DATABASE TO '/oradata1/%b'; Q1FY12;
RMAN> SET NEWNAME FOR TABLESPACE users TO '/oradata2/%U'; RMAN> BACKUP DEVICE TYPE DISK DATABASE;
RMAN> SET NEWNAME FOR DATAFILE 1 to ‘/oradata/system01.dbf’; RMAN> BACKUP DEVICE TYPE sbt DATABASE PLUS ARCHIVELOG;
RMAN> SET NEWNAME FOR DATAFILE '/disk7/tbs11.f' TO RMAN> BACKUP DEVICE TYPE sbt DATAFILECOPY FROM TAG 'latest'
'/disk9/tbs11.f'; FORMAT 'df%f_%d';
RMAN> SET NEWNAME FOR TEMPFILE 1 TO '/newdisk/dbs/temp1.f'; RMAN> BACKUP DEVICE TYPE sbt ARCHIVELOG LIKE '/disk%arc%'
DELETE ALL INPUT;
RMAN> SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE RMAN> BACKUP DEVICE TYPE sbt BACKUPSET COMPLETED BEFORE
sbt TO 'cf_%F'; 'SYSDATE-14'DELETE INPUT;
RMAN> SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE RMAN> BACKUP CHECK LOGICAL DATABASE;
DISK TO 'cf_%F.bak'; RMAN> BACKUP VALIDATE CHECK LOGICAL DATABASE;
RMAN> SET UNTIL TIME ’04-23-2010:23:50:04’; RMAN> BACKUP VALIDATE DATABASE;
RMAN> SET ARCHIVELOG DESTINATION TO '/oracle/temp_restore'; RMAN> BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
RMAN> SET COMPRESSION ALGORITHM 'LOW';
RMAN> SET COMPRESSION ALGORITHM 'LOW' OPTIMIZE FOR LOAD RMAN> BACKUP TABLESPACE test;
FALSE; RMAN> BACKUP TABLESPACE system, users, tools;
RMAN> SET COMPRESSION ALGORITHM 'MEDIUM'; RMAN> BACKUP TABLESPACE 4;
RMAN> SET COMPRESSION ALGORITHM 'HIGH'; 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;
BACKUP command RMAN> BACKUP SECTION SIZE 250M TABLESPACE USERS;
Backs up Oracle database files, copies of database files, archived
logs, or backup sets. RMAN> BACKUP DATAFILE 9;
RMAN> BACKUP DATAFILE ‘/u01/data/...’;
RMAN> BACKUP DATABASE; RMAN> BACKUP DATAFILE 1 PLUS ARCHIVELOG;
RMAN> BACKUP DATABASE TAG=’test backup’; RMAN> BACKUP KEEP FOREVER FORMAT '?/dbs/%U_longterm.cpy'
RMAN> BACKUP DATABASE COMMENT=’full backup’; TAG longterm_bck DATAFILE 1 DATAFILE 2;
RMAN> BACKUP TAG 'weekly_full_db_bkup' DATABASE MAXSETSIZE RMAN> BACKUP SECTION SIZE 500M DATAFILE 6;
10M;
RMAN> BACKUP MAXSETSIZE 500M DATABASE PLUS ARCHIVELOG; RMAN> BACKUP ARCHIVELOG ALL;
RMAN> BACKUP DURATION 00:60 DATABASE; RMAN> BACKUP ARCHIVELOG ALL DELETE INPUT;
RMAN> BACKUP DURATION 00:30 MINIMIZE TIME DATABASE; RMAN> BACKUP ARCHIVELOG LIKE '/arch%' DELETE ALL INPUT;
RMAN> BACKUP DURATION 00:45 MINIMIZE LOAD DATABASE; RMAN> BACKUP ARCHIVELOG FROM TIME ‘SYSDATE–3’;
RMAN> BACKUP ARCHIVELOG FROM SEQUENCE 100;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG; RMAN> BACKUP ARCHIVELOG FROM SEQUENCE 999 DELETE INPUT;
RMAN> BACKUP DATABASE KEEP FOREVER; RMAN> BACKUP ARCHIVELOG FROM SEQUENCE 123 DELETE ALL
RMAN> BACKUP DATABASE KEEP UNTIL TIME=’SYSDATE+30’; INPUT;
RMAN> BACKUP DATABASE UNTIL 'SYSDATE+365' NOLOGS; RMAN> BACKUP ARCHIVELOG FROM SEQUENCE 21531 UNTIL
RMAN> BACKUP DATABASE NOEXCLUDE; SEQUENCE 21590 FORMAT '/tmp/archive_backup.bkp';
RMAN> BACKUP DATABASE NOEXCLUDE KEEP FOREVER TAG=’abc’; RMAN> BACKUP ARCHIVELOG ALL FROM SEQUENCE 1200 DELETE
RMAN> BACKUP DATABASE SKIP READONLY; ALL INPUT;
RMAN> BACKUP DATABASE SKIP OFFLINE;

4 TECHGOEASY.COM
 RMAN CHEAT SHEET

RMAN> BACKUP ARCHIVELOG NOT BACKED UP 2 TIMES; RMAN> BACKUP AS COPY REUSE TARGETFILE
RMAN> BACKUP ARCHIVELOG COMPLETION TIME BETWEEN '/u01/oracle/11.2.0.2/dbs/orapwcrd' AUXILIARY FORMAT
'SYSDATE-28' AND 'SYSDATE-7'; '/u01/oracle/11.2.0.2/dbs/orapwcrd';
RMAN> BACKUP FORMAT='AL_%d/%t/%s/%p' ARCHIVELOG LIKE RMAN> BACKUP AS COPY CURRENT CONTROLFILE FOR STANDBY
'%arc_dest%'; AUXILIARY format '+DATA/crd/data1/control01.ctl';

RMAN> BACKUP CURRENT CONTROLFILE TO '/backup/cntrlfile.copy'; Incremental backups

RMAN> BACKUP CONTROLFILE COPY ‘/u10/backup/control.bkp’; RMAN> BACKUP INCREMENTAL LEVEL=0 DATABASE;
RMAN> BACKUP SPFILE; RMAN> BACKUP INCREMENTAL LEVEL=1 DATABASE;
RMAN> BACKUP DEVICE TYPE sbt SPFILE ARCHIVELOG ALL; RMAN> BACKUP INCREMENTAL LEVEL=0 DATABASE PLUS
RMAN> BACKUP DEVICE TYPE sbt DATAFILECOPY ALL ARCHIVELOG;
NODUPLICATES; RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE SKIP
INACCESSIBLE DATABASE;
RMAN> BACKUP RECOVERY FILES; RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY
WITH TAG 'incr' DATABASE;
With 12c RMAN> BACKUP DEVICE TYPE DISK INCREMENTAL LEVEL 1 FOR
RMAN>BACKUP PLUGGABLE DATABASE PDB1, PDB2; RECOVER OF COPY WITH TAG 'oltp' DATABASE;
RMAN> BACKUP DEVICE TYPE DISK INCREMENTAL FROM SCN
351986 DATABASE FORMAT '/tmp/incr_standby_%U';
BACKUP set RMAN> BACKUP INCREMENTAL FROM SCN 629184 DATAFILE 5
RMAN> BACKUP BACKUPSET ALL; FORMAT '/tmp/ForStandby_%U' TAG 'FORSTANDBY';
RMAN> BACKUP BACKUPSET ALL FORMAT =
‘/u01/.../backup_%u.bak’; RMAN> BACKUP INCREMENTAL LEVEL = --- tablespace/datafile
RMAN> BACKUP BACKUPSET COMPLETED BEFORE ‘SYSDATE-3’
DELETE INPUT;
RMAN> BACKUP DEVICE TYPE sbt BACKUPSET COMPLETED BEFORE RMAN> BACKUP BLOCKS ALL CHECK LOGICAL VALIDATE DATAFILE
'SYSDATE-14' DELETE INPUT; 1398;
RMAN> BACKUP COPIES 2 DEVICE TYPE sbt BACKUPSET ALL;
RMAN> BACKUP AS COMPRESSED BACKUPSET;
RMAN> BACKUP AS COMPRESSED BACKUPSET DEVICE TYPE DISK
COPIES 2 DATABASE FORMAT '/disk1/db_%U', '/disk2/db_%U';
RMAN> BACKUP AS COMPRESSED BACKUPSET INCREMENTAL FROM REPORT command
SCN 4111140000000 DATABASE TAG 'RMAN_RECOVERY'; Report backup status: database, files, and backups. Perform detailed
RMAN> BACKUP AS BACKUPSET DATAFILE analyses of the content of the recovery catalog.
'$ORACLE_HOME/oradata/users01.dbf','$ORACLE_HOME/oradata/t
ools01.dbf'; RMAN> REPORT OBSOLETE;
RMAN> BACKUP AS BACKUPSET DATAFILECOPY ALL; RMAN> REPORT NEED BACKUP;
RMAN> BACKUP AS BACKUPSET DATAFILECOPY ALL NODUPLICATES; RMAN> REPORT NEED BACKUP DAYS=5;
RMAN> REPORT NEED BACKUP REDUNDANCY=3;
IMAGE copy RMAN> REPORT NEED BACKUP RECOVERY WINDOW OF 7 DAYS;
RMAN> BACKUP AS COPY DATABASE; RMAN> REPORT NEED BACKUP DATABASE;
RMAN> BACKUP AS COPY COPY OF DATABASE FROM TAG 'test' RMAN> REPORT NEED BACKUP INCREMENTAL 1;
CHECK LOGICAL TAG 'duptest'; RMAN> REPORT UNRECOVERABLE;
RMAN> BACKUP AS COPY TABLESPACE 8; RMAN> REPORT SCHEMA;
RMAN> BACKUP AS COPY TABLESPACE test; RMAN> REPORT SCHEMA AT TIME 'sysdate-20/1440';
RMAN> BACKUP AS COPY TABLESPACE system, tools, users, undotbs;
RMAN> BACKUP AS COPY DATAFILE 1;
RMAN> BACKUP AS COPY DATAFILE 2 FORMAT '/disk2/df2.cpy' TAG
my_tag;
RMAN> BACKUP AS COPY CURRENT CONTROLFILE; CHANGE command
RMAN> BACKUP AS COPY CURRENT CONTROLFILE FORMAT ‘/....’; Update the status of a backup in the RMAN repository. Mark a
RMAN> BACKUP AS COPY ARCHIVELOG ALL; backup piece, image copy, or archived redo log as having the status
RMAN> BACKUP AS COPY KEEP FOREVER NOLOGS CURRENT UNAVAILABLE or AVAILABLE; remove the repository record for a
CONTROLFILE FORMAT '?/oradata/cf_longterm.cpy', DATAFILE 1 backup or copy; override the retention policy for a backup or copy;
FORMAT '?/oradata/df1_longterm.cpy', DATAFILE 2 FORMAT update the recovery catalog with the DB_UNIQUE_NAME for the
'?/oradata/df2_longterm.cpy'; target database.
RMAN> BACKUP AS COPY DATAFILECOPY 'bar' FORMAT 'foobar';
RMAN> BACKUP AS COPY DATAFILECOPY '/disk2/df2.cpy' FORMAT RMAN> CHANGE BACKUPSET 666 KEEP FOREVER;
'/disk1/df2.cpy'; RMAN> CHANGE BACKUPSET 431 KEEP FOREVER NOLOGS;

5 TECHGOEASY.COM
 RMAN CHEAT SHEET

RMAN> CHANGE BACKUPSET 100 UNAVAILABLE; RMAN> CROSSCHECK COPY OF DATABASE;

RMAN> CHANGE BACKUPSET 123 NOKEEP; RMAN> CROSSCHECK DATAFILECOPY 113, 114, 115;
RMAN> CHANGE BACKUPSET 121,122,127,203,300 UNCATALOG; RMAN> CROSSCHECK CONTROLFILECOPY '/tmp/control01.ctl';
RMAN> CHANGE BACKUP OF DATABASE TAG=’abc’ UNAVAILABLE; RMAN> CROSSCHECK ARCHIVELOG ALL;
RMAN> CHANGE BACKUP OF DATABASE DEVICE TYPE DISK RMAN> CROSSCHECK BACKUPSET;
UNAVAILABLE; RMAN> CROSSCHECK BACKUPSET 1338, 1339, 1340;
RMAN> CHANGE COPY OF DATABASE CONTROLFILE NOKEEP; RMAN> CROSSCHECK BACKUPPIECE TAG = 'nightly_backup';
RMAN> CHANGE BACKUP OF SPFILE COMPLETED BEFORE 'SYSDATE- RMAN> CROSSCHECK PROXY 789;
3' UNAVAILABLE;
RMAN> CHANGE BACKUP TAG 'consistent_db_bkup' KEEP FOREVER;
RMAN> CHANGE BACKUP TAG 'consistent_db_bkup' DATABASE
KEEP FOREVER; RESTORE command
RMAN> CHANGE BACKUP TAG 'consistent_db_bkup' KEEP FOREVER Restore files from backup sets or from disk copies to the default or a
NOLOGS; new location.
RMAN> CHANGE BACKUP TAG 'consistent_db_bkup' NOKEEP;
RMAN> RESTORE DATABASE;
RMAN> CHANGE ARCHIVELOG ALL UNCATALOG; RMAN> RESTORE DATABASE VALIDATE;
RMAN> CHANGE CONTROLFILECOPY '/tmp/cf.cpy' UNCATALOG; RMAN> RESTORE DATABASE PREVIEW;
RMAN> CHANGE FAILURE 5 PRIORITY LOW; RMAN> RESTORE DATABASE PREVIEW SUMMARY;
RMAN> CHANGE BACKUP FOR DB_UNIQUE_NAME standby1 RESET RMAN> RESTORE DATABASE SKIP TABLESPACE temp, history;
DB_UNIQUE_NAME; RMAN> RESTORE DATABASE UNTIL SCN 154876;
RMAN> CHANGE BACKUP FOR DB_UNIQUE_NAME standby3 RESET
DB_UNIQUE_NAME TO standby2; RMAN> RESTORE TABLESPACE users;
RMAN> CHANGE DB_UNIQUE_NAME FROM rdbms4 TO rdbms_dev; RMAN> RESTORE TABLESPACE dwh1, dwh2;
RMAN> RESTORE TABLESPACE tbs1 PREVIEW;
RMAN> RESTORE TABLESPACE users VALIDATE;

RMAN> RESTORE DATAFILE 45;

CROSSCHECK command RMAN> RESTORE DATAFILE 23 PREVIEW;
Check whether files managed by RMAN, such as archived logs, RMAN> RESTORE DATAFILE 12 VALIDATE;
datafile copies, and backup pieces, still exist on disk or tape.
RMAN> RESTORE CONTROLFILE;
RMAN> CROSSCHECK BACKUP; RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP;
RMAN> CROSSCHECK BACKUP TAG=’full db’; RMAN> RESTORE CONTROLFILE FROM TAG 'monday_cf_backup';
RMAN> CROSSCHECK BACKUP COMPLETED BETWEEN ‘SYSDATE-7’ RMAN> RESTORE CONTROLFILE FROM '/u01/control01.ctl';
AND ‘SYSDATE–1’; RMAN> RESTORE CONTROLFILE VALIDATE;
RMAN> CROSSCHECK BACKUP COMPLETED BETWEEN '01-JAN-10' RMAN> RESTORE CONTROLFILE TO '/tmp/autobkp.dbf' FROM
AND '14-FEB-10'; AUTOBACKUP MAXSEQ 20 MAXDAYS 150;
RMAN> CROSSCHECK BACKUP DEVICE TYPE sbt COMPLETED
BETWEEN '01-AUG-09' AND '31-DEC-09'; RMAN> RESTORE SPFILE;
RMAN> CROSSCHECK BACKUP DEVICE TYPE DISK COMPLETED RMAN> RESTORE SPFILE FROM AUTOBACKUP;
BETWEEN '01-JAN-10' AND '23-MAR-10'; RMAN> RESTORE ARCHIVELOG ALL VALIDATE;
RMAN> RESTORE ARCHIVELOG ALL PREVIEW;
RMAN> CROSSCHECK BACKUP OF DATABASE; RMAN> RESTORE ARCHIVELOG ALL PREVIEW RECALL;
RMAN> CROSSCHECK BACKUP OF TABLESPACE warehouse; RMAN> RESTORE ARCHIVELOG ALL DEVICE TYPE sbt PREVIEW;
RMAN> CROSSCHECK BACKUP OF TABLESPACE userd COMPLETED RMAN> RESTORE ARCHIVELOG LOW LOGSEQ 78311 HIGH LOGSEQ
BEFORE 'SYSDATE-14'; 78340 THREAD 1 ALL;
RMAN> CROSSCHECK BACKUP OF TABLESPACES gld, invd; RMAN> RESTORE ARCHIVELOG FROM LOGSEQ=<seq_no> UNTIL
RMAN> CROSSCHECK BACKUP OF DATAFILE 9; LOGSEQ=<seq_no>;
RMAN> CROSSCHECK BACKUP OF DATAFILE 4 COMPLETED AFTER RMAN> RESTORE STANDBY CONTROLFILE FROM TAG 'forstandby';
'SYSDATE-14'; RMAN> RESTORE CLONE CONTROLFILE TO
RMAN> CROSSCHECK BACKUP OF DATAFILE '+DATA/pcrd/data2/control02.ctl' FROM
"?/oradata/dwh/system01.dbf" COMPLETED AFTER 'SYSDATE-14'; '+DATA/pcrd/data1/control01.ctl';
RMAN> CROSSCHECK BACKUP OF CONTROLFILE;
RMAN> CROSSCHECK BACKUP OF SPFILE; Restore the control file, (to all locations specified in the parameter
RMAN> CROSSCHECK BACKUP OF ARCHIVELOG ALL; file) then restore the database, using that control file:
RMAN> CROSSCHECK BACKUP OF ARCHIVELOG ALL SPFILE; STARTUP NOMOUNT;
RUN
RMAN> CROSSCHECK COPY; {

6 TECHGOEASY.COM
 RMAN CHEAT SHEET

ALLOCATE CHANNEL c1 DEVICE TYPE sbt; Delete backups and copies, remove references to them from the
RESTORE CONTROLFILE; recovery catalog, and update their control file records to status
ALTER DATABASE MOUNT; DELETED.
RESTORE DATABASE;
}
With 12c RMAN> DELETE OBSOLETE;
RMAN> DELETE NOPROMPT OBSOLETE;
RMAN>RESTORE PLUGGABLE DATABASE PDB1, PDB2; RMAN> DELETE NOPROMPT OBSOLETE RECOVERY WINDOW OF 7
DAYS;
RMAN> DELETE EXPIRED BACKUP;
RMAN> DELETE EXPIRED BACKUP DEVICE TYPE sbt;
RECOVER command RMAN> DELETE BACKUP OF DATABASE LIKE '/tmp%';
Perform media recovery from RMAN backups and copies. Apply redo RMAN> DELETE NOPROMPT EXPIRED BACKUP OF TABLESPACE users
log files and incremental backups to datafiles or data blocks restored COMPLETED BEFORE 'SYSDATE-14';
from backup or datafile copies, to update them to a specified time. RMAN> DELETE BACKUP OF SPFILE TABLESPACE users DEVICE TYPE
SBT;
RMAN> RECOVER DATABASE;
RMAN> RECOVER DATABASE NOREDO; RMAN> DELETE ARCHIVELOG ALL;
RMAN> RECOVER DATABASE SKIP TABLESPACE temp; RMAN> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'sysdate-2';
RMAN> RECOVER DATABASE SKIP FOREVER TABLESPACE exam; RMAN> DELETE ARCHIVELOG ALL BACKED UP 2 TIMES TO DEVICE
RMAN> RECOVER DATABASE UNTIL SCN 154876; TYPE SBT;
RMAN> DELETE ARCHIVELOG ALL LIKE '%755153075%';
RMAN> RECOVER TABLESPACE users; RMAN> DELETE ARCHIVELOG UNTIL SEQUENCE=79228;
RMAN> RECOVER TABLESPACE dwh DELETE ARCHIVELOG MAXSIZE RMAN> DELETE FORCE ARCHIVELOG ALL COMPLETED BEFORE
2M; 'sysdate-1.5';
RMAN> RECOVER DATAFILE 33; RMAN> DELETE FORCE ARCHIVELOG UNTIL SEQUENCE=16364;
RMAN> RECOVER DATAFILE 3 BLOCK 116 DATAFILE 4 BLOCK 10; RMAN> DELETE NOPROMPT ARCHIVELOG UNTIL SEQUENCE = 7300;
RMAN> RECOVER DATAFILE 2 BLOCK 204 DATAFILE 9 BLOCK 109 RMAN> DELETE EXPIRED ARCHIVELOG ALL;
FROM TAG=sundaynight; RMAN> DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
RMAN> RECOVER DATAFILECOPY '/disk1/img.df' UNTIL TIME RMAN> DELETE BACKUPSET 101, 102, 103;
'SYSDATE-7'; RMAN> DELETE NOPROMPT BACKUPSET TAG weekly_bkup;
RMAN> RECOVER COPY OF DATABASE WITH TAG 'incr'; RMAN> DELETE FORCE NOPROMPT BACKUPSET TAG weekly_bkup;
RMAN> RECOVER COPY OF DATABASE WITH TAG 'upd' UNTIL TIME
'SYSDATE - 7'; RMAN> DELETE DATAFILECOPY
RMAN> RECOVER CORRUPTION LIST; "+DG_DATA/db/datafile/system.259.699468079";
RMAN> DELETE CONTROLFILECOPY '/tmp/cntrlfile.copy';
Restore and recover the whole database RMAN> DELETE BACKUP DEVICE TYPE SBT;
RMAN> STARTUP FORCE MOUNT; RMAN> DELETE BACKUP DEVICE TYPE DISK;
RMAN> RESTORE DATABASE; RMAN> DELETE COPY;
RMAN> RECOVER DATABASE; RMAN> DELETE EXPIRED COPY;
RMAN> ALTER DATABASE OPEN; RMAN> DELETE COPY TAG 'lastest';

Restore and recover a tablespace

RMAN> SQL 'ALTER TABLESPACE users OFFLINE';
RMAN> RESTORE TABLESPACE users;
RMAN> RECOVER TABLESPACE users;
RMAN> SQL 'ALTER TABLESPACE users ONLINE';
DROP DATABASE command
Restore and recover a datafile Delete the target database from disk and unregisters it.
RMAN> SQL 'ALTER DATABASE DATAFILE 12 OFFLINE'; RMAN> DROP DATABASE;
RMAN> RESTORE DATAFILE 12; RMAN> DROP DATABASE NOPROMPT;
RMAN> RECOVER DATAFILE 12; RMAN> DROP DATABASE INCLUDING BACKUPS;
RMAN> SQL 'ALTER DATABASE DATAFILE 12 ONLINE'; RMAN> DROP DATABASE INCLUDING BACKUPS NOPROMPT;

DUPLICATE command
DELETE command Use backups of the target database to create a duplicate database

7 TECHGOEASY.COM
 RMAN CHEAT SHEET

that we can use for testing purposes or to create a standby RMAN> SWITCH DATAFILE ALL;
database. RMAN> SWITCH DATAFILE '/disk1/tols.dbf' TO DATAFILECOPY
RMAN> DUPLICATE TARGET DATABASE; '/disk2/tols.copy';
RMAN> DUPLICATE TARGET DATABASE TO <DB_NAME>; RMAN> SWITCH DATAFILE
RMAN> DUPLICATE TARGET DATABASE TO test "+DG_OLD/db/datafile/sysaux.260.699468081" TO COPY;
PFILE=/u01/apps/db/inittest.ora; RMAN> SWITCH TEMPFILE 1;
RMAN> DUPLICATE TARGET DATABASE TO <DB_NAME> RMAN> SWITCH TEMPFILE 1 TO '/newdisk/dbs/temp1.f';
NOFILENAMECHECK; RMAN> SWITCH TEMPFILE ALL;
RMAN> DUPLICATE DATABASE 'prod' DBID 139525561 TO 'dupdb' RMAN> SWITCH CLONE DATAFILE ALL;
NOFILENAMECHECK;
RMAN> DUPLICATE DATABASE TO <DB_NAME> NOFILENAMECHECK
BACKUP LOCATION '/apps/oracle/backup';
RMAN> DUPLICATE TARGET DATABASE TO dup FROM ACTIVE
DATABASE NOFILENAMECHECK PASSWORD FILE SPFILE; CATALOG command
Add information about file copies and user-managed backups to the
RMAN> DUPLICATE TARGET DATABASE TO dupdb catalog repository.
LOGFILE GROUP 1 RMAN> CATALOG DATAFILECOPY '<file location>';
('?/dbs/dupdb_log_1_1.f','?/dbs/dupdb_log_1_2.f') SIZE 200K, RMAN> CATALOG DATAFILECOPY '<file location>' LEVEL 0;
GROUP 2 ('?/dbs/dupdb_log_2_1.f','?/dbs/dupdb_log_2_2.f') SIZE RMAN> CATALOG CONTROLFILECOPY '/disk3/backup/cf_copy.bkp';
200K REUSE; RMAN> CATALOG ARCHIVELOG '<arch location>’;
RMAN> DUPLICATE TARGET DATABASE TO dup FOR STANDBY FROM RMAN> CATALOG BACKUPPIECE '<backup piece location>;
ACTIVE DATABASE PASSWORD FILE SPFILE RMAN> CATALOG LIKE '/backup';
PARAMETER_VALUE_CONVERT '/disk1', '/disk2' RMAN> CATALOG START WITH '/fs2/arch';
SET DB_FILE_NAME_CONVERT '/disk1','/disk2' RMAN> CATALOG START WITH '/disk2/archlog' NOPROMPT;
SET LOG_FILE_NAME_CONVERT '/disk1','/disk2' RMAN> CATALOG START WITH '+FLASH';
SET SGA_MAX_SIZE 200M SET SGA_TARGET 125M; RMAN> CATALOG RECOVERY AREA;

RMAN> DUPLICATE TARGET DATABASE FOR STANDBY

NOFILENAMECHECK;
RMAN> DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE ALLOCATE command
DATABASE; Establish a channel, which is a connection between RMAN and a
RMAN> DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE database instance.
DATABASE NOFILENAMECHECK; RMAN> ALLOCATE CHANNEL c1 DEVICE TYPE sbt_tape;
RMAN> DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE RMAN> ALLOCATE CHANNEL c1 DEVICE TYPE DISK FORMAT
DATABASE ‘C:\ORACLEBKP\DB_U%’;
SPFILE PARAMETER_VALUE_CONVERT '/stg/','/muc/' RMAN> ALLOCATE CHANNEL t1 DEVICE TYPE DISK CONNECT
SET "DB_UNIQUE_NAME"="muc" 'sys/pwd@bkp1’;
SET LOG_FILE_NAME_CONVERT '/stg/','/muc/' RMAN> ALLOCATE CHANNEL c1 DEVICE TYPE sbt_tape PARMS
SET DB_FILE_NAME_CONVERT '/stg/','/muc/' 'ENV=(OB_MEDIA_FAMILY=wholedb_mf)';
DORECOVER; RMAN> ALLOCATE CHANNEL t1 DEVICE TYPE sbt_tape PARMS
RMAN> DUPLICATE DATABASE TO newdb 'ENV=(OB_DEVICE_1=tape1, OB_DEVICE_2=tape3)';
UNTIL RESTORE POINT firstquart12 RMAN> ALLOCATE CHANNEL t1 TYPE 'sbt_tape'
DB_FILE_NAME_CONVERT='/u01/prod1/dbfiles/','/u01/newdb/dbfi PARMS='SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so.1';
les' RMAN> ALLOCATE CHANNEL t1 TYPE 'sbt_tape' SEND
PFILE = '/u01/newdb/admin/init.ora'; "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;
SWITCH command
Specify that a datafile copy is now the current datafile, i.e. the ALLOCATE CHANNEL FOR MAINTENANCE - allocate a channel in
datafile pointed to by the control file. This command is equivalent to preparation for issuing maintenance commands such as DELETE.
the SQL statement ALTER DATABASE RENAME FILE as it applies to RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
datafiles. RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK
RMAN> SWITCH DATABASE TO COPY; FORMAT "/disk2/%U";
RMAN> SWITCH TABLESPACE users TO COPY; RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK

8 TECHGOEASY.COM
 RMAN CHEAT SHEET

CONNECT '@test1';
RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt;
RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt VALIDATE command
PARMS 'SBT_LIBRARY=/usr/local/oracle/backup/lib/libobk.so, Examine a backup set and report whether its data is intact. RMAN
ENV=(OB_DEVICE_1=tape2)'; scans all of the backup pieces in the specified backup sets and looks
at the checksums to verify that the contents can be successfully
restored.
RMAN> VALIDATE BACKUPSET 218;
RMAN> VALIDATE BACKUPSET 3871, 3890;
RMAN> VALIDATE DATABASE;
RELEASE CHANNEL command RMAN> VALIDATE CHECK LOGICAL DATABASE;
Release a channel that was allocated with an ALLOCATE CHANNEL or RMAN> VALIDATE SKIP INACCESSIBLE DATABASE;
ALLOCATE CHANNEL FOR MAINTENANCE command. RMAN> VALIDATE COPY OF DATABASE;
RMAN> RELEASE CHANNEL; RMAN> VALIDATE TABLESPACE dwh;
RMAN> RELEASE CHANNEL c1; RMAN> VALIDATE COPY OF TABLESPACE dwh;
RMAN> VALIDATE DATAFILE 2;
RMAN> VALIDATE DATAFILE 4,8;
RMAN> VALIDATE DATAFILE 4 BLOCK 56;
RMAN> VALIDATE DATAFILE 8 SECTION SIZE = 200M;
BLOCKRECOVER command RMAN> VALIDATE CURRENT CONTROLFILE;
Will recover the corrupted blocks. RMAN> VALIDATE SPFILE;
RMAN> BLOCKRECOVER CORRUPTION LIST; RMAN> VALIDATE RECOVERY FILES;
RMAN> BLOCKRECOVER DATAFILE 8 BLOCK 22; RMAN> VALIDATE RECOVERY AREA;
RMAN> BLOCKRECOVER DATAFILE 7 BLOCK 233,235 DATAFILE 4 RMAN> VALIDATE DB_RECOVERY_FILE_DEST;
BLOCK 101;
RMAN> BLOCKRECOVER DATAFILE 2 BLOCK 12,13 DATAFILE 3 BLOCK
5,98,99 DATAFILE 4 BLOCK 19;
RMAN> BLOCKRECOVER DATAFILE 3 BLOCK 2,4,5 TABLESPACE sales
DBA 4194405,4194412 FROM DATAFILECOPY; SPOOL command
RMAN> BLOCKRECOVER TABLESPACE dwh DBA 4194404,4194405 Write RMAN output to a log file.
FROM TAG "weekly"; RMAN> SPOOL LOG TO '/tmp/spool.log';
RMAN> BLOCKRECOVER TABLESPACE dwh DBA 94404 RESTORE RMAN> SPOOL LOG TO '/tmp/backup.log' APPEND;
UNTIL TIME 'SYSDATE-2'; RMAN> SPOOL LOG OFF;

ADVISE FAILURE command run command

Display repair options. Execute a sequence of one or more RMAN commands, which are
RMAN> ADVISE FAILURE; one or more statements executed within the braces of RUN.
RMAN> ADVISE FAILURE 555, 242; RMAN> run {
RMAN> ADVISE FAILURE ALL; ALLOCATE CHANNEL c1 TYPE DISK FORMAT '/orabak/%U';
RMAN> ADVISE FAILURE CRITICAL; BACKUP TABLESPACE users;
RMAN> ADVISE FAILURE HIGH; }
RMAN> ADVISE FAILURE LOW; RMAN> run {
RMAN> ADVISE FAILURE HIGH EXCLUDE FAILURE 625; ALLOCATE CHANNEL c1 TYPE DISK FORMAT '&1/%U';
BACKUP TABLESPACE &2;
}
RMAN> run
{
REPAIR FAILURE command ALLOCATE CHANNEL dev1 DEVICE TYPE DISK FORMAT '/fs1/%U';
Repair one or more failures recorded in the automated diagnostic ALLOCATE CHANNEL dev2 DEVICE TYPE DISK FORMAT '/fs2/%U';
repository. BACKUP(TABLESPACE system,fin,mark FILESPERSET 20) (DATAFILE
RMAN> REPAIR FAILURE; 2,3,6);
RMAN> REPAIR FAILURE PREVIEW; }
RMAN> REPAIR FAILURE NOPROMPT;
RMAN> REPAIR FAILURE USING ADVISE OPTION integer;

9 TECHGOEASY.COM
 RMAN CHEAT SHEET

CREATE SCRIPT command

Create a stored script and store it in the recovery catalog. TRANSPORT TABLESPACE command
Create transportable tablespace sets from backup for one or more
RMAN> CREATE SCRIPT backup_whole tablespaces.
COMMENT "backup whole database and archived redo log files" RMAN> TRANSPORT TABLESPACE example, tools
{BACKUP INCREMENTAL LEVEL 0 TAG backup_whole FORMAT TABLESPACE DESTINATION '/disk1/trans' AUXILIARY DESTINATION
"/disk2/backup/%U" DATABASE PLUS ARCHIVELOG;} '/disk1/aux' UNTIL TIME 'SYSDATE-15/1440';
RMAN> TRANSPORT TABLESPACE exam
RMAN> CREATE SCRIPT backup_ts_users TABLESPACE DESTINATION '/disk1/trans' AUXILIARY DESTINATION
COMMENT 'tablespace users backup' '/disk1/aux' DATAPUMP DIRECTORY dpdir DUMP FILE 'dmpfile.dmp'
{ALLOCATE CHANNEL c1 TYPE DISK FORMAT 'c:\temp\%U'; IMPORT SCRIPT 'impscript.sql' EXPORT LOG 'explog.log';
BACKUP TABLESPACE users;}

RMAN> CREATE SCRIPT df {BACKUP DATAFILE &1 TAG &2.1 FORMAT

'/disk1/&3_%U';}
RMAN> CREATE SCRIPT backup_ts_users FROM FILE CONVERT command
'backup_ts_users.rman'; Convert datafile formats for transporting tablespaces and databases
RMAN> CREATE GLOBAL SCRIPT gl_backup_db {BACKUP DATABASE across platforms.
PLUS ARCHIVELOG;} RMAN> CONVERT DATABASE NEW DATABASE 'prodwin' TRANSPORT
RMAN> CREATE GLOBAL SCRIPT backup_db SCRIPT '/tmp/convertdb/transportscript' TO PLATFORM 'Microsoft
COMMENT "back up any database from the recovery catalog, with Windows IA (32-bit)' DB_FILE_NAME_CONVERT
logs" '/disk1/oracle/dbs','/tmp/convertdb';
{BACKUP DATABASE;} 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
PRINT SCRIPT command CONVERT SCRIPT '/tmp/convert_newdb.rman' TRANSPORT SCRIPT
Display a stored script. '/tmp/transport_newdb.sql' NEW DATABASE 'prodaix'
RMAN> PRINT SCRIPT backup_db; DB_FILE_NAME_CONVERT '/u01/oradata/datafile','+DATA';
RMAN> PRINT GLOBAL SCRIPT backup_db;
RMAN> PRINT GLOBAL SCRIPT gl_backup_db TO FILE RMAN> CONVERT TABLESPACE tbs_2 FORMAT '/tmp/tbs_2_%U.df';
"/tmp/gl_backupdb.rman"; RMAN> CONVERT TABLESPACE fin, hr TO PLATFORM 'Solaris[tm] OE
(32-bit)';
RMAN> CONVERT TABLESPACE fin, hr TO PLATFORM 'Solaris[tm] OE
(32-bit)' FORMAT '/tmp/transport_to_solaris/%U';

REPLACE SCRIPT command RMAN> CONVERT DATAFILE '/disk1/oracle/dbs/tbs_f1.df',

Replace an existing script stored in the recovery catalog. If the script '/disk1/oracle/dbs/ax1.f' FORMAT '+DATAFILE';
does not exist, then REPLACE SCRIPT creates it. RMAN> CONVERT DATAFILE '/u01/oradata/datafile/system.dbf'
RMAN> REPLACE SCRIPT backup_db {BACKUP DATABASE PLUS FROM PLATFORM 'Linux x86 64-bit' FORMAT '+DATA/system.dbf';
ARCHIVELOG;} RMAN> CONVERT DATAFILE
RMAN> REPLACE SCRIPT df {BACKUP DATAFILE &1 TAG &2.1 '/tmp/from_solaris/fin/fin01.dbf', '/tmp/from_solaris/fin/fin02.dbf',
FORMAT '&3_%U';} '/tmp/from_solaris/hr/hr01.dbf', '/tmp/from_solaris/hr/hr02.dbf'
RMAN> REPLACE GLOBAL SCRIPT backup_db {BACKUP DATABASE DB_FILE_NAME_CONVERT
PLUS ARCHIVELOG;} '/tmp/from_solaris/fin','/disk2/orahome/dbs/fin',
RMAN> REPLACE GLOBAL SCRIPT gl_full_bkp FROM FILE '/tmp/from_solaris/hr','/disk2/orahome/dbs/hr'
'/tmp/script_file.txt'; 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'
FLASHBACK DATABASE command DB_FILE_NAME_CONVERT='/ui/prod/oracle/oradata/SEARCHP/data
Return the database to its state at a previous time or SCN. /', '/tmp/test';
RMAN> FLASHBACK DATABASE TO SCN 411010;
RMAN> FLASHBACK DATABASE TO RESTORE POINT 'before_update';

10 TECHGOEASY.COM