Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: what user privileges do I need to create the repository
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
>
>
Received on Sun Oct 15 2000 - 00:50:57 CDT
![]() |
![]() |