Showing posts with label ORA-01111 and ORA-01110 and ORA-01157 in physical standby.. Show all posts
Showing posts with label ORA-01111 and ORA-01110 and ORA-01157 in physical standby.. Show all posts

Tuesday, June 10, 2014

If standby_file_management set to manual

if standby_file_management set to manual and file got created on prod and not in DR then it will fail with below  error:
Errors in file /orabin/oracle/admin/ABCPRD/diag/diag/rdbms/abcprd_drabcdbstd03/ABCPRD/trace/ABCPRD_mrp0_21744.trc:
ORA-01111: name for data file 11 is unknown - rename to correct file
ORA-01110: data file 11: '/orabin/oracle/product/11g/dbs/UNNAMED00011'
ORA-01157: cannot identify/lock data file 11 - see DBWR trace file
ORA-01111: name for data file 11 is unknown - rename to correct file
ORA-01110: data file 11: '/orabin/oracle/product/11g/dbs/UNNAMED00011'

To fix this kind of issue:

SQL> alter database create datafile '/orabin/oracle/product/11g/dbs/UNNAMED00011' as '/oradata/ABCPRD/sysaux05.dbf';

Database altered.

SQL> alter database mount standby database;

SQL>
SQL> alter database recover managed standby database disconnect from session;

Database altered.

SQL> !ps -ef |grep mrp
oracle   22988     1  4 18:50 ?        00:00:00 ora_mrp0_ABCPRD
oracle   23012 22894  0 18:50 pts/3    00:00:00 /bin/bash -c ps -ef |grep mrp
oracle   23014 23012  0 18:50 pts/3    00:00:00 grep mrp

Convert snapshot standby database to Physical standby database: Dataguard 11gR2

Step 1 SQL> shutdown immediate; Step 2 SQL> startup nomount Step 3 SQL> alter database mount; Step 4 SQL>  ALTER DATABASE CONV...