TEST
Powered by Blogger.
Responsive Ad
Responsive Ad

Author Profile

About Me

Start Sharing

Start Sharing

Drive Traffic on Social Platforms

Blog Archive

Blog Journey

Blog Journey

Learn how to start a perfect Blog

Work Smart, Not Hard - Let's See

Make your Blogging experience faster and easiest …
Work Smart, Not Hard - Let's See
Design by - Blogger Templates | Distributed by Free Blogger Templates

Made with Love by

Material UI Template is Designed Theme for Giving Enhanced look Various Features are available Whic…

Random Posts

Ads Section

HOME > > ERROR: Checking sync on Primary and Standby... Failed

ERROR: Checking sync on Primary and Standby... Failed

Anup - Wednesday, 5 June 2013
Solution:-

Step 1: - Take backup of missing log sequence

RMAN> backup format '/home/oracle/arch_%s_%p_%t.bkp'
(ARCHIVELOG FROM SEQUENCE 8201 UNTIL SEQUENCE 8203 THREAD 2);

Step 2:- scp backup set to standby server

Step 3:- Catalog specific backup piece with standby.

CATALOG BACKUPPIECE '/home/oracle/arch_%s_%p_%t.bkp';

Step 4:- restore archive log on standby server

RMAN> restore archivelog sequence 225 thread 1;

Contact me

Get in Touch

Need to get touch with me? Please fill out the form with your enquiry.

Name
Anup Srivastav
Address
Lucknow - Utter Pradesh
Email
myindiandba@gmail.com
Message me