|Physical Standby, using ASM (!?) [message #433096]
||Mon, 30 November 2009 01:05
Registered: January 2007
Location: Ha Noi, Viet Nam
I've configured a single Database 10g on RHEL 5, using ASM to store datafile. And I will continue configure Physical standby for it.
However, the primary used ASM, not file system. So that, I must use RMAN to backup full database and restore them into physical's server. Well, I describe those ways as following:
Step 1: Preparing.
# In primary
1. Configure pfile
2. Create standby log files
3. Backup database in mounted mode (include archive log file)
4. Create standby controlfile
# In standby.
1. Configure pfile which was copied from primary, create spfile from changed pfile
2. Log in Rman environment
2.1. Set new name for datafile
2.2. Rename logfile (not include standby log file)
2.3. Restore database
2.4. Recover database
Step 2: Open Primary and apply log file to standby
# In primary:
1. Open database
# In standby
1. Startup mount standby
2. Apply log file by statement.
These are the steps I plan, but, I think it's no expensive step (ASM spfile?, Do I use rman's above step truely?)