I restore the database from a rman cold backup. I am getting the below error while starting the database.
SQL> alter database open;
alter database open
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
Is it needed to start the database in resetlog mode after rman cold backup restore.
Yes. RMAN does not backup the online redo log files. In order to open the database, the redo log files need to be created using the RESETLOGS option. Alternatively, you can use the OS to perform a backup of all files while the OS is shutdown, including the redo log files.