Thanks a lot for your reply.

powneill: I know export is a logical backup. My backup is hot backup using RMAN. I don't think we need to shutdown the database incase of RMAN utility. RMAN check the block level corruption even though database is open while taking backup.


I was thinking as you have mentioned just to put the all files in directories and open DB2. Since the backup is taken by RMAN utility, all the backup files( data, control, etc.) are in one file which is in RMAN file format. Now, how do I restore it in DB2 as the backup is form DB1 and catalog knows that backup is taken form DB1. Is there any way I can decode the backup file(RMAN) in normal files (I mean exact format as in DB1).

Let me explain the requirement in more detail, probably some one from the forum can able to give me some solutions.

I got a dataware house(I mentioned it DB1). It contains data of many organisations(Members) which are clients of our client who owns the datawarehouse. Retaintion period for data is 3 months. But data has to be archived for 5 years so that report can be generated from old data if a member request to generate a report from a date which could be any date from last five years. Since I can not restore DB1 from the requested date as there are other memebrs who need current data I need archive database(which I mentioned DB2).

I cannot use export utility because of size (~500Gb). I can not take backup without RMAN as I am using Veritas NetBackup who recommed to use RMAN.

Appreciate your suggestion in advance

Regards,

abhijit