Oracle Standby database with Oracle 11G Standard Edittion

STEP I- Createing password file for auxiliary server.
Just copy target orapwd file to standby server $ORACLE_HOME/dbs/orapwATLASDEVSB.
STEP II- Configuring network files (listener.ora and tnsnames.ora) to create connectivity between two servers.
Standby database listener
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ATLASDEV)
(ORACLE_HOME = /opt/db/oracle/home/o10oracle/app/oracle/product/11.2.0.2/db_1)
(SID_NAME = ATLASDEVSB)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oratest)(PORT = 1549))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1549))
)
)



STANDBY DATABASE TNSNAMES.ORA
# tnsnames.ora Network Configuration File: /opt/db/oracle/home/o10oracle/app/oracle/product/11.2.0.2/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ATLASDEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oradev)(PORT = 1525))
)
(CONNECT_DATA =
(SERVICE_NAME = ATLASDEV)
)
)
TARGET DATABASE TNSNAMES.ORA
ATLASDEVSB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oratest)(PORT = 1549))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ATLASDEV)
)
)

STEP III- Creating parameter file for standby instance
*.audit_file_dest='/opt/db/oracle/admin/ATLASDEV/adump'
*.audit_trail='DB'
*.compatible='11.2.0.0.0'
*.control_files='/opt/db/oracle/vol1/ATLASDEV/controlfile/o1_mf_6zn59m4c_.ctl','/opt/db/oracle/vol2/ATLASDEV/controlfile/o1_mf_6zn59m6l_.ctl'
*.db_block_size=8192
*.db_create_file_dest='/opt/db/oracle/vol1/'
*.db_name='ATLASDEV'
*.db_recovery_file_dest='/opt/db/oracle/vol3/fast_recovery_area/'
*.db_recovery_file_dest_size=10G
*.memory_target=1073741824

STEP IV- Creating necessary directories for the standby database files.
Create adump dpdump pfile directories under /opt/db/oracle/admin/ATLASDEV/adump'
Create controlfile datafile onlinelog directories under /opt/db/oracle/vol1/ATLASDEV/.
STEP V- Taking backup of primary database and copy it to the auxiliary server.
Rman>backup current controlfile for standby format ‘/fullpath/standby_control_%U’;
Rman> backup database plus archivelog;
Rman> backup archivelog all;
Sqlplus > select max(sequence#) from v$archived_log;
STEP VI- Startup the auxiliary instance in NOMOUNT mode.
Sqlplus / as sysdba
Sqlplus > Create spfile from pfile=’/fullpath/initATLASDEVSB.ORA’ .
SQLPLUS> STARTUP NOMOUNT;
STEP VII- Running DUPLICATE DATABASE command in the primary database.
Rman target sys/password@atlasdev auxiliary /
Run{
Set until sequence (max seq#);
Duplicate target database for standby dorecover nofilenamecheck;
}
STEP VIII- After successful recovery do following.
Sqlplus / as sysdba
Recover standby database;
AUTO.
ALTER DATABASE OPEN READ ONLY;
If datafile is added on primary database it can be recover using following commands.
• On the standby database, set STANDBY_FILE_MANAGEMENT to AUTO and restart Redo Apply:
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO;
SQL> RECOVER MANAGED STANDBY DATABASE DISCONNECT;
Ref: http://docs.oracle.com/cd/B28359_01/server.111/b28294/manage_ps.htm

Views: 19

Comment

You need to be a member of OracleConnections to add comments!

Join OracleConnections

Oracle Jobs in US

© 2024   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service