key software oracle olr cannot be opened.error 2

SQL> alter database recover managed standby database using archived logfile disconnect Database altered. SQL> select dest_id,status,database_mode,type,recovery_mode,error from v$archive_dest_status where dest_id=1 DEST_ID STATUS DATABASE_MODE TYPE RECOVERY_MODE ERROR - 1 VALID MOUNTED-STANDBY LOCAL IDLE SQL> select dest_id,status,error from v$archive_dest where status’INACTIVE’ DEST_ID STATUS ERROR - 1 VALID 32 VALID SQL> col value for a25 SQL> select name,value,datum_time,time_computed from v$dataguard_stats NAME VALUE DATUM_TIME TIME_COMPUTED - transport lag +00 00:41:00 01:46:25 01:46:39 apply lag 01:46:39 apply finish time 01:46:39 estimated startup time 12 01:46:39 SQL> select process,status,block#,blocks from v$managed_standby PROCESS STATUS BLOCK# BLOCKS - ARCH CONNECTED 0 0 ARCH CONNECTED 0 0 ARCH CONNECTED 0 0 ARCH CONNECTED 0 0 RFS IDLE 0 0 RFS IDLE 2805 1 RFS IDLE 0 0 RFS IDLE 0 0 8 rows selected. SQL> show parameter db_unique_name NAME TYPE VALUE - db_unique_name string stb1 SQL> select name,open_mode,database_role,protection_mode from v$database NAME OPEN_MODE DATABASE_ROLE PROTECTION_MODE - PROD1 READ ONLY PHYSICAL STANDBY MAXIMUM PERFORMANCE SQL> select member from v$logfile MEMBER - /u01/app/oracle/oradata/stand1/redo03.log /u01/app/oracle/oradata/stand1/redo02.log /u01/app/oracle/oradata/stand1/redo01.log You can see I have not added Standby logs till of now. SQL> select process,status,block#,blocks,delay_mins from v$managed_standby PROCESS STATUS BLOCK# BLOCKS DELAY_MINS - ARCH CONNECTED 0 0 0 ARCH CONNECTED 0 0 0 ARCH CONNECTED 0 0 0 ARCH CONNECTED 0 0 0

SQL> select open_mode from v$database OPEN_MODE - MOUNTED Total System Global Area 1610612736 bytes Fixed Size 2924928 bytes Variable Size 1040191104 bytes Database Buffers 553648128 bytes Redo Buffers 13848576 bytes Database mounted. SQL> startup mount ORACLE instance started. SQL> select dest_id,status,database_mode,type,recovery_mode,error from v$archive_dest_status where dest_id=2 DEST_ID STATUS DATABASE_MODE TYPE RECOVERY_MODE ERROR - 2 VALID MOUNTED-STANDBY PHYSICAL MANAGED Standby ~]$ sqlplus / as sysdba SQL> select dest_id,status,database_mode,type,recovery_mode,error from v$archive_dest_status where dest_id=1 DEST_ID STATUS DATABASE_MODE TYPE RECOVERY_MODE ERROR - 1 VALID OPEN LOCAL IDLE SQL> select dest_id,status,error from v$archive_dest where status’INACTIVE’ DEST_ID STATUS ERROR - 1 VALID 2 VALID Redo Apply Mode in Oracle 12c R2 Dataguard: Primary ~]$ sqlplus / as sysdba

Key software oracle olr cannot be opened.error 2