暂无图片
不完全恢复某个pdb报错误
我来答
分享
Asky
2023-04-12
不完全恢复某个pdb报错误

数据库是19C的,在不完全恢复某个pdb,报如下错误,请问是什么原因呢?

RMAN> run{
2> set until sequence 58;
3> restore pluggable database pdb1;
4> recover pluggable database pdb1;
5> }

executing command: SET until clause

Starting restore at 11-APR-23
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00039 to /u01/app/oracle/oradata/ORA19C/pdb1/tps_hxl01.dbf
channel ORA_DISK_1: reading from backup piece /u01/rmanbak/pdbbak/pdb1_fullbk_ORA19C_23_0n1pc5sq_20230411.bak
channel ORA_DISK_1: piece handle=/u01/rmanbak/pdbbak/pdb1_fullbk_ORA19C_23_0n1pc5sq_20230411.bak tag=TAG20230411T225833
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00037 to /u01/app/oracle/oradata/ORA19C/pdb1/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00038 to /u01/app/oracle/oradata/ORA19C/pdb1/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/rmanbak/pdbbak/pdb1_fullbk_ORA19C_25_0p1pc5sq_20230411.bak
channel ORA_DISK_1: piece handle=/u01/rmanbak/pdbbak/pdb1_fullbk_ORA19C_25_0p1pc5sq_20230411.bak tag=TAG20230411T225833
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00035 to /u01/app/oracle/oradata/ORA19C/pdb1/system01.dbf
channel ORA_DISK_1: restoring datafile 00036 to /u01/app/oracle/oradata/ORA19C/pdb1/sysaux01.dbf
channel ORA_DISK_1: reading from backup piece /u01/rmanbak/pdbbak/pdb1_fullbk_ORA19C_24_0o1pc5sq_20230411.bak
channel ORA_DISK_1: piece handle=/u01/rmanbak/pdbbak/pdb1_fullbk_ORA19C_24_0o1pc5sq_20230411.bak tag=TAG20230411T225833
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
Finished restore at 11-APR-23

Starting recover at 11-APR-23
Segmentation fault (core dumped)

我来答
添加附件
收藏
分享
问题补充
3条回答
默认
最新
Asky

查看生产的core文件如下:

[oracle@localhost ~]$ gdb corefile core.2306
GNU gdb (GDB) Red Hat Enterprise Linux 7.6.1-120.el7
Copyright (C) 2013 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law. Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-redhat-linux-gnu".
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>...
corefile: No such file or directory.
[New LWP 2306]
[New LWP 2313]
Missing separate debuginfo for the main executable file
Try: yum --enablerepo='*debug*' install /usr/lib/debug/.build-id/e0/6cd1169cd8de8eb1817689f033feb60279f810
Core was generated by `rman '.
Program terminated with signal 11, Segmentation fault.
#0 0x00007fc6b1a694fb in ?? ()

暂无图片 评论
暂无图片 有用 1
打赏 0
Asky

[oracle@localhost ~]$ gdb rman core.2306
GNU gdb (GDB) Red Hat Enterprise Linux 7.6.1-120.el7
Copyright (C) 2013 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law. Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-redhat-linux-gnu".
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>...
Reading symbols from /u01/app/oracle/product/19.3.0.0/db_1/bin/rman...(no debugging symbols found)...done.
[New LWP 2306]
[New LWP 2313]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib64/libthread_db.so.1".
Core was generated by `rman '.
Program terminated with signal 11, Segmentation fault.
#0 0x00007fc6b1a694fb in raise () from /lib64/libpthread.so.0
Missing separate debuginfos, use: debuginfo-install glibc-2.17-317.el7.x86_64 libaio-0.3.109-13.el7.x86_64 libgcc-4.8.5-44.el7.x86_64 numactl-libs-2.0.12-5.el7.x86_64
(gdb) bt
#0 0x00007fc6b1a694fb in raise () from /lib64/libpthread.so.0
#1 0x00007fc6b561c30f in skgesigOSCrash () from /u01/app/oracle/product/19.3.0.0/db_1/lib/libclntsh.so.19.1
#2 0x00007fc6b5cfedfd in kpeDbgSignalHandler () from /u01/app/oracle/product/19.3.0.0/db_1/lib/libclntsh.so.19.1
#3 0x00007fc6b561c612 in skgesig_sigactionHandler ()
from /u01/app/oracle/product/19.3.0.0/db_1/lib/libclntsh.so.19.1
#4 <signal handler called>
#5 0x00000000008114fd in krmkicat ()
#6 0x00000000006b9bb5 in krmrTspitrSetUntil ()
#7 0x00000000006a9580 in krmrDoPdbpitr ()
#8 0x0000000000683070 in krmrecov ()
#9 0x000000000065ea5c in krmicomp ()
#10 0x0000000000660209 in krmice1 ()
#11 0x0000000000659683 in krmice ()
#12 0x0000000000651ea9 in krmiep2 ()
#13 0x0000000000662aee in krmmexe ()
#14 0x0000000000661bbc in krmmmai ()
#15 0x00007fc6b2ceba12 in lpmcall () from /u01/app/oracle/product/19.3.0.0/db_1/lib/libclntshcore.so.19.1
#16 0x00007fc6b2cec5d9 in lpmpmai () from /u01/app/oracle/product/19.3.0.0/db_1/lib/libclntshcore.so.19.1
#17 0x0000000000650758 in main ()
(gdb) 

