Database Backup and Recovery (MOSC)

MOSC Banner

RMAN - Recovery from backupset

edited Dec 6, 2012 5:02AM in Database Backup and Recovery (MOSC) 2 commentsAnswered
Hi,
I am trying to bring up a database from available backupsets.  Here is the senario.

Orale version 10.2.0.5

1. Full backups were created via backupsets.
2. Some archive logs are available after the full backups were created.
 
The SCN numbers given below are not real (I just want to send the point across).

When I query the backupsets containing the full backups - all the datafiles are showing a SCN of 12300.
I have archive logs to SCN 12305.

So, I tried to restore first by 

run{
allocate channel ...
allocate channel ..
allocate channel..
restore database;
}  - No until command given.

Restored fine.  I can see all the database files in the correct locations.

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