RMAN Incomplete Recovery
15
Copyright © Oracle Corporation, 2002. All rights reserved.
Objectives
After completing this lesson, you should be able to do the following: • Perform an incomplete database recovery by using
UNTIL TIME
• Perform an incomplete database recovery by using
UNTIL SEQUENCE
15-2 Copyright © Oracle Corporation, 2002. All rights reserved.
Incomplete Recovery of a Database Using RMAN
1. Mount the database. 2. Allocate multiple channels for parallelization. 3. Restore all datafiles. 4. Recover the database by using UNTIL TIME, UNTIL
SEQUENCE, or UNTIL SCN.
5. Open the database by using RESETLOGS. 6. Perform a whole database backup.
15-3 Copyright © Oracle Corporation, 2002. All rights reserved.
Specifying the Restore Time
15-4 Copyright © Oracle Corporation, 2002. All rights reserved.
RMAN Incomplete Recovery UNTIL TIME: Example
RMAN> RUN {
2> ALLOCATE CHANNEL c1 TYPE DISK;
3> ALLOCATE CHANNEL c2 TYPE DISK;
4> SET UNTIL TIME = ‘2001-12-09:11:44:00'; 5> RESTORE DATABASE;
6> RECOVER DATABASE; 7> ALTER DATABASE OPEN RESETLOGS; }
15-5 Copyright © Oracle Corporation, 2002. All rights reserved.
15-6 Copyright © Oracle Corporation, 2002. All rights reserved.
Specifying the Sequence
15-7 Copyright © Oracle Corporation, 2002. All rights reserved.
RMAN Incomplete Recovery UNTIL SEQUENCE: Example
RMAN> RUN {
2> SET UNTIL SEQUENCE 120 THREAD 1;
3> ALTER DATABASE MOUNT; 4> RESTORE DATABASE;
5> RECOVER DATABASE; # recovers through log 119
6> ALTER DATABASE OPEN RESESTLOGS;
7> }
15-8 Copyright © Oracle Corporation, 2002. All rights reserved.
Summary
In this lesson, you should have learned how to: • Perform an incomplete database recovery by using
UNTIL TIME
• Perform an incomplete database recovery by using
UNTIL SEQUENCE
15-9 Copyright © Oracle Corporation, 2002. All rights reserved.
Practice 15 Overview
This practice covers recovery with lost archived redo log files.
15-10 Copyright © Oracle Corporation, 2002. All rights reserved.
15-11 Copyright © Oracle Corporation, 2002. All rights reserved.
15-12 Copyright © Oracle Corporation, 2002. All rights reserved.
