-
Hi
how shall i create 2 database on single system for R.catalog and target database, as i want to run Rman commands.
do i need to have 2 oracle_home path ? how shall i able to make both
instance active to run Rman commands.
please give me the path and tips to run Backup/recover Rman commands.
please helps me..
Bye
Thanks
biju
-
Hi,
No you don't need 2 ORACLE_HOME's all you need is 2 databases.
Use one as your target database that will contain all your data. The other is for the RMAN data.
This RMAN database is a standard database.
within it create a tablespace to hold the rman data.
and create a user to own the rman data eg rman. and grant the 'recovery catalog owner' privilege.
login to rman using this user and issue the create catalog command.
then connect to the target database and register the target.
you should now be able to use rman to backup/restore the target.
Hope the above make sense!!
Cheers
Craig.
-
Craig's response is correct, I have done precisely that i.e. create two databases on the same machine, use one as your target and the other for your rman catalog. Works beaufully. However, in production environment, you should have the catalog database on a completely different machine. Please come back right here if you have more questions.
roukie-dba
-
Hi
craig and roukie
Thanks a lot for enlighting me on configuring Rman.
it's working perfectly as you said but i also configured listner and services so that i could connect target database from R.database also an important thing is you must have at least 20 mb of free space in tablespace.
i am still in the process of executing some scripts on backup/recovery
using rman.
can anyone tell me that Rman is more reliable for backup/restore Or
is it necessary to master all concepts of rman as i am still look out
for any fresh job.
Bye
Thanks
biju
-
Originally posted by biju72
can anyone tell me that Rman is more reliable for backup/restore Or
is it necessary to master all concepts of rman as i am still look out
for any fresh job.
Not everybody uses RMAN. However, I would think that somebody that has a firm grasp of RMAN would have a good shot at knowing their B&R concepts.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|