Database Backup and Recovery (MOSC)

MOSC Banner

Database cold backup using RMAN is consistent or inconsistent backup ?

edited May 5, 2010 1:49AM in Database Backup and Recovery (MOSC) 8 commentsAnswered ✓
 DB ver: 11.1.0.6 (Noachivelog mode)

I am taking database cold backup (including controlfile autobackup) using RMAN. Following are the rman commands I am using for backup and restore:

Backup:
--------
rman>startup mount;
run {
allocate channel t1 device type disk;
backup database;
release channel t1;
}


Retore:
--------
rman> startup nomount;
run {
allocate channel t1 device type disk;
restore controlfile from autobackup;
alter database mount;
restore database;
release channel t1;
}


After the restore when I am trying to open the database, I am getting following error:
 
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center