Differences

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

--- rman [2019/06/03 15:25] – z0hpvk
+++ rman [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 12: / Line 12: @@
 <code>BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;
+BACKUP AS COMPRESSED BACKUPSET DATABASE FORMAT '/home/oracle/%U' PLUS ARCHIVELOG;
+BACKUP ARCHIVELOG FROM SEQUENCE 7500;
+BACKUP ARCHIVELOG FROM SEQUENCE 7500 UNTIL SEQUENCE 8000 FORMAT '/home/oracle/%U';
+BACKUP ARCHIVELOG FROM TIME 'SYSDATE -1';
 DELETE ARCHIVELOG ALL;
@@ Line 20: / Line 24: @@
 LIST BACKUP OF ARCHIVELOG SEQUENCE BETWEEN xxxxx AND xxxxx;
-CATALOG START WITH '<FILE_LOCATION>';</code>
+CATALOG START WITH '<FILE_LOCATION>';
+-- Data files showing in wrong location in control file
+CATALOG START WITH '<DATAFILE_LOCATION>';
+SWITCH DATABASE TO COPY;
+RECOVER DATABASE;
+</code>
 ==== Fast Recovery Area ====
@@ Line 32: / Line 42: @@
 select * from V$RECOVERY_AREA_USAGE;
+</code>
+==== Incremental Recovery ====
+This procedure is useful if a standby database has missing archive logs. \\
+<code>
+COL CURRENT_SCN FORMAT 999999999999999
+SELECT CURRENT_SCN FROM V$DATABASE;
+SELECT MIN(FHSCN) FROM X$KCVFH;
+</code>
+Example lowest number is 123456
+<code>
+RMAN> BACKUP INCREMENTAL FROM SCN 123456 DATABASE FORMAT 'F:\ad-hoc_backup\CPHG\ForStandby_%U' tag 'INCR_STANDBY';
+</code>
+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 control file backup to the standby server. \\
+If database locations are different on the standby server record the names ...
+<code>
+RMAN> REPORT SCHEMA;
+RMAN> SHUTDOWN IMMEDIATE ;
+RMAN> STARTUP NOMOUNT;
+RMAN> RESTORE STANDBY CONTROLFILE FROM 'F:\adhoc_backup\CPHG\standby.ctl';
+SQL> SHUTDOWN;
+SQL> STARTUP MOUNT;
+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. \\
+<code>
+SQL> ALTER DATABASE CLEAR LOGFILE GROUP <STBY_GROUP_NO>;
 </code>