RMAN Not seeing backupsets [message #512225] |
Fri, 17 June 2011 11:24 |
|
SniperJane
Messages: 11 Registered: June 2011
|
Junior Member |
|
|
Hi All,
I was handed a folder that consists of all the files (Datafiles, controlfiles,spfiles, backupsets etc) for a database. The SID is Oracle.
So now I have two options:
1. Attach the Datafiles
2. Restoring the Database with the Backupsets.
Option 1:
I tried with working with the control files but didnt get anywhere because I did not understand how to attach the datafiles (I tried modifying the control file, to no avail).
I do have an idea tho, I tried replacing the spfiles and pfile then copying the datafiles (replacing the existing ones)...but I could not create the control file as well...
Option 2:
I do not know how to make RMAN see the backupsets of the Old database; despite they are in the same location as those of the new database.
Everypart of me want to use the Backupsets. What am I doing wrong?
SniperJane
|
|
|
|
|
|
|
|
|
|
|
|
Re: RMAN Not seeing backupsets [message #512251 is a reply to message #512248] |
Fri, 17 June 2011 12:21 |
John Watson
Messages: 8951 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I hope Michel and BS will forgive me for butting in, but I think I see your mistake. You say
Quote:I installed the Oracle database(same Oracle SID) and used same directory structure.
but I think what you did was:
1. install the Oracle home - correct
2. create a database - wrong
I think that if you delete all the datafiles, tempfiles,controlfiles, and online logs on your new machine, and then replace them with the files from the original database, you may then have a working database.
The alternative is to use RMAN to create a duplicate of the database, which will require a lot more understanding: read up on creating a duplicate without a connection to the target.
|
|
|
|
|
|
|