1. sysoper: This privilege allows a user to perform basic operational tasks, but without the ability to look at user data.
2. sysoper: ALTER DATABASE RECOVER
(Complete recovery only. Any form of incomplete recovery, such as UNTIL TIME|CHANGE|CANCEL|CONTROLFILE requires connecting as SYSDBA.)
3. SQL> conn / as sysoper
SQL> show user
USER is "PUBLIC"
SQL> conn / as sysdba
SQL> show user
USER is "SYS"