Re: what user privileges do I need to create the repository

Hi

If you are using a recovery catlog, then the database in which the recovery catalog resides will need to have a user created for the purpose and the catrman.sql script run against it. You will also need to grant recovery_catalog_owner to the rman db account. This should all be covered - in much greater detail in the Oracle Docs.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"JS" <ghp_at_videotron.ca> wrote in message
news:M09G5.7199$mY.169661_at_weber.videotron.net...


> for rman:

> first, set oracle_sid=your database name (4 character)

> then, from O/S prompt,  rman80 nocatalog

> then, connect target userid/password, (, this is userid/password from your

> current Oracle database, userid show have sysdba priv)

> rman/rman only used if you are going to use the recovery catalog option,

 to


> do this you need to set up a tablespace in a database other than the

> database you want to backup, preferably on a seperate disk, the usual

> practise is to set up user rman as the owner of the tablespace

> check documentation Backup and Recovery for complete info

> JS

>

> Rob <rfreez_at_gte.net> wrote in message

> news:M_GE5.426$9n6.89370_at_dfiatx1-snr1.gtei.net...

> > Hi,

> >

> > I just installed OEM on my Oracle database and I was wondering what user

 I


> > can use for the repository, or what privileges do I need to grant to an

> > existing user to own the repository.  Also, how can I view all possible

> > privileges?

> >

> > Finally, I have Oracle 8i and I can't get rman to work.  Is rman/rman a

> > valid user and password?  Where do I even start to get rman running?

> > Thanks.

> >

> > Rob Freeman

> > rfreez_at_gte.net

> >

> >

>

>