数据库是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)
查看生产的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[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验证了下
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
墨值悬赏