Home » RDBMS Server » Backup & Recovery » create recovery catalog in rman (oralce 9.0)
create recovery catalog in rman [message #424011] Tue, 29 September 2009 21:47 Go to next message
chuikingman
Messages: 90
Registered: August 2009
Member
Hi,
I want to create rman recovery catalog with target instance DEMO . Any idea how I can create ???
Re: create recovery catalog in rman [message #424012 is a reply to message #424011] Tue, 29 September 2009 22:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You create the catalog and register the database.
Exact steps in Documentation.
First hit from google got me here
http://www.idevelopment.info/data/Oracle/DBA_tips/RMAN_9i/RMAN9_4.shtml
Re: create recovery catalog in rman [message #424014 is a reply to message #424012] Tue, 29 September 2009 22:18 Go to previous messageGo to next message
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 #424022 is a reply to message #424014] Tue, 29 September 2009 23:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It is just an example.
You can use any tablespace in rman catalog database (as usual, except system).
Read documentation!!!!.
Re: create recovery catalog in rman [message #424023 is a reply to message #424022] Tue, 29 September 2009 23:18 Go to previous messageGo to next message
chuikingman
Messages: 90
Registered: August 2009
Member
Hi,
I have not yet create rman catalog database .
How can I know I use which table space ??
Or how can I find out what tablespace in database ???
Please describe in detailed ??
Re: create recovery catalog in rman [message #424027 is a reply to message #424011] Tue, 29 September 2009 23:42 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

Let documentation be your friend:

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmcatdb.htm#BRADV179

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmcatdb.htm#i1006260
Re: create recovery catalog in rman [message #424062 is a reply to message #424027] Wed, 30 September 2009 02:57 Go to previous messageGo to next message
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 #424063 is a reply to message #424011] Wed, 30 September 2009 03:00 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

Have you refered to the link which I've posted?
Re: create recovery catalog in rman [message #424069 is a reply to message #424027] Wed, 30 September 2009 03:12 Go to previous messageGo to next message
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 #424073 is a reply to message #424063] Wed, 30 September 2009 03:17 Go to previous messageGo to next message
chuikingman
Messages: 90
Registered: August 2009
Member
Hi,
yes. I refer your link .I read the document your mention
Below is the link
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmcatdb.htm#i1006260
Re: create recovery catalog in rman [message #424076 is a reply to message #424063] Wed, 30 September 2009 03:32 Go to previous messageGo to next message
chuikingman
Messages: 90
Registered: August 2009
Member
yes.
I read the link you refer .
Re: create recovery catalog in rman [message #424180 is a reply to message #424062] Wed, 30 September 2009 08:09 Go to previous message
Mahesh Rajendran
Messages: 10707
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
Previous Topic: Rman recovery
Next Topic: List query in RMAN
Goto Forum:
  


Current Time: Fri Apr 19 05:30:42 CDT 2024