| Bishal |
Posted: May 02, 2008 01:23:48 AM |
Total Post: 160
Joined: Apr, 2008
|
I created recovery catalog and it was running properly... I show in my manual about the views on recovery catalog viz:
rc_database
rc_dtafile
rc_stored_script
But these tables are not created and as a result i am not able to view all these. way so? what is the problem..
Your replies are very much aapreciated. |
|
|
 GOPU |
| Posted: May 02, 2008 01:27:12 AM |  |
|
Total Post: 239
Joined: Apr, 2008
|
you registred the target database in the catalog ?
|
|
|
|
|
| Murtuja |
| Posted: May 02, 2008 01:32:13 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
Have you created catalog properly ?
You can create catalog using this link
http://www.oracle-base.com/articles/9i/RecoveryManager9i.php
You need to grant recovery_catalog_owner TO rmanuser
GRANT connect, resource, recovery_catalog_owner TO rmanuser;
|
|
|
|
|
| Bishal |
| Posted: May 02, 2008 01:35:43 AM | |
|
Total Post: 160
Joined: Apr, 2008
|
YA... i registered the target database..
all these commands
show, list report are working
but i am not able to access the views
|
|
|
|
|
| Bishal |
| Posted: May 02, 2008 01:38:32 AM | |
|
Total Post: 160
Joined: Apr, 2008
|
while connecting to recovery catalog through RMAN, do we also need to connect to target database
|
|
|
|
|
| GOPU |
| Posted: May 02, 2008 01:39:11 AM | |
|
Total Post: 239
Joined: Apr, 2008
|
you are trying to query the view from the RMAN user ?right...
|
|
|
|
|
| GOPU |
| Posted: May 02, 2008 01:40:46 AM | |
|
Total Post: 239
Joined: Apr, 2008
|
when you are trying to query the views, what error it is throwing...?
Can you post that ?
|
|
|
|
|
| Bishal |
| Posted: May 02, 2008 01:41:12 AM | |
|
Total Post: 160
Joined: Apr, 2008
|
ya... but there are no tables as such...
|
|
|
|
|
| GOPU |
| Posted: May 02, 2008 01:43:44 AM | |
|
Total Post: 239
Joined: Apr, 2008
|
you are not able to see the tables and vies like...
rc_database
rc_dtafile
rc_stored_script
or you are not albe to query from the tables and view ?
|
|
|
|
|
| Bishal |
| Posted: May 02, 2008 01:45:28 AM | |
|
Total Post: 160
Joined: Apr, 2008
|
i am not able to see the tables like
rc_database
rc_datafile
As a result not able to view...
|
|
|
|
|
| GOPU |
| Posted: May 02, 2008 01:49:02 AM | |
|
Total Post: 239
Joined: Apr, 2008
|
from where you are trying see the tables like
rc_database
rc_dtafile
rc_stored_script
is it from the RMAN prompt or from the RMAN user ?
|
|
|
|
|
| Bishal |
| Posted: May 02, 2008 01:53:32 AM | |
|
Total Post: 160
Joined: Apr, 2008
|
|
|
|
|
| GOPU |
| Posted: May 02, 2008 01:58:34 AM | |
|
Total Post: 239
Joined: Apr, 2008
|
when you tried like
select * from rc_database;
it is displaying nothing ??
what error it is throwing ?
from the rc_database view,you are able to see your target database name ?
|
|
|
|
|
| Bishal |
| Posted: May 02, 2008 02:03:09 AM | |
|
Total Post: 160
Joined: Apr, 2008
|
it shows for rc_database
table or view does not exist
Even when i log on as sysdba and i query the dba_tables
it doesnt show me the table named as rc_database
|
|
|
|
|
| Bishal |
| Posted: May 02, 2008 02:03:52 AM | |
|
Total Post: 160
Joined: Apr, 2008
|
it shows for rc_database
table or view does not exist
Even when i log on as sysdba and i query the dba_tables
it doesnt show me the table named as rc_database
|
|
|
|
|
| Murtuja |
| Posted: May 02, 2008 02:04:44 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
Hi,
Have you executed "create catalog " command ?
|
|
|
|
|
| GOPU |
| Posted: May 02, 2008 02:07:24 AM | |
|
Total Post: 239
Joined: Apr, 2008
|
do you have seperate user for RMAN.... ??
please post the command how you are connecting to RMAN prompt
like
rman target rman/rman@orcl catalog rmancat/rmancat@orcl2
|
|
|
|
|
| Bishal |
| Posted: May 02, 2008 02:09:16 AM | |
|
Total Post: 160
Joined: Apr, 2008
|
ya i created that.. and it worked fine that time
|
|
|
|
|
| Murtuja |
| Posted: May 02, 2008 02:29:00 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
I will suggest you to recreate rman catalog.
You can drop rman use and recreate everything using below link.
http://www.oracle-base.com/articles/9i/RecoveryManager9i.php
|
|
|
|
|
| Bishal |
| Posted: May 02, 2008 02:29:41 AM | |
|
Total Post: 160
Joined: Apr, 2008
|
c:\>rman target sys/oracle@bishal
rman> connect catalog rman_db01/rman_db01@bishal
this is what i used to connect to recovery catalog
|
|
|
|
|
| GOPU |
| Posted: May 02, 2008 02:32:47 AM | |
|
Total Post: 239
Joined: Apr, 2008
|
Are you trying to view from the user rman_db01/rman_db01
|
|
|
|
|
| Bishal |
| Posted: May 02, 2008 02:35:24 AM | |
|
Total Post: 160
Joined: Apr, 2008
|
ya... i am trying to view from rman_db01/rman_db01
but there is no table as such
|
|
|
|
|
| Bishal |
| Posted: May 02, 2008 02:38:46 AM | |
|
Total Post: 160
Joined: Apr, 2008
|
thanx Gopu... sorry my mistake... now its working
|
|
|
|
|
| GOPU |
| Posted: May 02, 2008 02:38:53 AM | |
|
Total Post: 239
Joined: Apr, 2008
|
I think you are not created the RMAN properly...
follow what Murtuja said.
drop the RMAN user,
drop the catalog,
do everything from the begining once more....
there are some links posted by Murtuja,check those links also..
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
