Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 445
  • Last Modified:

Can RMAN 9.2.0.8 backup target database 10.2.0.4?

Good day Experts

We are in the process of upgrading our databases from 9.2.0.8 to 10.2.0.4.  We are planning to upgrde all our databases first, and then upgrade RMAN catalog last.  

Can RMAN executable schema, version, and catalog are in 9.2.0.8.backup target database 10.2.0.4?  If so, is there any drawback and/or restriction doing this way?

Thanks
0
E_Mak
Asked:
E_Mak
  • 3
1 Solution
 
MikeOM_DBACommented:

NO, but you can backup with nocatalog option and then register the backup when you upgrade the rman catalog.


0
 
MikeOM_DBACommented:

PS: upgrade catalog FIRST, then databases.

10.2 catalog is backward compatible.
0
 
E_MakAuthor Commented:
Mike, thanks for the information.  What will be the implication if not upgrading the catalog?  The reason why I am asking that is because when I went through the Oracle RMAN compatibility matrix from Oracle documentation(DOC ID 73431.1 and Oracle 10gR2 Backup and Recovery reference), it stated that it is compatible to backup target DB 10.2.0.4 with RMAN 9.2.0.8 schema, executable, and database.  
0
 
MikeOM_DBACommented:

Yes, according to that document you can backup a 10.2 db using the rman >=9.0.1 executable into an >= 9.0.1 catalog!!!

Try it out!

My preference would be to upgrade the catalog first.


0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now