Tuesday, July 19, 2016

ORA-10458 ORA-01157 ORA-01111 ORA-01110


Error:-



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