Thanks for your prompt reply.
This solution was tried before posting this thread but at that time I executed command in container database and it didn't work.
But when I executed same command in pluggable database in which datafile#87 was created, it works for me.
For them who are facing or will face the same issue in multitenant architecture :
Identify pluggable database of missing datafile and implement the suggested solution in particular pdb only.
Thank you again.
Thanks for this new link. I have followed same steps yesterday.
But now getting one more issue in dataguard setup regarding standby file management parameter.
I have changed this parameter to AUTO in both primary and standby database using below command and switched over database using dgmgrl.
SQL> alter system set standby_file_management=auto scope=both sid='*';
When I checked the value after switchover, it was changed to MANUAL.
Please provide your expert comment on this behaviour.
Thanks in advance.
Any chance you are using Data Guard Broker? If yes changing with SQL could lead to inconsistent property values
List of initialization parameters that the broker is supposed to control:
In broker the "show configuration" should throw a Warning: ORA-16792 if you have this issue.
yes I am using DG broker. And After changing those parameter I was getting error regarding inconsistent value in DG broker. But after executing disable configuration and enable configuration, it was cleared from show configuration output.
Then I switched over to DR database and when I check the standby file management parameter value again, it was manual.
Thanks and Regards,
"And After changing those parameter I was getting error regarding inconsistent value in DG broker"
Expected. What I was trying to say in my last post was don't mix SQL and Broker for those parameters.
You can check with:
show database 'Your_database' 'InconsistentProperties'
Reset the properties you find to make them consistent with the database settings. After that don't mix SQL with broker to avoid this issue.
Thank you for your nice explanation.
But I had also tried to EDIT dataguard broker propery using "EDIT INSTANCE * ..." command but also getting some errors that cant update property value.
So finally I removed the configuration of DG broker, changed value of Standby_File_Management in all four instances.
Then again created same configuration and cross checked the value of the parameter. This approach worked for me and now after switchover also the behavior is as expected.
Thanks again to all for your support.