could not translate tablespace name "TEST_TBS"

最新推荐文章于 2024-07-18 08:15:00 发布

原创最新推荐文章于 2024-07-18 08:15:00 发布 · 1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#rman

rman 专栏收录该内容

16 篇文章

订阅专栏

尝试使用RMAN命令列出TEST_TBS表空间的备份时遇到错误，提示表空间未在恢复目录中找到且无法识别该表空间名称。通过查询数据库文件及表空间信息显示，TEST_TBS表空间可能已被删除。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

RMAN> list backup of  tablespace TEST_TBS;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 02/01/2015 15:26:24
RMAN-20202: tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name "TEST_TBS"

RMAN>  原因是表空间已经被删除

<pre name="code" class="sql">SQL> select t2.file#,t1.name datafilename,t2.name from v$tablespace t1,v$datafile t2 where t1.ts# = t2.ts#;  

     FILE# DATAFILENAME 	NAME
---------- -------------------- --------------------------------------------------------------------------------
	 1 SYSTEM		/u01/oracle/oradata/db01/system01.dbf
	 2 UNDOTBS1		/u01/oracle/oradata/db01/undotbs01.dbf
	 3 SYSAUX		/u01/oracle/oradata/db01/sysaux01.dbf
	 4 USERS		/u01/oracle/oradata/db01/users01.dbf
	 5 TS_16K		/tmp/test_block_size.dbf
	 6 FRANKS		/u01/oracle/oradata/db01/ts_test_me/frankts01.dbf
	 9 FRANKS		/u01/oracle/oradata/db01/ts_test_me/frankts2.dbf
	 7 DEMOTS		/u01/oracle/oradata/db01/ts_test_me/demots01.dbf
	 8 UNDOTS		/u01/oracle/oradata/db01/ts_test_me/undots01.dbf
	10 BIGTS		/u01/oracle/oradata/db01/ts_test_me/bigts01.dbf
	11 DTFILETS		/u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf

     FILE# DATAFILENAME 	NAME
---------- -------------------- --------------------------------------------------------------------------------
	12 DTFILETS		/u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
	13 LOCAL		/tmp/local.dbf

13 rows selected.

SQL>