Database Backup and Recovery (MOSC)

MOSC Banner

How to restore controlfile from a NOCATALOG database backup.

edited Mar 22, 2012 5:04AM in Database Backup and Recovery (MOSC) 11 commentsAnswered ✓
And just to make matters worse, this is an 8.1.6.4 database.
I need to recover a database that is backed up via rman with NOCATALOG.

How do I tell rman where to find the backups of the controlfile?

From the Oracle 8 docs, the only example I see for recovering the controlfile  is "RECOVER CONTROLFILE".

When I issue it I get:

RMAN> run {
  allocate channel d1 type disk;
  restore controlfile;
  alter database mount;
  release channel d1;
  }
2> 3> 4> 5> 6>
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=8 devtype=DISK

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE

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