Database Backup and Recovery (MOSC)

MOSC Banner

Unable to open spfile Error seen in alert log while refreshing a database

edited Jan 15, 2014 4:09PM in Database Backup and Recovery (MOSC) 1 commentAnswered
Hi Friends,
I am working on a database refresh using RMAN duplicate command. Below are the steps done so far.

On Production Database Server:

1. Took RMAN full backup including archivelogs.
2. Copied the backups to the same location on the Dev Server.

On the Dev Server

We have Oracle Restart 11.2.0.3 (One GI Home and 3 Database Homes, meaning 3 databases in their own homes).

1. Created a parameter file from one of the databases.
2. Created new diskgroups for the new database.
3. Edited the parameter file and put the new database name(the one I am going to create using the production backup) and new diskgroup names in that parameter file.

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