How to View all RMAN Backups
To view all the
RMAN backups, execute “list backup summary” as shown below.
RMAN> LIST BACKUP SUMMARY;
using target database control file instead of
recovery catalog
List of Backups
===============
Key TY LV
S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- -------
------- ---------- ---
..
4215
B F A DISK
10-AUG-13 1 1
NO TAG20130808T114846
4216
B F A DISK
10-AUG-13 1 1
NO TAG20130808T114849
4217
B F A DISK
10-AUG-13 1 1
NO
WEEEKLY_PRD01_TBLS_BK_ONLY
4218
B F A DISK
10-AUG-13 1 1
NO TAG20130808T115413
4219
B F A DISK
10-AUG-13 1 1
NO
WEEEKLY_PRD01_TBLS_BK_ONLY
4220
B F A DISK
10-AUG-13 1 1
NO TAG20130808T115600
4221
B F A DISK
10-AUG-13 1 1
YES
WEEEKLY_PRD01_TBLS_BK_ONLY
As you see above,
it displays various information about the backups. In the above output, it show
7 RMAN backups. The last column shows the “Tag” that we specified when we took
a backup. If we didn’t specify any TAG, RMAN creates a default tag with the
prefix “TAG” followed by some numbers. You can also see that under the column
“Compressed”, the last RMAN backup shows “YES”, which indicates that out of all
the 7 RMAN backups, only the last one was compressed.
Also, when the RMAN
backup is running, if you want to see the progress, you can query the
V$RMAN_STATUS table from sql*plus as shown below.
SQL> SELECT OPERATION, STATUS, MBYTES_PROCESSED,
START_TIME, END_TIME from V$RMAN_STATUS;
OPERATION STATUS MBYTES_PROCESSED START_TIM
END_TIME
---------------------------------
----------------------- ---------------- --------- ---------
CONTROL FILE AND SPFILE AUTOBACK COMPLETED 14 07-NOV-12 07-NOV-12
RMAN COMPLETED 0 07-NOV-12
07-NOV-12
RESTORE VALIDATE COMPLETED 0 07-NOV-12
07-NOV-12
RMAN COMPLETED WITH ERRORS 0 07-NOV-12 07-NOV-12
DELETE COMPLETED 0 08-NOV-12
08-NOV-12
BACKUP COMPLETED 0 10-AUG-13 10-AUG-13
CONTROL FILE AND SPFILE AUTOBACK COMPLETED 14 10-AUG-13
10-AUG-13
RMAN COMPLETED WITH
ERRORS 1832 10-AUG-13
10-AUG-13
RMAN COMPLETED 0 10-AUG-13 10-AUG-13
...
There you have it!.
That is how you take an Oracle RMAN backup and sleep peacefully.
For all
RMAN Backup Command visit Below Link:
Ref.: http://www.thegeekstuff.com
Comments
Post a Comment