s p compustat database

Environment of this article: Oracle databae 12.1.0.2, rhel5.9 x86-64bit[[emailprotected] orcl]$ pwd/u01/app/oracle/oradata/orcl[[emailprotected] orcl]$ ls-lrttotal 2386544drwxr-x---2 oracle oinstall 4096 Dec pdbseeddrwxr-x---2 oracle oinstall 4096 Dec pn1d Rwxr-x---2 oracle oinstall 4096 DEC pn2-rw-r-----1 Oracle oinstall 5251072 Jul 13:26 users01.dbf-rw-r -----1 Oracle Oinstall 52429312 13:26 redo03.log-rw-r-----1 Oracle oinstall 52429312 Jul 13:26 r

1. Enter the sqlplus in the cmd command:The corresponding DOS commands are executed:(1) Set oracle_sid = $INSTANCE _name(2) Sqlplus/nolog(3) Connect User/password as Sysdba(4) Startup/shutdown2. ORA-01113 file requires media recovery solutionConn/as SYSDBAStartup MountRecover datafile "/oradata/...";Example: Recover DataFile ' E:\APP\ADMINISTRATOR\ORADATA\ORCL\sysaux01. DBF 'Alter DATABAE Open;3. View the SQL for which the user has permissions:SELECT