RMAN - Revision history

Stuart: /* Validate backups or restores */

2018-10-20T12:16:11Z

‎Validate backups or restores

2018-10-16T13:36:37Z

‎A quick backup using Commvault

2018-09-18T13:12:00Z

‎Validate backups or restores

2018-09-04T14:02:59Z

‎Identifying Bottlenecks with V$BACKUP_SYNC_IO and V$BACKUP_ASYNC_IO

2018-09-04T14:02:19Z

‎Tuning RMAN performance

2018-09-04T13:55:07Z

‎Build a report of RMAN backup pieces using awk to munge the RMAN output

2018-09-04T13:52:36Z

‎Check the status of currently running backups

2018-07-23T10:19:39Z

‎Build a report of RMAN backup pieces using awk to munge the RMAN output

2018-07-23T10:14:42Z

‎Validate backups or restores

2018-07-19T09:35:05Z

‎A quick backup using EMC Networker

@@ Line 255: / Line 255: @@
 eg (using Commvault):
 <pre>
 run {
 allocate channel c0 type sbt_tape parms 'SBT_LIBRARY=/opt/commvault/Base64/libobk.a(shr.o),ENV=(cvsrcclientname=ci00031669-hn491)' ;
-set until time "to_date('18-AUG-18 10:10:00','DD-MON-YY HH24:MI:SS')";
+set until time "to_date('2018-08-17 16:00:00','YYYY-MM-DD HH24:MI:SS')";
 restore database validate;
+}

@@ Line 131: / Line 131: @@
 ===A quick backup using Commvault===
 <pre>
 set echo on
@@ Line 139: / Line 140: @@
+{
      allocate channel t0 type sbt_tape parms 'SBT_LIBRARY=/opt/commvault/Base64/libobk.a(shr.o),ENV=(cvsrcclientname=ci00031701-hn5219)';
      backup database including archivelog;
+}

@@ Line 239: / Line 239: @@
 restore <something> validate;
 </pre>
-eg:
+eg (using Commvault):
 <pre>
 backup database validate;
@@ Line 255: / Line 263: @@
 </pre>
 Use "preview" instead of "validate" to see the list of backup pieces that would be used in the restore process. "preview" actually mimics the performance of the task. "validate" does a brief check.
 ===Tuning RMAN performance===
 * [https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmtunin.htm oracle.com]

@@ Line 258: / Line 258: @@
 * [https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmtunin.htm oracle.com]
 ===Identifying Bottlenecks with V$BACKUP_SYNC_IO and V$BACKUP_ASYNC_IO===
-* [https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmtunin.htm#BRADV89862 ]
+* [https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmtunin.htm#BRADV89862 oracle.com]
 ===Build a report of RMAN backup pieces using awk to munge the RMAN output===

@@ Line 256: / Line 256: @@
 Use "preview" instead of "validate" to see the list of backup pieces that would be used in the restore process. "preview" actually mimics the performance of the task. "validate" does a brief check.
 ===Tuning RMAN performance===
-* [https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmtunin.htm#BRADV011 oracle.com]
+* [https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmtunin.htm oracle.com]
 ===Build a report of RMAN backup pieces using awk to munge the RMAN output===
 <pre>

@@ Line 1,167: / Line 1,167: @@
 ===Check the status of currently running backups===
 <pre>
-SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,
+select sid
-   ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"
+,      serial#
-FROM V$SESSION_LONGOPS
+,      context
-WHERE
+,      sofar
-  OPNAME LIKE 'RMAN%'
+,      totalwork
---AND OPNAME NOT LIKE '%aggregate%'
+,      round(sofar/totalwork*100,2) "%_complete"
-  AND TOTALWORK != 0
+from   v$session_longops
-  AND SOFAR <> TOTALWORK
+where  1=1
+/
 </pre>

@@ Line 258: / Line 258: @@
 <pre>
 export NLS_DATE_FORMAT='yyyymmddhh24miss'; echo "restore controlfile preview; restore database preview;" | rman target / | awk '
 /Finished restore at /{timestamp=$4}
 /Recovery must be done beyond SCN /{if ($7>scn) scn=$7 }

@@ Line 254: / Line 254: @@
 restore tablespace users validate;
 </pre>
-Substitute "validate" by "preview" to see the list of backup pieces that would be used in the restore process.
+Use "preview" instead of "validate" to see the list of backup pieces that would be used in the restore process. "preview" actually mimics the performance of the task. "validate" does a brief check.
 ===Script to validate the database and all archivelogs needed for a restore===
 Environment must be set before running...

@@ Line 104: / Line 104: @@
 order  by start_time
+/
 </pre>
 ===A quick backup using EMC Networker===