Topic: Backup & Recovery >> Flash Recovery area
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Flash Recovery area |
| Tony |
Posted: Mar 28, 2007 12:58:44 PM |
Total Post: 26
Joined: Dec, 2006
|
Hey There
I have a slight query regarding the recovery catalogue. The question is I created a recovery catalogue and also a user to own the recovery catalogue with the required privileges I then went ahead and created a database where this catalogue was to reside. I then registered the target database to be backed up. I then logged in to RMAN using the user I had created who owned the catalogue I then specified the target database ID (dbID) and I ran my backup script but it was not successful. An error message indicating that the user was not created.
What’s the procedure in using the recovery catalogue or is the error occurring because I created a catalogue database and the target database in the same server machine?
tonygys@yahoo.co.uk |
|
|
 Vigyan |
| Posted: Mar 28, 2007 04:07:10 PM |  |
|
Total Post: 386
Joined: May, 2001
|
Hi Tony,
Read this article. It should help you to setup RMAN backup procedure.
http://www.dbapool.com/articles/090601.html
If you still have problems, let me know.
Thanks,
Vigyan
|
|
|
|
|
| setu |
| Posted: May 07, 2007 07:33:16 AM | |
|
Total Post: 9
Joined: May, 2007
|
Hi! tony
Ensure that the recovery catalog and target databases do
not reside on the same disk. If they are on the same disk and you
lose one database, then you will probably lose the other.
the steps for creating a catalog are:
CONNECT SYS/oracle@catdb AS SYSDBA
CREATE USER rman IDENTIFIED BY cat
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE tools
QUOTA UNLIMITED ON tools;
SQL> GRANT RECOVERY_CATALOG_OWNER TO rman;
SQL> GRANT CONNECT, RESOURCE TO rman;
% rman CATALOG rman/cat@catdb
CREATE CATALOG;
Note that the creation of the catalog can take several minutes
then register your database
Thanks
Setu
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 335 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
