Hi all,
Due to space issues, i need to migrate few datafiles to different mount poihnts in the physical standby database.
The physical standby database is inmount state and recieving redo.
The migration process invloves the following step:
1)taking datafile offline
2)cp to new location
3)Rename them for new location
4)takle the datafile online
How should i follow these steps for physical standby database?
The docs says:
8.3.6 Taking Datafiles in the Standby Database Offline
You can take standby database datafiles offline as a means to support a subset of your primary database's datafiles. For example, to skip recovery of datafiles that were not copied to the standby database, take the missing datafiles offline using the following statement on the standby database:
SQL> ALTER DATABASE DATAFILE 'MISSING00004' OFFLINE DROP;
If you execute this statement, then you must drop the tablespace containing the offline files after opening the standby database.
I might also need to edit DB_FILE_NAME_CONVERT parameter.Can i pass multiple locations for the datafiles in standby database?
Thanks