Activer/désactiver le dataguard

merci :

 

http://www.lami-dba.com/2018/03/desactiver-active-dataguard.html

Restaurer une base après avoir créé un point de restaure.

RMAN> shutdown immediate
RMAN> startup mount
RMAN> run
2> {
3> set until restore point <nomdupointderestaure>;
4> restore database;
5> recover database;
6> }
 
RMAN> alter database open resetlogs;
database opened
RMAN>

Dataguard - refresh a physical standby dataguard from primary avec RMAN

 

Steps to Refresh a Physical Standby Database with Changes Made to the Primary Database

 

source : https://docs.oracle.com/en/database/oracle/oracle-database/18/spmss/refresh-a-physical-standby-db.html#GUID-828A4953-3F7E-4975-ADA4-5469D6794BB0

 le site inclus les prérequis que l'on oublie souvent:

 

• Oracle Net connectivity is established between the physical standby database and the primary database.

  You can do this by adding an entry corresponding to the primary database in the tnsnames.ora file of the physical standby database.

• The password files on the primary database and the physical standby database are the same.

• The COMPATIBLE parameter in the initialization parameter file of the primary database and physical standby database is set to 12.0.

 

...

4 . (For Active Data Guard only) Perform the following steps to recover redo data and open the physical standby database in read-only mode:

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE UNTIL CONSISTENT;

ALTER DATABASE OPEN READ ONLY;

...

 

Dataguard - start and stop a standby database on server startup

Source : https://www.orafaq.com/forum/t/122395/

 

to start a standby database :

 

#!/bin/bash
ORA_HOME="/opt/oracle/920"
ORA_OWNER="oracle"
SQLCMD="sqlplus '/as sysdba'"
LOGFILE="strt.log"
cat startup.sql | su - $ORA_OWNER  -c "$SQLCMD" > $LOGFILE

 

to shutdown a standby database :

#!/bin/bash
ORA_HOME="/opt/oracle/920"
ORA_OWNER="oracle"
SQLCMD="sqlplus '/as sysdba'"
LOGFILE="sht.log"
cat shutdown.sql | su - $ORA_OWNER  -c "$SQLCMD" > $LOGFILE

 

startup.sql :

startup nomount;
alter database mount standby database;
alter database recover managed standby database disconnect from session;

 

shutdown.sql:

alter database recover managed standby database cancel;
shutdown immediate;
exit

 

Dataguard - qqs commandes bien utiles

Source : https://valehagayev.wordpress.com/2016/07/09/dataguard-commands-and-sql-scripts/

start redo apply in foreground

stop redo apply process on the Standby database (to stop MRP)

start real-time redo apply

start redo apply in background

check redo apply  and Media recovery service status

gather Data Guard configuration information(standby)

calculate the Redo bytes per second

check status of Data Guard synchronization(standby)

verify there is no log file gap between the primary and the standby database

verify that the primary database can be switched to the standby role

convert the primary database into a physical standby

verify Managed Recovery is running on the standby

show information about the protection mode, the protection level, the role of the database, and switchover status

On the standby database, query the V$ARCHIVED_LOG view to identify existing files in the archived redo log

On the standby database, query the V$ARCHIVED_LOG view to verify the archived redo log files were applied.

To determine which log files were not received by the standby site.

http://www.aodba.com/steps-stop-start-oracle-standby-database/

https://support.oracle.com/knowledge/Oracle%20Database%20Products/1221163_1.html

MRP : Managed Recovery Process

 

et bien plus encore sur le DG Broker .