Question:
I am getting these errors when doing a tablespace point in time recovery
(TSPITR) in RMAN:
RMAN-03002: failure of recover command at
03/06/2011 15:07:27
RMAN-20202: Tablespace not
found in the recovery catalog
RMAN-06019: could not translate tablespace
name "HRTEST"
How do I fix the RMAN-20202 error?
Answer: The
oerr utility can display details on this error message:
RMAN-20202:
Tablespace not found in the recovery catalog
Cause:
the specified tablespace is not found in the recovery catalog
Action:
make sure that the tablespace name is correct and that the recovery
catalog is up-to-date
In your case, you need to confirm that this tablespace name exists
within your ORACLE_SID database by querying the dba_data_files
view.
select
tablespace_name
from
dba_data_files
where
file_name = 'name of your HRTEST
file';
Also, query the
RMAN catalog database for details.
|
|
|
| |
|
Burleson is the American Team
Note:
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.
Verify
experience!
Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.
Errata?
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just
e-mail:
 and include the URL for the page.
Copyright © 1996 - 2020
All rights reserved by
Burleson
Oracle ®
is the registered trademark of Oracle Corporation.
|
|
