DBID

[ClowneUser]

Hi,

We have just started using RMAN to take backups, i want to now restore our Live database to our test database, both databases currently reside on the same server, can someone just look over what i think I've got to do and see if it looks right..

1. log into rman ( test system )
2. shutdown database
3. rmove existing datafiles/control files
4. set dbid = ( this bit im a little unsure at as both databases seem to have the same dbid - is this OK or do they need to be different?)
5. restore controlfile from autobackup
6. alter database mount
7. restore database
8. recover database
9. alter database open reset logs

Does this look right or have i missed something out?

Thanks in advance,

Mick.

 

[ClowneUser]

one thing i forgot, but needs to be done is to change the name..

The DB that is backed up is called Live and yes you guessed it our test database is Test..

can this be done and if so when does it need to be done?

Regards,

Mick.

 

[karluk]

What you want to do is best accomplished with the rman "duplicate database" command. If you have access to Metalink, please read article 228257.1 (among others) for details.

 

[LKBrwnDBA]

...
Does this look right or have i missed something out?

Because of the same dbid for both prod and test databases, I assume you are not using an RMAN catalog, is this true?

Anyway, as Karluk suggests, the best method is to use the "DUPLICATE" command.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[ClowneUser]

Hi Karluk, unfortunately i dont have access to metalink, but I will look at the duplicate command, see if I can figure out how it works.

LKBrwnDBA, no we are not using RMAN catalog, what we do is a full RMAN backup of the database every night so not really needed to use a catalog.

Regards,

Mick.

 

[LKBrwnDBA]

You can actually check out this scenario in fine
Oracle® Database Backup and Recovery Advanced User's Guide.





----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb