Database Backup and Recovery (MOSC)

MOSC Banner

cannot open database backed up in noarchivelog mode

edited Jun 21, 2010 3:32PM in Database Backup and Recovery (MOSC) 4 commentsAnswered
Hi,

I am trying to recover a database on a different machine from a backup of a cold copy of a database. I have the original control file, datafiles, online redo log files in the backup taken. The original database is running in NOARCHIVELOG mode; hence no archive logs backed up.

On the other machine, the steps to bring up the DB performed are:
1. startup mount
2. using RMAN, run the below:
run {
allocate channel rep_auto type disk;
recover database;
}
sql 'alter database open';

The error I get is:
sql statement: alter database open
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

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