Database Reference
In-Depth Information
recovery situation is from a database backup that is consistent. Fortunately, RMAN will
force you to do consistent database backups when the database is in NOARCHIVELOG
mode, so this isn't a problem. We discussed this situation in detail in Chapter 2, “Performing
Oracle User-Managed Database Recoveries,” so please make sure you reference that chapter
and understand this important concept in backup and recovery. Oftentimes, knowing how
something works and why will help you answer an OCP exam question that you otherwise
don't really know the answer to.
So, how easy is recovery of your database in NOARCHIVELOG mode? Here are the
steps in summary form. We will give you more detail as this chapter progresses:
1. If you have lost your control file or spfile (or database parameter file), you will need
to reference the section on recovering your control file or spfile with RMAN, which
appears later in this chapter. To start any RMAN recovery, you must have a control
file and an spfile (or database parameter file).
2. If you are not already logged into RMAN (for example, if you had to restore your control
file), then log into RMAN now. You will see lots of examples of this later in this chapter.
3. Mount your database with the STARTUP MOUNT command.
4. Issue the RMAN RESTORE DATABASE command.
5. Issue the RMAN RECOVER DATABASE command. Because this is a NOARCHIVELOG-
mode database recovery, you will need to include the NOREDO keyword to indicate that
there is no redo to be applied.
6. Open the database with the ALTER DATABASE OPEN command.
Here is an example of an RMAN restore of a database in NOARCHIVELOG mode:
RMAN> connect target /
RMAN> shutdown abort
using target database control file instead of recovery catalog
Oracle instance shut down
RMAN> startup mount
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area 397557760 bytes
Fixed Size 1333452 bytes
Variable Size 339740468 bytes
Database Buffers 50331648 bytes
Redo Buffers 6152192 bytes
RMAN> restore database;
Starting restore at 28-SEP-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=154 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
Search WWH ::




Custom Search