High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

ASM Standby with Multiple Data Disk Groups: How to Get Data Files to Right Group?

edited Sep 28, 2015 4:51AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 4 commentsAnswered ✓

Hi

This is RAC 12.1.0.2 on Oracle Linux 6.  The primary and the standby clusters have two ASM data disk groups, and one for FRA.  The names of the disk groups are +DATA_ASM and +CCE_ETL_DATA.  I used the same names on the standby cluster.  The primary database creates data files in either of the data disk groups as needed.  This is the first standby I've added where there are two data disk groups.

On the standby database, standby_file_management=AUTO.  On both primary and standby, db_create_file_dest=+DATA_ASM. 

Today I added a new tablespace to the primary with its data file in +CCE_ETL_DATA.  Unfortunately, the standby database added the same data file to +DATA_ASM.    This is the DDL I used to add the tablespace and data file in the primary:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center