Create Physical stdby Using RMAN Duplicate In ASM File... For ASM Prim-837102.1
Step By Step Guide On Creating Physical Standby Using RMAN Duplicate In ASM Filesystem For ASM Primary [ID 837102.1]
In this Document
Goal |
Solution |
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review. |
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.0 [Release 10.2 to 11.2]Information in this document applies to any platform.
***Checked for relevance on 17-May-2013***
Goal
This document offers step by step procedure to create ASM physical standby
from ASM primary.
Solution
Pre-Requisite
a)
Database (PRIMARY) is up and running and the datafiles, controlfiles residing in
ASM.
b) ASM instance and diskgroups configured in STANDBY server.
c)
Network connectivity between PRIMARY and STANDBY server
PROCEDURE
1.Enable
force logging in PRIMARY.
2.Create SRL(standby redo logs) in PRIMARY.
3.Backup the PRIMARY database.
4.Make proper changes in the parameter
file of PRIMARY.
5.Create the parameter file for STANDBY
6.Copy the
files (RMAN Backup, init.ora) to STANDBY
7.Establish the connectivity between
PRIMARY and STANDBY.
8.Start the STANDBY instance and use RMAN duplicate to
create standby database
9. Create SRL on standby.
10.Start the MRP
process,
11. Verify whether the log are shipped and applied properly @the
standby
Consider two databases of names PRIMARY= PRIMA and STANDBY=
MYSTD
1. Enable Forced Logging on PRIMARY
SQL> ALTER DATABASE FORCE LOGGING;
2. Configure Standby Redo
Log on PRIMARY
a. Check the log files and sizes,
SQL>SELECT GROUP#,BYTES FROM
V$LOG;
b. Create SRL
ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 SIZE
100M;
c. Verify the standby redo log file groups were created(do this after the
creation of stanby database)
SQL> SELECT
GROUP#,THREAD#,SEQUENCE#,ARCHIVED,STATUS FROM V$STANDBY_LOG;
3. Use
RMAN to backup PRIMARY database with archivelog
& controlfile.
RMAN>backup database format '/tmp/dbbkp/PRIMA_%U';
RMAN>backup archivelog all format '/tmp/dbbkp/PRIMA_ARC_%U';
RMAN>
backup current controlfile for standby format '/tmp/dbbkp/PRIMA_CONTROL.bkp';
4. Make the necessary changes to PRIMARY .
DB_NAME=pri
DB_UNIQUE_NAME=pri
LOG_ARCHIVE_CONFIG='DG_CONFIG=(PRIMA,MYSTD)'
LOG_ARCHIVE_DEST_2= 'SERVICE=stdby LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=MYSTD'
LOG_ARCHIVE_DEST_STATE_2=DEFER
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30
FAL_SERVER=MYSTD
FAL_CLIENT=PRIMA
DB_FILE_NAME_CONVERT='MYSTD','PRIMA'
LOG_FILE_NAME_CONVERT='MYSTD','PRIMA'
STANDBY_FILE_MANAGEMENT=AUTO
5. Create the parameter file for standby,
a. CREATE
PFILE='
b. Make the
necessary changes, for example,
DB_NAME=PRIMA
DB_UNIQUE_NAME=MYSTD
LOG_ARCHIVE_CONFIG='DG_CONFIG=(PRIMA,MYSTD)'
CONTROL_FILES='+DATA','+FRA'
DB_FILE_NAME_CONVERT='PRIMA','MYSTD'
LOG_FILE_NAME_CONVERT='PRIMA','MYSTD'
LOG_ARCHIVE_FORMAT=log%t_%s_%r.arc
LOG_ARCHIVE_DEST_2= 'SERVICE=PRIMA LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRIMA'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
STANDBY_FILE_MANAGEMENT=AUTO
FAL_SERVER=PRIMA
FAL_CLIENT=MYSTD
6. Copy the files (RMAN Backup, init.ora) to STANDBY
a) Copy the RMAN backup files created in /tmp/dbbkp (step3) to STANDBY in
identical location
Example:
scp /tmp/dbbkp/* oracle@core1:/tmp/dbbkp/*
b)
Copy the init.ora (step 5) to STANDBY
c) Recreate the password file in
standby using orapwd utility
7. Establish the connectivity between
primary and standby.
In PRIMARY (TNSNAMES.ORA)
MYSTD=
(DESCRIPTION =
(ADDRESS = (PROTOCOL =
TCP)(HOST = 192.9.200.108)(PORT = 1521))
(CONNECT_DATA =
(SERVER =
DEDICATED)
(SERVICE_NAME = MYSTD.server.com)
)
)
In
STANDBY (TNSNAMES.ORA)
PRIMA=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.9.200.107)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =
PRIMA.server.com)
)
)
8. Start the STANDBY instance and use RMAN duplicate to
create standby database
NOTE: Make sure the ASM instance also running.
$export ORACLE_SID=MYSTD
SQL>create spfile from pfile=’
SQL>startup nomount
$RMAN target sys/
RMAN> RUN {
allocate auxiliary channel C1 device
type disk;
duplicate target database for standby;
}
9. Create SRL(Standby Redo logs) on standby,
For Example,
ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 SIZE
100M;
10. Start the MRP process in PRIMARY
In
PRIMARY
SQL>ALTER SYSTEM SET
LOG_ARCHIVE_DEST_STATE_2=ENABLE;
In
STANDBY
SQL>ALTER DATABASE RECOVER MANAGED STANDBY
DATABASE DISCONNECT FROM SESSION;
11. Verify whether the log are shipped
and applied properly in the standby
a. execute on PRIMARY
database
SQL> ALTER SYSTEM SWITCH LOGFILE;
b.
execute on STANDBY database
SQL> SELECT SEQUENCE#,
FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
c. Issue
more log switches at PRIMARY
SQL> ALTER SYSTEM SWITCH
LOGFILE;
d. Verify the new redo data was archived on the standby
database.On the standby database, query the V$ARCHIVED_LOG view to verify the
redo data was received and archived on the standby database:
SQL>
SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
NOTE: Verify new archived redo log files were applied. At the standby
database, query the V$ARCHIVED_LOG view to verify the archived redo log files
were applied.
SQL> SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER
BY SEQUENCE#;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-764883/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Step By Step Guide On Creating Physical Standby Using RMAN Duplicate In ASM Filesystem For ASM PrimaGUIIDEASM
- Duplicate Database from ASM to Non- ASM Database Using RMANDatabaseASM
- Step-By-Step Guide To Create Physical Standby On Normal File System For ASM Primary using RMANGUIIDEORMASM
- RMAN Duplicate Database From RAC ASM To RAC ASM [ID 461479.1]DatabaseASM
- Recreate stdby Control File When dbf Are On ASM And Using OMF-734862.1ASM
- Creating a Physical Standby using RMAN DUPLICATE FROM ACTIVE DATABASEDatabase
- Migrating to ASM Using RMAN(二)ASM
- Migrating to ASM Using RMAN(一)ASM
- Unable To Create Database Using ASM ORA-15055DatabaseASM
- Step By Step Guide To Create Physical Standby Database Using RMAN [ID 469493.1]GUIIDEDatabase
- How to copy a datafile from ASM to a file system not using RMANASM
- Performing duplicate database with ASM/OMF/RMAN (Doc ID 340848.1)ORMDatabaseASM
- FROM ASM Migrating to FILE SYSTEM Using RMAN(三)ASM
- Creating Physical Standby using RMAN Duplicate Without Shutting Primary_789370.1
- rman copy asm datafile(rename asm datafile)ASM
- Creating Physical Standby using RMAN Duplicate Without Shutting down The Primary [ID 789370.1]
- Duplicate database from non ASM to ASM to a different host [ID 382669.1]DatabaseASM
- ORA-15183 Unable to Create Database on Server using 11.2 ASMDatabaseServerASM
- How to re-create the ASMASM
- Configure Oracle Dataguard Primary-ASM to Physical-ASM薦OracleASM
- Step by Step Guide on Creating Physical Standby Using RMAN DUPLICATE...FROM ACTIVE DATABASE WithoutGUIIDEDatabase
- Using FTP Transferring Non-ASM Datafiles to ASM diskgroupFTPASM
- 【RMAN】RMAN備份至ASMASM
- 利用RMAN將非ASM檔案移動到ASM裡 - [ASM]ASM
- 單例項的duplicate(non ASM)單例ASM
- DUPLICATE (Backup based) DATABASE from non ASM to ASM to different host_382669.1DatabaseASM
- Creating a physical standby from ASM primaryASM
- Duplicate database from non ASM to ASM (vise versa) to a different host-382669.1DatabaseASM
- Duplicating Database using RMAN duplicate commandDatabase
- Using ASMLIB Management ASM DiskASM
- ASM using ASMLib and Raw DevicesASMdev
- Can you create a second voting disk in a different ASM diskgroup when using External Redundancy in 1ASM
- Create a Seco VD in a Diffe ASM Disk G When Using Exter Redun in 11.2_950730.1ASM
- Using SQL Script Get Information about ASMSQLORMASM
- Steps to Re-Create ASM Diskgroups(重建asm 磁碟組步驟)ASM
- Using RMAN Incremental Backups to Roll Forward a Physical Standby DatabaseREMForwardDatabase
- 用RMAN遷移檔案到ASM或從ASM遷出ASM
- ORA-15183 Unable to Create DB on Server using 11.2 ASM and GI_1054033.1ServerASM