Performing Oracle User-Managed Database Recoveries - OCP: Oracle Database 12c Administrator Certified Professional - page 69

exeRCiSe 2.2 (continued)
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-01075: you are currently logged on
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@localhost trace]$ ps -ef|grep orcl|grep lgwr
oracle 23118 1 0 15:48 ? 00:00:01 ora_lgwr_orcl
[oracle@localhost trace]$ kill -9 23118
5. Once you are sure the database is down, restore the database data files from their
backup location to the location where the database files belong.
[oracle@localhost orcl]$ pwd
/oracle01/backup/orcl
[oracle@localhost orcl]$ cp *.dbf /oracle01/oradata/orcl/*
6. Now connect to the database and issue the STARTUP MOUNT command.
[oracle@localhost orcl]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Tue Feb 18 12:24:53 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing
options
SQL> startup mount
ORACLE instance started.
Total System Global Area 167395328 bytes
Fixed Size 1298612 bytes
Variable Size 142610252 bytes
Database Buffers 20971520 bytes
Redo Buffers 2514944 bytes
Database mounted.
SQL>