|
|
Re: create recovery catalog in rman [message #424014 is a reply to message #424012] |
Tue, 29 September 2009 22:18 |
chuikingman
Messages: 90 Registered: August 2009
|
Member |
|
|
Hi,
In document you mention ,
CREATE USER rman IDENTIFIED BY rman
2 DEFAULT TABLESPACE tools
3 TEMPORARY TABLESPACE temp
4 QUOTA UNLIMITED ON tools;
Where can I create tools and temp ??
what is its strcuture ????
please advice ???/
|
|
|
|
|
|
Re: create recovery catalog in rman [message #424062 is a reply to message #424027] |
Wed, 30 September 2009 02:57 |
chuikingman
Messages: 90 Registered: August 2009
|
Member |
|
|
Hi,
I still confuse with the command
How can I let below command work ???
CONNECT SYS/oracle@catdb AS SYSDBA
How can I creat the instance catdb first ???
How can I let below command work
How can I create the temp and tools tablesapce first ??/
CREATE USER rman IDENTIFIED BY cat
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE tools
QUOTA UNLIMITED ON tools;
Please advice more detailed ???
|
|
|
|
Re: create recovery catalog in rman [message #424069 is a reply to message #424027] |
Wed, 30 September 2009 03:12 |
chuikingman
Messages: 90 Registered: August 2009
|
Member |
|
|
Hi,
I also try tge comand in the document
why it si not work ??
please advice .
[ora920]/database>sqlplus " / as sysdba"
SQL*Plus: Release 9.2.0.7.0 - Production on Wed Sep 30 15:37:01 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning option
JServer Release 9.2.0.7.0 - Production
SQL> connect SYS/oracle@DEMO AS SYSDBA
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
|
|
|
|
|
Re: create recovery catalog in rman [message #424180 is a reply to message #424062] |
Wed, 30 September 2009 08:09 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
I am not trying to discourage you. But the fact is,
before you start running, you learn to walk.
If you do not know how to create an instance/db, tablespace etc,
there is no point in trying to backup it.
Please start with
database concepts guide, admin guide and read RMAN guide.
This is just a forum. We can help you with little things, discuss
the issues and argue mundane things.
But we cannot teach you Oracle.
Definitely not in the style you are looking into.
All your questions are answered in admin guide.
http://www.oracle.com/pls/db102/homepage
|
|
|