RMAN - Best Practices

Hi,

I'm just getting started with RMAN (v8.0.5). I understand that the structure of the catalog changes from release to release (i.e. 805 is different than 8.1.5, is different from 8.1.6...).

So I named my schema rman805, with the intent to build another schema rman816 when I finally upgrade. I intended to register all my databases in a single schema (prd, dev, tst...).

But I'm running into a "database already registered" error. The doc leads me to believe its because the prior DBA copied the databases (i.e. copied the files, edited the control file, and started the database under a different name).

So, How are you guys doing this:

• For each target database, are you building a new schema and installing the catalog?
• For each database version are you naming the schema with that version in the name?
• If your building a separate schema for each database, how big should that users default tablespace be: I've seen 10M, 50M, and 100M in different oracle docs.
• Where are you writing your rman files i.e. /u01/app/oracle/admin/SID/rman?
• I'm afraid to use the "delete input" clause when I backup my archive logs. Can I trust that the rman backup of the archives won't be corrupt?

I appreciate your thoughts
Thanks
Jay Received on Wed Oct 25 2000 - 08:58:19 CDT