Home » Server Options » Data Guard » Physical Standby, using ASM (!?) (Oracle 10g, RHEL 5)
Physical Standby, using ASM (!?) [message #433096] Mon, 30 November 2009 01:05 Go to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Hi all!

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?)

Thank you!
Re: Physical Standby, using ASM (!?) [message #433354 is a reply to message #433096] Tue, 01 December 2009 16:06 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Yes you can goahead with your steps.

-Babu
Previous Topic: Delete the datafile from Standby
Next Topic: Configure multiple physical standby
Goto Forum:
  


Current Time: Fri Mar 29 00:38:40 CDT 2024