[oracle@oracle01 ~]$
[oracle@oracle01 ~]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Jul 13 10:25:19 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORA11GR2 (DBID=297877687)
RMAN> backup database;
Starting backup at 2018-07-13 10:25:28
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=38 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/ora11gr2/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/ora11gr2/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/ora11gr2/example01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/ora11gr2/undotbs01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ora11gr2/users01.dbf
channel ORA_DISK_1: starting piece 1 at 2018-07-13 10:25:28
channel ORA_DISK_1: finished piece 1 at 2018-07-13 10:26:15
piece handle=/u01/app/oracle/fast_recovery_area/ORA11GR2/backupset/2018_07_13/o1_mf_nnndf_TAG20180713T102528_fnj3dsn6_.bkp tag=TAG20180713T102528 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:47
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 2018-07-13 10:26:16
channel ORA_DISK_1: finished piece 1 at 2018-07-13 10:26:17
piece handle=/u01/app/oracle/fast_recovery_area/ORA11GR2/backupset/2018_07_13/o1_mf_ncsnf_TAG20180713T102528_fnj3g8bv_.bkp tag=TAG20180713T102528 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2018-07-13 10:26:17
RMAN> quit
Recovery Manager complete.
[oracle@oracle01 ~]$ cd /u01/app/oracle/oradata/ora11gr2/
[oracle@oracle01 ora11gr2]$ rm -rf system01.dbf
[oracle@oracle01 ora11gr2]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Jul 13 10:27:13 2018
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, OLAP, Data Mining and Real Application Testing options
SQL> shutdow abort;
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size 2253784 bytes
Variable Size 1006636072 bytes
Database Buffers 637534208 bytes
Redo Buffers 7094272 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/u01/app/oracle/oradata/ora11gr2/system01.dbf'
SQL> startup mount;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shut immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size 2253784 bytes
Variable Size 1006636072 bytes
Database Buffers 637534208 bytes
Redo Buffers 7094272 bytes
Database mounted.
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@oracle01 ora11gr2]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Jul 13 10:28:24 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORA11GR2 (DBID=297877687, not open)
RMAN> restore database;
Starting restore at 2018-07-13 10:28:41
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/ora11gr2/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/ora11gr2/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/ora11gr2/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/ora11gr2/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/ora11gr2/example01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/ORA11GR2/backupset/2018_07_13/o1_mf_nnndf_TAG20180713T102528_fnj3dsn6_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/ORA11GR2/backupset/2018_07_13/o1_mf_nnndf_TAG20180713T102528_fnj3dsn6_.bkp tag=TAG20180713T102528
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:45
Finished restore at 2018-07-13 10:29:28
RMAN> recover database;
Starting recover at 2018-07-13 10:29:38
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:01
Finished recover at 2018-07-13 10:29:39
RMAN> quit
Recovery Manager complete.
[oracle@oracle01 ora11gr2]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Jul 13 10:29:53 2018
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, OLAP, Data Mining and Real Application Testing options
SQL> alter database open;
