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
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
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Yes you can goahead with your steps.

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

Current Time: Tue May 21 21:50:55 CDT 2024