Differences

This shows you the differences between two versions of the page.

--- rman [2019/10/18 14:30] – z0hpvk
+++ rman [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 45: / Line 45: @@
 ==== Incremental Recovery ====
+This procedure is useful if a standby database has missing archive logs. \\
 <code>
-Missing archive logs
 COL CURRENT_SCN FORMAT 999999999999999
 SELECT CURRENT_SCN FROM V$DATABASE;
 SELECT MIN(FHSCN) FROM X$KCVFH;
+</code>
-Example lowest number is 12010222653623
+Example lowest number is 123456
+<code>
-RMAN> BACKUP INCREMENTAL FROM SCN 12010248705171 DATABASE FORMAT 'F:\ad-hoc_backup\CPHG\ForStandby_%U' tag 'INCR_STANDBY';
+RMAN> BACKUP INCREMENTAL FROM SCN 123456 DATABASE FORMAT 'F:\ad-hoc_backup\CPHG\ForStandby_%U' tag 'INCR_STANDBY';
+</code>
-Copy to the standby database server
+Copy backup file to the standby database server. \\
+<code>
 RMAN> CATALOG START WITH 'F:\adhoc_backup\CPHG';
 RMAN> RECOVER DATABASE NOREDO;
+</code>
+Backup the control file on the primary server. \\
+<code>
 RMAN> BACKUP CURRENT CONTROLFILE FOR STANDBY FORMAT 'F:\ad-hoc_backup\CPHG\standby.ctl';
+</code>
-Copy to the standby server
+Copy control file backup to the standby server. \\
 If database locations are different on the standby server record the names ...
+<code>
 RMAN> REPORT SCHEMA;
@@ Line 78: / Line 79: @@
 RMAN> CATALOG START WITH '<DATAFILE_LOCATION>';
 RMAN> SWITCH DATABASE TO COPY;
+</code>
-If this is a Data Guard configuration then clear the standby redo log groups
-SQL> ALTER DATABASE CLEAR LOGFILE GROUP 10;
+If this is a Data Guard configuration then clear the standby redo log groups. \\
+<code>
+SQL> ALTER DATABASE CLEAR LOGFILE GROUP <STBY_GROUP_NO>;
 </code>