暂无图片 评论
暂无图片 有用 0
打赏 0
Asky

验证了下

set until time "TO_DATE('2023-04-12 22:11:00','YYYY-MM-DD HH24:MI:SS')"set until scn 1476006 这两种方式是可以做不完全恢复,但是使用set until sequence就不行,不知道什么原因。

执行recover就报错:

RMAN> recover pluggable database pdb until sequence 20 auxiliary destination='/u01/recover';

Starting recover at 12-APR-23
Segmentation fault (core dumped)

暂无图片 评论
暂无图片 有用 0
打赏 0
回答交流
Markdown


请输入正文
提交
相关推荐
有sqlite 转oracle的工具吗?
回答 1
已采纳
试试NavicatPremium
Oracle数据库怎样通过逻辑读判断一个SQL还存在较大优化空间?
回答 3
已采纳
如果SQL的逻辑读远远大于SQL语句中的所有表的段大小之和(假设所有表都走全表扫描,表关联方式为HASHJOIN),那么该SQL就存在较大优化空间。
请教个问题,Oracle-Linux-7.9能否支持Oracle-19c的ACFS文件系统?
回答 2
肯定支持,https://www.modb.pro/db/1705457603992178688
awrsqrpt可以分析 超过2000字符的sql吗?
回答 1
BEGINDBMSOUTPUT.ENABLE(BUFFERSIZE&gt;NULL);END;/
Oracle数据库登录页面出现 initialization error 报错怎么解决?
回答 2
已采纳
win10使用plsql登录的吧?要么换成Oracle的sqldev要么安装Oracle的客户端就好了。
请教个问题。 tns配置里的service_name,这玩意是跟哪里对应的。一直想不通
回答 3
一个数据库和相应的一些名字oracle相关名字dbnamedbuniquenameglobalnameinstancenameservicenameDBNAME:建立时候指定,记录在控制文件中,不容易
oracle中文讲解巨作
回答 1
已采纳
OracleDatabase11g&amp;MySQL5.6开发手册[OracleDatabase11g&amp;MySQL5.6Handbook]中文版,而且是官方出版
19.4 row cache mutex / pin S wait on X 大量CPU阻塞
回答 6
有得解释是,21C以后版本解决游标问题,或者更新最新补丁试试;https://www.modb.pro/doc/21113
centos7安装oracle10g 报错:7978段错误
回答 1
已采纳
1.检查安装介质和你的操作系统是否适配。2.检查环境变量。3.检查runInstaller文件47行前后内容。
OGG异构DDL同步
回答 3
已采纳
Oracle到oracle是可以的。异构由于字段类型差异等。即使将来都不能支持。异构就停复制再做吧。