My Oracle Notes

RMAN> report schema; using target database control file instead of recovery catalog Report of database schema for database with db_unique_name DB11G1 List of Permanent Datafiles =========================== File Size(MB) Tablespace           RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1    750      SYSTEM               ***     +DATA/db11g1/datafile/system.256.997039649 2    550      SYSAUX               ***     +DATA/db11g1/datafile/sysaux.257.997039651 3    65       UNDOTBS1             ***     +DATA/db11g...

Log to the database and shut it [oracle@db11g ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Feb 27 18:10:16 2019 Copyright (c) 1982, 2013, Oracle.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> select open_mode from v$database; OPEN_MODE -------------------- READ WRITE SQL> shut immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options Delete the datafile manually [oracle@db11g ~]$ exit logout [root@db11g ~]# su - grid [grid@db11g ~]$ . oraenv ORACLE_SID = [+ASM] ? The Oracle base remains unchanged with value /u01/app/grid [gri...

Create a test tablespace and user eg:-MAC SQL> show parameter db_n NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ db_name                              string      DB11G1 SQL> show parameter create NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ create_...