RMAN Backup and Recovery in NOARCHIVELOG Mode

It’ highly recommended to turn Archivelog mode in production.

Database in noarchivelog mode can NOT be made with HOT backups.

It can be backed up using OS commands when the database is closed; or using RMAN while database is in MOUNT mode.

Rman backup in Noarchivelog mode


-- turn on autobackup

<span style="font-size: small;">RMAN> configure controfile autobackup on</span>

$>shutdown immediate;

$>startup mount;

$>rman target / catalog rcat/ract@rcat

RMAN> backup database including current controlfile;

Rman recovery in Noarchivelog mode

if control file is available but datafiles are corrupted


shutdown immediate; (or shutdown abort)

startup mount;

rman target / catalog rcat/rcat@rcat

RMAN> restore database;

RMAN> recover database noredo;

RMAN> alter database open resetlogs;

if control file and data files are all lost


startup nomount

RMAN> set dbid <dbid>

RMAN> restore controfile from autobackup;

RMAN> alter database mount;

RMAN> restore database;

RMAN>recover database noredo;

RMAN> alter database open resetlogs;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: