ARCHIVEDLOGONLY TRANLOGOPTIONS

TRANLOGOPTIONS ARCHIVEDLOGONLY

Causes Extract to read from the archived logs only, without querying or validating the logs from system views such as v$log and v$archived_log. If this parameter is specified or the database is a standby database, you will be required to position the starting position of Extract to the physical address in the log, instead of using a timestamp.

 

TRANLOGOPTIONS ARCHIVEDLOGONLY
TRANLOGOPTIONS ALTARCHIVELOGDEST /oracle/g01/bkup01/archive/

 

Object ID Database – Object Database

The basic steps are the following:

  1. Initial Database setup
    1. Add GGS user to source DB
    2. Add/Check database level for supplemental logging.
    3. Add supplemental logging to tables needed in extract
  2. Make backup of primary DB – core tablespaces only
    1. This can be using RMAN, BCV splits, O.S. copy, Hot backup etc.
    2. System tablespace
    3. Rollback tablespace
    4. Temp tablespace
  3. Create standby controlfile
  4. Copy any archive log files to target system
  5. Copy Datafiles to like system
    1. Should be same structure of you will need to add parameters to map directory names
    2. Copy standby control file
  6. Startup standby DB no mount status

a. Offline drop any non-system, rollback datafiles 7. Startup mount DB

a. Recover database (standby recovery)

  1. Once recovery is until current time or last available archive file
    1. Open database read only
    2. If database needs more recovery before DB will open you need to check if ADVReplication is on for the source BD – Set in standby parameter file –

      replication_dependency_tracking = FALSE

    3. If ADV Rep is on you will need to disable it.
  2. Once DB is open you can start GGS.

10.

If the archived logs reside in a location other than the Oracle default, specify the
location with the ALTARCHIVELOGDEST option of the TRANLOGOPTIONS parameter in the Extract parameter file. This parameter is supported for RAC installations in release 10 and higher.


Posted

in

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *