DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: rman help !!!!

  1. #1
    Join Date
    Jul 2001
    Posts
    13

    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

  2. #2
    Join Date
    Feb 2000
    Posts
    175
    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.

  3. #3
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    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

  4. #4
    Join Date
    Jul 2001
    Posts
    13

    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

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
  •  


Click Here to Expand Forum to Full Width