You can have this one:
SQL> ALTER DATABASE OPEN READ ONLY;
And also this one:
SQL> ALTER DATABASE OPEN RESETLOGS;
But there's NO combined statement like this.
SQL> ALTER DATABASE OPEN READ ONLY RESETLOGS;
You cannot use the RESETLOGS clause with a READ ONLY clause. (Reference: Opening a Database in Read-Only Mode)
That is, you have to go there by three steps.
- Open the database with resetlogs
- Shutdown the database
- Starup the database to OPEN READ ONLY
SQL> ALTER DATABASE OPEN RESETLOGS;
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP OPEN READ ONLY;