Solution:-
1)change standby_file_management to manual in standby
database.
2) alter database create datafile '/u01/app/oracle/product/12.1.0/dbhome_2/dbs/UNNAMED00002' as '/u01/app/oracle/oradata/stddb/test01.dbf';
3)Before create file , V$asm_header will be empty for that file id and it will show the file name perfectly after created the file.
4) alter database recover managed standby database disconnect from session;
5) alter system set standby_file_management='AUTO' in
standby database
No comments:
Post a Comment