• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

The Geek Diary

CONCEPTS | BASICS | HOWTO

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • Linux Services
    • VCS
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
    • Data Guard
  • DevOps
    • Docker
    • Shell Scripting
  • Interview Questions
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Archives for February 2015

How to Roll Forward a standby database using RMAN incremental backup in 11g

By admin

The steps in this post can used to resolve problems if a physical standby database has lost or corrupted archived redo data or has an unresolvable archive gap. 1. Make sure you stop the managed recovery process (MRP) before going ahead with further steps. SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; 2. On the STANDBY DATABASE, find the SCN which will be used for the incremental backup at the primary database. You need to use the 'lowest SCN' from the the 3 queries below … [Read more...] about How to Roll Forward a standby database using RMAN incremental backup in 11g

Filed Under: oracle

Primary Sidebar

Recent Posts

  • How to Disable IPv6 on Ubuntu 18.04 Bionic Beaver Linux
  • How to Capture More Logs in /var/log/dmesg for CentOS/RHEL
  • Unable to Start RDMA Services on CentOS/RHEL 7
  • How to rename a KVM VM with virsh
  • Archives
  • Contact Us
  • Copyright

© 2021 · The Geek Diary