Step by step creating Data Guard . . .
Step by Step creating Oracle Dataguard
—————————————
STARTUP MOUNT;
ALTER DATABASE CREATE STANDBY CONTROLFILE AS ‘/tmp/boston.ctl’;
ALTER DATABASE OPEN;
CREATE PFILE=’/tmp/initboston.ora’ FROM SPFILE;
MODIFIKASI INIT FOR PRIMARY DB AND STANDBY DB
COPY DATAFILE AND LOGFILE TO STANDBY SERVER ( ex : using scp)
CREATING PASSWORD FILE ON STANDBY DATABASE (PASSWORD MUST BE SAME BETWEEN PRIMARY AND STANDBY) using orapwd utility as following :
orapwd file=password_file_name password=the_secret_password
orapwd file=password_file_name password=the_secret_password entries=n
STARTUP NOMOUNT PFILE=INITSTDBY.ora
CREATE SPFILE FROM SPFILE
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
Connect to the physical standby database, and create the standby redo logs to support the standby role.
standby redo logs must be the same size as the primary database online logs. The recommended number of standby redo logs is:
(maximum # of logfiles +1) * maximum # of threads
This example uses two online log files for each thread. Thus, the number of standby redo logs should be (2 + 1) * 2 = 6. That is, one more standby redo log file for each thread.
QL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 1
GROUP 5 SIZE 10M,
Creating a Single Instance Physical Standby for a RAC Primary Page 6
Maximum Availability Architecture
GROUP 6 SIZE 10M,
GROUP 7 SIZE 10M;
SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 2
GROUP 8 SIZE 10M,
GROUP 9 SIZE 10M,
GROUP 10 SIZE 10M;
ALTER DATABASE STOP LOGICAL STANDBY APPLY;
ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;
Recent Comments