为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
ID_CODE: --03134284368-20250423-270902-20149
BUILD_TYPE: Enterprise
INNER_VER: 8.1.4.80
【操作系统】:银河麒麟v10 sp3
【CPU】: Kunpeng-920
【问题描述】*: 使用表空间备份数据库恢复失败
[dmdba@dm-database-training bin]$ disql SYSDBA/密码@127.0.0.1:5238
#创建oaxcaaa表空间
SQL> create tablespace oaxcaaa datafile '/dm/data/DAMENG/oaxcaaa_01.dbf' size 32 autoextend on next 1 maxsize 1024;
#查看当前会话id和提交参数
SQL> SELECT SESS_ID, AUTO_CMT, DDL_AUTOCMT FROM V$SESSIONS WHERE SESS_ID = (SELECT SYS_CONTEXT('USERENV', 'SESSIONID'));
行号 SESS_ID AUTO_CMT DDL_AUTOCMT
1 281468742276152 N Y
#准备oa_user表数据
SQL> create table oa_user (id int primary key, name varchar(20), create_time timestamp) tablespace oaxcaaa;
SQL> insert into oa_user(id,name,create_time) values(1,'aaa',now());
SQL> insert into oa_user(id,name,create_time) values(2,'bbb',now());
SQL> commit;
SQL> select * from oa_user;
行号 ID NAME CREATE_TIME
1 1 aaa 2025-12-19 10:24:24.354293
2 2 bbb 2025-12-19 10:24:26.980611
#备份oaxcaaa表空间
SQL> backup tablespace oaxcaaa full backupset '/dm/data/DMDB/bak/FULL_oaxcaaa_01';
SQL> insert into oa_user(id,name,create_time) values(3,'incr_ccc',now());
SQL> insert into oa_user(id,name,create_time) values(4,'incr_ddd',now());
SQL> commit;
SQL> select * from oa_user;
行号 ID NAME CREATE_TIME
1 1 aaa 2025-12-19 10:24:24.354293
2 2 bbb 2025-12-19 10:24:26.980611
3 3 incr_ccc 2025-12-19 10:25:12.884593
4 4 incr_ddd 2025-12-19 10:25:12.885226
SQL> backup tablespace oaxcaaa increment backupset 'incr_oaxcaaa_01';
SQL> insert into oa_user(id,name,create_time) values(5,'incr_eee',now());
SQL> insert into oa_user(id,name,create_time) values(6,'incr_fff',now());
SQL> insert into oa_user(id,name,create_time) values(7,'incr_ggg',now());
SQL> commit;
SQL> select * from oa_user;
行号 ID NAME CREATE_TIME
1 1 aaa 2025-12-19 10:24:24.354293
2 2 bbb 2025-12-19 10:24:26.980611
3 3 incr_ccc 2025-12-19 10:25:12.884593
4 4 incr_ddd 2025-12-19 10:25:12.885226
5 5 incr_eee 2025-12-19 10:26:27.413996
6 6 incr_fff 2025-12-19 10:26:27.414799
7 7 incr_ggg 2025-12-19 10:26:27.415265
SQL> SELECT SYSDATE();
行号 SYSDATE()
1 2025-12-19 10:26:43
SQL>
SQL> drop table oa_user;
SQL> select * from oa_user;
select * from oa_user;
第1 行附近出现错误[-2106]:无效的表或视图名[OA_USER].
已用时间: 1.563(毫秒). 执行号:0.
SQL> exit
[dmdba@dm-database-training bin]$ ./DmServicePROD stop
Stopping DmServicePROD: [ OK ]
[dmdba@dm-database-training bin]$ dmrman
dmrman V8
RMAN> restore database '/dm/data/DMDB/dm.ini' tablespace oaxcaaa from backupset '/dm/data/DMDB/bak/FULL_oaxcaaa_01';
RMAN> recover database '/dm/data/DMDB/dm.ini' tablespace oaxcaaa;
RMAN> exit
time used: 2.544(ms)
[dmdba@dm-database-training bin]$ ./DmServicePROD start
Starting DmServicePROD: [ OK ]
[dmdba@dm-database-training bin]$ disql SYSDBA/密码@127.0.0.1:5238
SQL> select * from oa_user;
第1 行附近出现错误[-2106]:无效的表或视图名[OA_USER].
已用时间: 1.563(毫秒). 执行号:0.
==表空间数据没有还原成功=
