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

MOSC Banner

DataFile Movement in Physical Standby Database


Dear Experts, 

   I have a production database that has a physical standby database. Due to some space constraints, I am planning to move some database Files from one Drive to another. I am planning to follow the below procedure to achieve this one. 

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> SHU IMMEDIATE
SQL> ALTER DATABASE MOUNT STANDBY DATABASE;
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT = 'MANUAL' SCOPE=MEMORY;
Copy the intended database File to the desired location.
SQL> ALTER DATABASE RENAME FILE '' TO '';
SQL> ALTER SYSTEM STANDBY_FILE_MANAGEMENT = 'AUTO' SCOPE=MEMORY;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center