ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
Problem Description:
SQL> startup ORACLE instance started. Total System Global Area 1644167168 bytes Fixed Size 2925024 bytes Variable Size 1056968224 bytes Database Buffers 570425344 bytes Redo Buffers 13848576 bytes Database mounted. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open Solution: Step-1: Execute the following command
SQL> shutdown abort; SQL> startup mount; SQL> $ rman target / RMAN> recover database; SQL> quit; SQL> alter database open resetlogs; SQL> $ rman target / RMAN> reset database; Step-2:
SQL> startup ORACLE instance started. Total System Global Area 1644167168 bytes Fixed Size 2925024 bytes Variable Size 1056968224 bytes Database Buffers 570425344 bytes Redo Buffers 13848576 bytes Database mounted. Database opened. SQL>
Comments