SHOW
CONFIGURATION VERBOSE
SHOW DATABASE
VERBOSE 'pwebb';
SHOW INSTANCE pweb1 on database <dbuniquename>
show database
'pweb' 'InconsistentProperties'
show database
'pweb' 'InconsistentLogXptProps';
SHOW DATABASE
'pwebb' 'StatusReport';
SHOW DATABASE 'pwebc' 'latestlog';
SHOW DATABASE
'pweb' 'LogXptStatus';
SHOW DATABASE
'pwebb' 'LogXptStatus';
- List Info for Specific DB eg DB Mode(primary or Stby),
Apply Status,
SHOW DATABASE 'pwebc' No of Instances,Which inst is applying
logs
- List All Above,Properties & Values
SHOW DATABASE VERBOSE 'pwebc'
- Inst level info & Standby Archive location &
connect identifier
SHOW INSTANCE VERBOSE pweb1 on database pwebc;
SHOW DATABASE VERBOSE pwebc StandbyArchiveLocation
- Good one Mostly return blank if ok
SHOW DATABASE 'pwebc' 'StatusReport';
- Get dbUniqueName
& instance from "SHOW CONFIGURATION
SHOW INSTANCE
VERBOSE <instName> 'LogXptStatus' on database <dbUniqueName>
-----------------------------------------------------------------------
Changing Dataguard Properties , More Examples are below
-----------------------------------------------------------------------
--EDIT CONFIGURATION SET PROTECTION MODE AS MAXPROTECTION;
--EDIT DATABASE 'dvlpb' SET PROPERTY 'LogXptMode'='SYNC';
--EDIT DATABASE 'dvlpb' SET PROPERTY
'StandbyArchiveLocation'='+DG_BACKUP';
-----------
Primary
-----------
--edit database prod1 set state=transport-off;
--edit database prod1 set state=transport-on;
-----------
Standby
-------------
--edit database prod1dr set state=apply-off;
--edit database prod1dr set state=apply-on;
change the protection mode
--------------------------
Primary
# Choose what level of protection you require
sql> alter
database set standby to maximize performance;
sql> alter
database set standby to maximize availability;
sql> alter
database set standby to maximize protection;
========================================================================
How to change the Archive of Primary going to ASMDISKS on
Standby Node
=========================================================================
Standby Node:
--------------
SQL> show parameter db_recovery_file_dest
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
db_recovery_file_dest string +DG_BACKUP
db_recovery_file_dest_size big integer 100000G
--alter system set
log_archive_dest_1='LOCATION=use_db_recovery_file_dest,
valid_for=(ALL_ROLES,ONLINE_LOGFILE)';
DGMGRL> show database verbose <dbname>
StandbyArchiveLocation
DGMGRL> edit
database dvlpb set property StandbyArchiveLocation='USE_DB_RECOVERY_FILE_DEST'
