RMAN Commands List
--To Connect in rman tool
rman target/
[oracle@]$ rman target/
Recovery Manager: Release 10.2.0.4.0 - Production on Sat Jul 19 01:20:04 2014
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: CRMPRD (DBID=382866142)
-- Check the RMAN configuration
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/product/10.2.0/db_1/dbs/snapcf_sync.f'; # default
--To check backup detail :
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11 Full 163.90M DISK 00:00:28 07-JUL-14
BP Key: 11 Status: AVAILABLE Compressed: NO Tag: TAG20140707T003026
Piece Name: /shared/sync/backup/07july/0epcokp2_1_1.bkp
List of Datafiles in backup set 11
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 716451 07-JUL-14 /shared/sync/data/undo01.dbf
7 Full 716451 07-JUL-14 /shared/sync/data/system04.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12 Full 290.83M DISK 00:00:32 07-JUL-14
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20140707T003026
Piece Name: /shared/sync/backup/07july/0dpcokp2_1_1.bkp
RMAN> list backup summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
11 B F A DISK 07-JUL-14 1 1 NO TAG20140707T003026
12 B F A DISK 07-JUL-14 1 1 NO TAG20140707T003026
13 B F A DISK 07-JUL-14 1 1 NO TAG20140707T003026
14 B F A DISK 07-JUL-14 1 1 NO TAG20140707T003026
15 B F A DISK 07-JUL-14 1 1 NO TAG20140707T003026
16 B F A DISK 07-JUL-14 1 1 NO TAG20140707T003026
17 B F A DISK 07-JUL-14 1 1 NO TAG20140707T004125
18 B F A DISK 13-JUL-14 1 1 NO TAG20140713T071838
19 B F A DISK 13-JUL-14 1 1 NO TAG20140713T071838
20 B F A DISK 13-JUL-14 1 1 NO TAG20140713T071838
21 B F A DISK 13-JUL-14 1 1 NO TAG20140713T071838
22 B F A DISK 13-JUL-14 1 1 NO TAG20140713T071838
23 B F A DISK 13-JUL-14 1 1 NO TAG20140713T071838
24 B F A DISK 13-JUL-14 1 1 NO TAG20140713T115629
25 B F A DISK 14-JUL-14 1 1 NO TAG20140714T021344
26 B F A DISK 18-JUL-14 1 1 NO TAG20140718T091235
-- To check datafile details via rman
RMAN> report schema;
Report of database schema
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 325 SYSTEM *** /shared/sync/data/system01.dbf
2 200 UNDOTBS *** /shared/sync/data/undo01.dbf
3 400 SYSAUX *** /shared/sync/data/sysaux01.dbf
4 200 TBS_1 *** /shared/sync/data/users.dbf
5 4096 USERS *** /shared/sync/data/users01.dbf
6 4096 USERS *** /shared/sync/data/users02.dbf
7 500 SYSTEM *** /shared/sync/data/system04.dbf
8 2048 TMP *** /shared/sync/data/tmp.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMPTS1 20 /shared/sync/data/temp_tbs.dbf
2 1024 TEMP 1024 /shared/sync/data/temp01.dbf
Retention poilcy command
For all your daily backups maintain a normal retention policy i.e
Rman > configure retention policy for recovery window of 35 days
--- Taking full db backup if db is no archive mode please run it from mount state.
Backup Commands
run
{
allocate channel d1 device type disk format '/shared/sync/backup/07july/%U.bkp';
allocate channel d2 device type disk format '/shared/sync/backup/07july/%U.bkp';
allocate channel d3 device type disk format '/shared/sync/backup/07july/%U.bkp';
allocate channel d4 device type disk format '/shared/sync/backup/07july/%U.bkp';
BACKUP DATABASE ;
release channel d1;
release channel d2;
release channel d3;
release channel d4;
}
--By default rman will not take arch file and control file backup . in using below signal command we can take all 3 file backup
RMAN> backup database include current controlfile plus archive log;
The above command backs up the target database and the current control file and archive log files
--- Controlfile backup
RMAN> BACKUP CURRENT CONTROLFILE;
-- Here we are going to take INCREMENTAL LEVEL 0 and 1 backup . by default rman will take differential backup.we can take this type backup if db is archive log mode only .
RMAN> BACKUP INCREMENTAL LEVEL=0 DATABASE;
RMAN> BACKUP INCREMENTAL LEVEL=1 DATABASE;
-- The below command verifies all file available if any backup file is not available it will make as unavailable.
RMAN> crosscheck backup;
Recover and restore commands.
RMAN> restore database;
RMAN> recover database
Delete arch file which was created 1 hours before .
DELETE ARCHIVELOG ALL COMPLETED BEFORE "SYSDATE-1/24";
