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

MOSC Banner

Renaming datafile on primary database

edited Jun 24, 2014 5:00AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 4 commentsAnswered

Hi All,

I am renaming datafile on my primary database. By mistake it was created on the wrong mount point. when it was created on the wrong mount point the mrp process on standby  aborted as it was not able to create datafile on the secondary database.

We manually created datafile on secondary database with command alter database create datafile   XXX as YYY and restarted the recovery. Now on my primary database i want to move the datafile which was created wrongly to correct location. Standby_file_management is auto. The datafile on standby location is on correct location. Please let me know what are steps I need to perform.

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