C:\Users\anand>sqlplus sys/abcd as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Tue May 24 21:23:09 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt ions SQL> select * from all_users 2 / select * from all_users * ERROR at line 1: ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only SQL> shutdown immediate ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 1694498816 bytes Fixed Size 3046416 bytes Variable Size 1040188400 bytes Database Buffers 637534208 bytes Redo Buffers 13729792 bytes Database mounted. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open SQL> $rman target Argument Value Description ----------------------------------------------------------------------------- target quoted-string connect-string for target database catalog quoted-string connect-string for recovery catalog auxiliary quoted-string connect-string for auxiliary database nocatalog none if specified, then no recovery catalog cmdfile quoted-string name of input command file log quoted-string name of output message log file trace quoted-string name of output debugging message log file append none if specified, log is opened in append mode debug optional-args activate debugging msgno none show RMAN-nnnn prefix for all messages send quoted-string send a command to the media manager pipe string building block for pipe names script string name of catalog script to execute using list of args arguments for rman variables timeout integer number of seconds to wait for pipe input checksyntax none check the command file for syntax errors ----------------------------------------------------------------------------- Both single and double quotes (' or ") are accepted for a quoted-string. Quotes are not required unless the string contains embedded white-space. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00552: syntax error in command line arguments RMAN-01009: syntax error: found "end-of-file": expecting one of: "double-quoted- string, identifier, single-quoted-string, " RMAN-01007: at line 0 column 0 file: command line arguments SQL> alter database open resetlogs 2 / alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: 'C:\APP\ORACLE\ORADATA\ORCL\SYSTEM01.DBF' SQL> select * from all_users 2 / select * from all_users * ERROR at line 1: ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only