Database Backup and Recovery (MOSC)

MOSC Banner

Configure RMAN for Standby database in data guard environemnt return (ORA-20079: full resync from pr

edited Nov 10, 2015 2:41AM in Database Backup and Recovery (MOSC) 7 commentsAnswered

Hi everybody,

we have a data guard as it shown below:

DGMGRL> show configuration ;

Configuration - RDG

  Protection Mode: MaxAvailability
  Members:
  SW67    - Primary database
    FRSC    - Far sync instance
      SW66    - Physical standby database
        LGSTDBY - Logical standby database (receiving current redo)

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 49 seconds ago)





next, you can check the status after I've created a catalog and registered the primary database, and configured all DB_UNIQUE_NAME for the Primary and all standbys.

ora12102@auts1vdb01t:/autdbtest01/archiv/SW67/FRA> rman target sys@sw67 catalog cat@sw64

Recovery Manager: Release 12.1.0.2.0 - Production on Thu Sep 3 10:24:18 2015

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

target database Password:
connected to target database: SW67 (DBID=2272582312)
recovery catalog database Password:
connected to recovery catalog database

RMAN> list db_unique_name of database;


List of Databases
DB Key  DB Name  DB ID            Database Role    Db_unique_name
------- ------- ----------------- ---------------  ------------------
1       SW67     2272582312       PRIMARY          SW67
1       SW67     2272582312       STANDBY          LGSTDBY
1       SW67     2272582312       STANDBY          SW66

RMAN>








Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center