??????????????????????????????????????????ο????μ?????????????
????How to resolve MRP stuck issues on a physical standby database? (??? ID 1221163.1)
????......
????Solution 10 Add the new datafiles to the standby database manually.
????1) Please take a hot backup of new datafiles from the primary database.
????2) Create a new standby controlfile from the primary database by
????SQL>alter database create standby controlfile as '/tmp/controlf.ctl';
????If datafiles are on ASM?? please follow the note below and you could ignore the rest of steps:
????Note 734862.1 Step By Step Guide On How To Recreate Standby Control File
????When Datafiles Are On ASM And Using Oracle Managed Files
????Or you could modify the wrong datafile name in the standby controlfile by alter database rename command. For example??
????SQL> ALTER DATABASE RENAME FILE '<path/UNNAMED00003>' to '<path/real datafile name>';
????3) If the new datafile location on the primary is different from the standby?? please make sure
????db_file_name_convert init parameter is set on the standby database.
????Note 47325.1 Init.ora Parameter "DB_FILE_NAME_CONVERT" Reference Note
????If db_file_name_convert init parameter has already been set?? then you could ignore this step.
????4) Cancel the managed recovery
????SQL>alter database recover managed standby database cancel;
????5) set standby_file_management=manual on the standby database and shutdown the standby database.
????SQL>alter system set standby_file_management=manual sid='*';
????SQL>shutdown immediate;
????6) Copy the hot backup of the new datafiles and the new standby controlfile to the standby.
????Please make sure the controlfiles are located in the right location with right names
????according to the init parameter control_files. Please make sure the copied datafiles are
????located in the right location as well according to name from v$datafile.
????7) startup the standby database in mount mode and set standby_file_management=auto.
????SQL>startup mount;
????SQL>alter system set standby_file_management=auto sid='*';
????8) Start the managed recovery.
????SQL>alter database recover managed standby database disconnect;
????......
????--end--