Database Reference
In-Depth Information
exeRCiSe 6.2
(continued)
1253 Full 187.77M DISK 00:00:00 18-OCT-13
BP Key: 1261 Status: AVAILABLE Compressed: YES
Tag: TAG20131018T152908
Piece Name: C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_10_18
\O1_MF_NNNDF_TAG20131018T152908_4HNO9DX9_.BKP.OLD
List of Datafiles in backup set 1253
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1222465 18-OCT-13 C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
2 Full 1222465 18-OCT-13 C:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF
3 Full 1222465 18-OCT-13 C:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF
4 Full 1222465 18-OCT-13 C:\ORACLE\ORADATA\ORCL\USERS01.DBF
5 Full 1222465 18-OCT-13 C:\ORACLE\ORADATA\ORCL\MY_DATA_01.DBF
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1342 Full 187.87M DISK 00:56:47 18-OCT-13
BP Key: 1348 Status: AVAILABLE Compressed: YES
Tag: TAG20131018T163034
Piece Name: C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_10_18
\O1_MF_NNNDF_TAG20131018T163034_4HNRWKVC_.BKP
List of Datafiles in backup set 1342
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1224452 18-OCT-13 C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
2 Full 1224452 18-OCT-13 C:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF
3 Full 1224452 18-OCT-13 C:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF
4 Full 1224452 18-OCT-13 C:\ORACLE\ORADATA\ORCL\USERS01.DBF
5 Full 1224452 18-OCT-13 C:\ORACLE\ORADATA\ORCL\MY_DATA_01.DBF
4.
Next, simulate the loss of a backup set piece by using the
HOST
command and delet-
ing the backup set piece.
In this case, you will remove the backup set piece called
O1_MF_NNNDF_
TAG20131018T163034_4HNRWKVC_.BKP
, which showed up in the report in step 3. Your
backup set piece will probably be named differently.
RMAN> Host 'del C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_10_18
\O1_MF_NNNDF_TAG20131018T163034_4HNRWKVC_.BKP';
Search WWH ::
Custom Search