Topic: Backup & Recovery >> rman
|
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.
|
|
|
|
| raj |
Posted: Oct 17, 2007 07:52:00 AM |
Total Post: 15
Joined: Aug, 2007
|
hi,
im doing rman im trying drop my catalog im not able to drop my catalog
im geting some errors
RMAN> drop catalog;
error occurred in source file: krmk.pc, line: 7176
text of failing SQL statement: ¨ Ø@
ORACLE error from recovery catalog database: ORA-00604: error occurred at recursive SQL level 1
ORA-25153: Temporary Tablespace is Empty
error occurred in source file: krmk.pc, line: 7176
text of failing SQL statement: ¨ Ø@
ORACLE error from recovery catalog database: ORA-00604: error occurred at recursive SQL level 1
ORA-25153: Temporary Tablespace is Empty
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06434: some errors occurred while removing recovery catalog
|
|
|
 Mohammed Taj |
| Posted: Oct 18, 2007 04:13:09 AM |  |
|
Total Post: 746
Joined: Jul, 2007
|
ORA-25153: Temporary Tablespace is Empty
Please add tempfile in your existing temp tablespace or create new temp tablespace and make it default temporary tbs for database.
|
|
|
|
|
| nick |
| Posted: Oct 19, 2007 04:01:54 PM | |
|
Total Post: 30
Joined: Sep, 2007
|
You will loose all the incarnations, oncve u drop the catalog. create a temporary tablespace abd make it default.
|
|
|
|
|
| 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 | 333 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
