Printable View
I have askted my management to give a separate machine to maintain
recovery database.
Now the probelm is i have 2 different production enviroment
1.oracle 8 on windows
2.oracle 9i on windows
can both oracle 8 and oracle9i database can be installed in the same machine,so that i can maintain catalogs of both version
Plz guide me
Thanks and regards,
1) You do not need to install the DBs on the same machine in order to share the same recovery catalog
2) I am not sure if DBs in different versions can share same recovery catalog
I wish to maintain 2 recovery catalogs
1 for oracle 8
1 for oracle 9i
now if i install one oracle version above other one of the version gets
overwritten
Plz suggest a way
you only need one catalog
It is definitely not clear what are you asking and what are you doing.
Pls. explain in more details
(i)I have 9 production database on oracle 8 for which i am using
Recovery Manager: Release 8.0.6.0.0 - Production
(ii)I have 2 production database on oracle 9i for which i am using
Recovery Manager: Release 9.2.0.2.1 - Production
After long discussion i got a machine to maintain rcvcat
now I am going to maintain (i)oracle 8 rcvcat in this new machine
Now my doubt is can i have oracle 9i home so that i can maintain
the catalog of (ii)
Create 1 9i Catalog. It can backup up your 8 and 9i databases. No need to have 2 catalogs.Quote:
Originally Posted by natraj.dba
Thank you sir,
this was haunting me for a very long time
thanks again
As suggested by senior member
i tried to backup oracle 8 db using 9i catalog
I get following error message
C:\>rman catalog rman/rman target=sys/oracle@remote
Recovery Manager: Release 9.2.0.1.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
Recovery Manager incompatible with TARGET database: RMAN 8.0.4 to 8.0.4 required
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-06429: TARGET database is not compatible with this version of RMAN
C:\>
Could some one plz help
Well, the problem is you start the RMAN at the rcvcat host.
Go to the database host and issue
rman target / catalog rman/rman@allias
RMAN> register database
And go further
Thanks for the support, i tried as per your instruction
Now i am able to conect to catalog,when i try to register database
its giving text box
Recovery Manager application error
with message to be send to Microsoft or not
I guess this is because of compatablity issue (oracle 8 on windows2003) would be the probelm
G:\>rman80 rcvcat rman/rman@usa
Recovery Manager: Release 8.0.6.0.0 - Production
RMAN-06008: connected to recovery catalog database
RMAN> connect target internal/oracle@adm
RMAN-06005: connected to target database: ADM
RMAN> list backupset of database;
RMAN-03022: compiling command: list
RMAN-03024: performing implicit full resync of recovery catalog
RMAN-03023: executing command: full resync
I would like to extend my thanks to all members and special thanks to Mr.Bore for the continuous support
I am going ahead with separate catalog for different oracle version
I had the same problem as you last year and was never able to get 8i and 9i databases mixed in the same catalog on Windows. As there was only one 8i legacy system, I opted to use scripts for it in the end.
Chris
NP, I'm allways glad to help :-)