DataFile Movement in Physical Standby Database
edited Apr 9, 2013 6:02AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 4 commentsAnswered
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;
0