Database Backup and Recovery (MOSC)

MOSC Banner

Oracle 9i restore from Backup.

edited Mar 26, 2012 4:03AM in Database Backup and Recovery (MOSC) 8 commentsAnswered
Hi all

I'm new to this Im having problems restoring from backup.

First question: I'm trying to restore a backup taken from a AIX 5.1 environment  to a AIX 6.1 ?

The oracle install is at the same level

SQL*Plus: Release 9.2.0.5.0 - Production on Mon Mar 26 20:28:42 2012

I've managed to get the database in the mount status

SQL> startup mount
ORACLE instance started.

Total System Global Area 1110411904 bytes
Fixed Size                   744064 bytes
Variable Size             469762048 bytes
Database Buffers          637534208 bytes
Redo Buffers                2371584 bytes
Database mounted.

when I try and recover the database I get the following error message...

SQL> recover database using backup controlfile until cancel;

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