Home » RDBMS Server » Backup & Recovery » how to use 10GR2 RMAN database to backup 9.2.0.5 database?
how to use 10GR2 RMAN database to backup 9.2.0.5 database? [message #182398] Fri, 14 July 2006 10:15 Go to next message
eddie137
Messages: 6
Registered: March 2006
Junior Member
Hi team!!
I am in the process of upgrading my production database which is now 9.2.0.5 to 10GR2 version.
Currently we user rman 9.2.0.7 to backup this production database.After the upgrade we would like to use RMAN 10GR2 database to backup production (which will be at the version 10GR2).
We already created a new 10GR2 RMAN database .Production database is not registered yet in 10GR2 RMAN DATABASE.
My "?'s" are:
1.Can we user RMAN 10GR2 database to backup 9.2.0.5 production database?
If yes than what commands should i do ?
If no than what are the correct steps ?(upgrade it first and than registered with new rman10GR2 database )

Thanks!!!
Re: how to use 10GR2 RMAN database to backup 9.2.0.5 database? [message #182399 is a reply to message #182398] Fri, 14 July 2006 10:25 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
In general,
RMAN executable should be same as target database ( some exception may apply. But, it is your BACKUP. You may not want to messup anyting).
RMAN catalog database is generally compatible with lower versions ( not sure about the specific versions)
I would check with metalink / Oracle Support. Raise a TAR.
>>If yes than what commands should i do ?
Same normal process.
Re: how to use 10GR2 RMAN database to backup 9.2.0.5 database? [message #182400 is a reply to message #182399] Fri, 14 July 2006 10:33 Go to previous messageGo to next message
eddie137
Messages: 6
Registered: March 2006
Junior Member
Thank you Mahesh !
So what would you do in my situation?
Please correct me if i am wrong:
first : upgrade existing production database from 9.2.0.5 to 10GR2 version,
second: because our 10GR2 database is new i have to register my target (production) database in rman10GR2 catalog
rman target system/... rcvcat rman10/...@rman10

register database;


is this correct?
Re: how to use 10GR2 RMAN database to backup 9.2.0.5 database? [message #182402 is a reply to message #182400] Fri, 14 July 2006 10:42 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> So what would you do in my situation?
As i said before, i would first check the metalink docos/previous related TARs.
There used to a a specific compatiblity matrix and all related stuff bundled in a document ( if you are interested in having different versions).
I would be much worried about the restoration part.
I would test it thoroughly.

Quote:


first : upgrade existing production database from 9.2.0.5 to 10GR2 version,
second: because our 10GR2 database is new i have to register my target (production) database in rman10GR2 catalog
rman target system/... rcvcat rman10/...@rman10

register database;

These are the 'steps' you do(in any case. 10g to 9i or 10g to 10g)
More info in documentation.
Your outline steps seems to be right.
In this case, since all versions are same, you can pretty be cofident. create a parallel environment in 10g. Do a backup. DO a test restore. Look for new options in 10g RMAN API and whatever you want to do).
All i mean, TEST the environment. Make yourself comfortable. Then do the production migration.

[Updated on: Fri, 14 July 2006 10:42]

Report message to a moderator

Previous Topic: Update the testing DB from production from archive files
Next Topic: recover from loss of controlfile and current redolog file
Goto Forum:
  


Current Time: Thu Mar 28 21:15:53 CDT 2024