Showing posts with label DataGuard. Show all posts
Showing posts with label DataGuard. Show all posts

Friday, March 9, 2012

CREATING A PHYSICAL STANDBY ON ASM 11gR2

Task 1: Gather Files and Perform Back Up
1. On the primary node, create a staging directory. For example:
[testasm] /home/oracle >mkdir -p /u02/stage
2. Create the same exact path on one of the standby hosts: [testdb] /home/oracle >mkdir -p /u02/stage
3. On the primary node, connect to the primary database and create a PFILE from the
SPFILE in the staging directory. For example:
SQL> create pfile='/u02/stage/inittestasm.ora' from spfile;
File created.
SQL>