{"id":8090,"date":"2019-04-26T15:11:05","date_gmt":"2019-04-26T15:11:05","guid":{"rendered":"https:\/\/rax-stg-wp-aws.com\/blogs\/roll-a-standby-database-forward-with-rman\/"},"modified":"2026-11-03T19:29:16","modified_gmt":"2026-11-03T19:29:16","slug":"roll-a-standby-database-forward-with-rman","status":"publish","type":"blogs","link":"https:\/\/www.rackspace.com\/en-gb\/blogs\/roll-a-standby-database-forward-with-rman\/","title":{"rendered":"Roll a standby database forward with RMAN"},"content":{"rendered":"

Introduction<\/strong><\/p>\n

If a physical standby database loses or corrupts an archived redo data or has an unresolvable archive gap, which is the result of archive logs getting missed on the primary database or the archives getting corrupted, then no valid backups exists for recovery.<\/p>\n

\nIf an archive exists on the primary database, troubleshoot the issue, and if the archive is not corrupted, the archive is automatically  transferred. If an archive is corrupted at the operating system (OS) level and you do have a backup, then restore the database by using the archive log from the backup. If none of these solutions work, you can recover the standby database with an incremental system change number (SCN) for standby\/Roll Forward.<\/p>\n

This blog shows you how to use the Oracle\u00a9 Recovery Manager (RMAN) incremental backup to roll the standby database forward faster than by using a redo log apply.<\/p>\n

 How does an incremental backup work?<\/strong><\/p>\n

The following image shows the incremental backup process:<\/p>\n

\"roll<\/p>\n

All the changes between the SCN of the original image copy and the SCN of the incremental backup are applied to the image. To use this method, create a backup on the primary database that starts at the standby database\u2019s current SCN, which you can then use to roll forward the standby database.<\/p>\n

 Steps to roll forward a physical standby database<\/strong><\/p>\n

Use the following steps to roll forward a physical standby database.<\/p>\n

 Find the SCN gap<\/strong><\/p>\n

1. Use the following code to record the SCN gap between the standby and the
\n   production databases:<\/p>\n

        SQL> select status,instance_name,database_role from v$database,v$instance;<\/em><\/p>\n

        STATUS       INSTANCE_NAME    DATABASE_ROLE
\n        ———— —————- —————-
\n        MOUNTED      PROD             PHYSICAL STANDBY<\/p>\n

        SQL> SELECT to_char(CURRENT_SCN) FROM V$DATABASE;<\/p>\n

        CURRENT_SCN
\n        ————-
\n        5997422841660<\/p>\n

        SQL> select min(fhscn) from x$kcvfh;<\/p>\n

        CURRENT_SCN
\n        ————-
\n        5997422841643<\/p>\n

2. Note the lower SCN from the preceding queries, and run the following code:<\/p>\n

\n        SQL> select status,instance_name,database_role from v$database,v$instance;<\/em><\/p>\n

        STATUS       INSTANCE_NAME    DATABASE_ROLE
\n        ———— —————- —————-
\n        OPEN          PROD             PRIMARY<\/p>\n

        SQL> SELECT to_char(CURRENT_SCN) FROM V$DATABASE;<\/p>\n

        CURRENT_SCN
\n        ————-
\n        5997428587053
\n <\/p>\n

  Take an incremental SCN backup and create a standby controlfile backup<\/strong><\/p>\n

1. Run the following code on the production server to take an SCN backup:<\/p>\n

        [oracle@pslmtli.rackspace.com] $ rman target \/
\n        RMAN>BACKUP INCREMENTAL FROM SCN 5997422841643 DATABASE FORMAT ‘\/u01\/orapi\/stage\/TEMP\/DBDR_%U’ tag ‘ArchiveGap’;
\n        Starting backup at 25-MAR-18<\/em><\/p>\n

        channel ORA_DISK_1: starting full datafile backup set
\n        channel ORA_DISK_1: specifying datafile(s) in backup set
\n        including current control file in backup set
\n        channel ORA_DISK_1: starting piece 1 at 25-MAR-18
\n        channel ORA_DISK_1: finished piece 1 at 25-MAR-18
\n        piece handle=\/u01\/orapi\/stage\/TEMP\/ DBDR123.bak tag= ArchiveGap comment=NONE
\n        channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
\n        Finished backup at 25-MAR-18<\/em><\/p>\n

2. Run the following code to create the standby controlfile<\/strong> backup:<\/p>\n

  RMAN> backup current controlfile for standby format =’\/u01\/orapi\/stage\/TEMP\/standby_control.bctl’;<\/em><\/p>\n

3. Transfer the backups from the primary server to the standby.<\/p>\n

\n4. Run the following code to apply a incremental SCN backup on the standby
\n   database, which catalogs all the backup pieces and the controlfile<\/strong><\/p>\n

 [oracle@nslmtli.rackspace.com] $ rman target \/<\/em><\/p>\n

        Recovery Manager: Release 11.2.0.1.0 – Production on Sun Mar 2515:51:02 2012<\/em><\/p>\n

        Copyright (c) 1982, 2009, Oracle and\/or its affiliates.  All rights reserved.<\/em><\/p>\n

        connected to target database: PSTLI (DBID=431934829, not open)<\/em><\/p>\n

        RMAN> catalog start with \u2018\/u01\/archives\/stage\/temp\/\u2019;<\/em><\/p>\n

5. Run the following code to recover the standby database with the cataloged incremental backup pieces:<\/p>\n

        RMAN> RECOVER DATABASE NOREDO;<\/em><\/p>\n

6. Run the following code to shutdown the physical standby database, start it in the nomount<\/em> stage, and restore the standby controlfile <\/strong> backup that you took from the primary database:<\/p>\n

        RMAN> shutdown immediate<\/em><\/p>\n

        database dismounted
\n        Oracle instance shut down<\/em><\/p>\n

        RMAN> startup nomount<\/em><\/p>\n

        connected to target database (not started)
\n        Oracle instance started<\/em><\/p>\n

        Total System Global Area     659730432 bytes<\/em><\/p>\n

        Fixed Size                     2216264 bytes
\n        Variable Size                398462648 bytes
\n        Database Buffers             255852544 bytes
\n        Redo Buffers                   3198976 bytes<\/em><\/p>\n

        RMAN> restore standby controlfile from \u2018\/u01\/archives\/stage\/temp\/standby_control.bctl\u2019;<\/em><\/p>\n

        Finished restore at 25-MAR-18<\/em><\/p>\n

\n7. Shutdown the standby database and mount the standby database so that you can    mount the standby database with the new controlfile <\/strong>that was restored in the previous step.<\/p>\n

Now the standby database is synchronized with the primary database.<\/p>\n

 Conclusion<\/strong><\/p>\n

You can use RMAN incremental backups to synchronize a physical standby database with the primary database. By using the RMAN BACKUP INCREMENTAL FROM SCN<\/em> command, you can create a backup on the primary database that starts at the standby database’s current SCN, which you can then use to roll the standby database forward in time.<\/p>\n","protected":false},"excerpt":{"rendered":"

Roll a standby database forward with RMAN<\/p>\n","protected":false},"author":2,"featured_media":8092,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","format":"standard","meta":{"content-type":"","nid":"26597","content_type":"blog","created_by":"10130","authored_on":"2024-02-09T16:11:05+00:00","field_article_industries":"","tag_category":"Technical","field_blog_author_text":"by Rackspace Technology Staff","seo_description":"Utilize Oracle Recovery Manager (RMAN) incremental backup for faster standby database roll-forward, ensuring efficient data recovery and minimal downtime.\r\n","field_featured_image":"","insights_image":"\/wp-content\/uploads\/2026\/blog_technical_images\/26597-insights_image-oracle-technical-blog-1-insights.jpg","field_partners":"","rxt_platforms":"Oracle","product":"","publisheddate":"2019-04-26T15:11:05","rxt_solutions":"Cloud Optimization, Data, Databases","opengraph_tag":"","x_tag":"","teaser_flag":"Technical Blog","seo_titile":"Roll a Standby Database Forward with RMAN | Rackspace Technology","field_topics":"","field_slug":"roll-standby-database-forward-with-rman","footnotes":""},"categories":[178],"tags":[204],"class_list":["post-8090","blogs","type-blogs","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-technical"],"_links":{"self":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/8090","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs"}],"about":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/types\/blogs"}],"author":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/comments?post=8090"}],"version-history":[{"count":3,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/8090\/revisions"}],"predecessor-version":[{"id":9870,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/8090\/revisions\/9870"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media\/8092"}],"wp:attachment":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media?parent=8090"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/categories?post=8090"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/tags?post=8090"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}