Database Reference
In-Depth Information
channel ORA_DISK_1: restoring datafile 00002 to
C:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF
channel ORA_DISK_1: reading from backup piece
C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_09_22
\O1_MF_NNNDF_TAG20130922T182631_4FJFXXVT_.BKP
channel ORA_DISK_1: piece
handle=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_09_22
\O1_MF_NNNDF_TAG20130922T182631_4FJFXXVT_.BKP tag=TAG20130922T182631
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:25
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
C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
channel ORA_DISK_1: restoring datafile 00004 to
C:\ORACLE\ORADATA\ORCL\USERS01.DBF
channel ORA_DISK_1: restoring datafile 00005 to
C:\ORACLE\ORADATA\ORCL\UNDOTBS02.DBF
channel ORA_DISK_1: reading from backup piece
C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_09_28\
O1_MF_NNNDF_TAG20130928T165801_4G02ZZC7_.BKP
channel ORA_DISK_1: piece
handle=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_09_28
\O1_MF_NNNDF_TAG20130928T165801_4G02ZZC7_.BKP tag=TAG20130928T165801
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:55
Finished restore at 28-SEP-13
RMAN> recover database noredo;
Starting recover at 28-SEP-13
using channel ORA_DISK_1
Finished recover at 28-SEP-13
RMAN> alter database open;
database opened
Recovering a Database in
ARCHIVELOG Mode
If your database is in ARCHIVELOG mode, then your recovery options might include a
complete database recovery or an online data file or tablespace recovery. Another option
is point-in-time recovery, which we discuss later in this chapter. Other, more advanced
Search WWH ::




Custom Search