MIITDocID-958: RMAN Command Line Reference Guide --Moid
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCD
1
Part NumberCommand #CommandObjective
2
Part-1Check RMAN configuration, backup and tablespaces
3
1show all;To check the current RMAN settings
4
2list backup;To check the available backups
5
3report schema;To check the tablespace and datafile sizes.
6
Part-2Backup Management
7
1delete backup;To delete the backup from RMAN’s repository
8
2delete force backup;To delete the backups from RMAN’s repository regardless of files physical availability
9
3delete noprompt force backup;To delete the backups from RMAN’s repository without prompting.
10
4DELETE BACKUP COMPLETED BEFORE 'SYSDATE-7'To delete backup that are older than 7 days
11
5DELETE BACKUP COMPLETED After 'SYSDATE-7'To delete backup from past 7 days til now
12
6DELETE BACKUP COMPLETED BETWEEN 'sysdate-7' and 'sysdate-3';To delete backup between two dates.
13
Part-3Archivelog Management
14
LIST1list archivelog all;To check the available archive logs
15
2list archivelog from time 'sysdate-2';To check the last 1 day of archivelogs
16
3list archivelog from scn 1932537;To list all archivelogs from a particular SCN
Note: You may have to check SCN # first from v$archived_log

SQL> select sequence#, first_time, FIRST_CHANGE# from v$archived_log order by 1; --> Display Date
SQL> select sequence#, to_char(first_time, 'D-MON-YY HH24:MI:SS') as first_time , FIRST_CHANGE# from v$archived_log order by 1; --> Displays Date and Exact Time
17
4
18
DELETE1delete archivelog all;To delete all the archivelogs
19
2delete noprompt archivelog all;To delete the archivelogs without prompting
20
3delete force noprompt archivelog all;To delete the archivelogs withouth prompting and without checking its physical availability.
21
BACKUP1backup archivelog all;
22
2backup database plus archivelog all;
23
3backup archivelog all delete input;Backup all archivelog. Delete Once the backup is completed.
24
4backup archivelog all not backed up 1 times;Backup all archivelog which are not backed up atleast once.
25
5
backup archivelog all not backed up 1 times delete all input;
Backup all archivelog which are not backed up atleast once and then delete them.
26
6
27
Part-4Backup database manangement
28
1backup database;To take a full backup (without the intention of incremental backups).
29
2backup database plus archivelog;
30
3
31
4BACKUP INCREMENTAL LEVEL 0 database;To take a full backup (with the intention of incremental backups).
32
5backup incremental level 1 database;To take a incremental backup. A type of incremental backup that backs up all blocks that have changed since the most recent backup at level 1 or level 0
33
6BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;To take CUMALATIVE backup: This backups up all the blocks changed since the most recent backup at level 0. When recovering with cumulative incremental backups, only the most recent cumulative incremental backup needs to be applied.
34
Part-5Backup archivelog manangement
35
1delete expired backup;Any backupset which cannot be found on OS file directly (either delete or moved), are marked as expired.
36
2RESTORE DATABASE VALIDATE;Restore Validation confirms that a restore could be run,
by confirming that all database files exist and are free of
physical and logical corruption,
this does not generate any output
37
3delete obsolete;To delete any backups which are outside of retention policy.
38
4delete force obsolete;To delete any backups which are outside of retention policy regardless of its physical availability.
39
5delete force noprompt obsolete;To delete any backups which are outside of retention policy regardless of its physical availability. RMAN will not prompt user before deleting.
40
6delete archivelog until time '2007-04-30:09:30:50' backed up 1 times to device type disk;
41
Part-6Block corruption, datafile corruption,
42
1LIST FAILURE;This will list the detected failure with the FAILURE ID
43
2LIST FAILURE 101 DETAIL;Once the FAILURE ID is found out, you can find more details about that failure ID
44
3LIST RESTORE POINT ALL;You can list restore points known to the RMAN repository.
45
4LIST INCARNATIONYou can list all incarnations of a database. A new database incarnation is created when you open with the RESETLOGS option.
46
5
47
6VALIDATE DATABASE;To validate database.
If there is a datafile missing, it shows.
If there is a block corruption, it records in v$database_block_corruption; use "blockrecover corruption list;" to fix corrupted blocks
48
7VALIDATE CHECK logical database;
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu