Posts

Showing posts from June, 2018

ERROR -- ISSUED

ERROR --1  SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled SOLUTIUON:: alter system set "_no_recovery_through_resetlogs"=TRUE scope=both; System altered. SQL>  shutdown immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 3206836224 bytes Fixed Size                  2232640 bytes Variable Size            1140854464 bytes Database Buffers         2046820352 bytes Redo Buffers               16928768 bytes Database mounted. SQL> alter database open resetlogs; Database altered. ERROR  IN CASE OF FULL DB RESTORATION ON  STANDBY WE ARE GETTING  RMAN RESTORE ends with ORA-01180: can not create datafile creating datafile fno=1 name=/u01/system01.dbf RMAN-00571: ===================================================