Database Reference
In-Depth Information
e xeRCiSe 5.1 (continued)
5. Exit SQL*Plus:
SQL> quit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 -
64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing
options
C:\oracle>
6. From the operating system prompt, delete all the database data files listed in step 3.
Be careful not to do a wildcard delete because you might delete files in that direc-
tory that you do not want to remove, such as the online redo logs or the database
control files
C:\oracle>Del C:\ORACLE\FAST_RECOVERY_AREA\ORCL\DATAFILE\O1_MF_
USERS_4G2Q1YTC_.DBF
C:\oracle>Del C:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF
C:\oracle>Del C:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF
C:\oracle>Del C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
7. Log into the database as SYS using SQL*Plus:
C:\oracle>sqlplus sys as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Fri Dec 27 10:20:57 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved. Enter password:
Enter password:
Connected to an idle instance.
8. Start the database. Notice the error that you receive:
SQL> startup
ORACLE instance started.
Total System Global Area 364081152 bytes
Fixed Size 1333228 bytes
Variable Size 264243220 bytes
Database Buffers 92274688 bytes
Redo Buffers 6230016 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF'
9. Shut down the database:
SQL> shutdown abort
ORACLE instance shut down.
Search WWH ::




Custom Search