重庆思庄Oracle、Redhat认证学习论坛

标题: oracle impdp卡死Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX [打印本页]

作者: mahan 时间: 2022-11-6 12:28
标题: oracle impdp卡死Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
今天在用impdp导入时，Processing bject type SCHEMA_EXPORT/TABLE/INDEX/INDEX卡在建索引的过程一直不动，也不报错

查看警告日志发现

Completed: alter tablespace USERS add datafile ‘/data/oradata/eas/user06.dbf‘ size 31g

Thu Apr 30 09:52:04 2020

statement in resumable session ‘SYSTEM.SYS_IMPORT_FULL_06.1‘ was resumed

Thu Apr 30 09:52:29 2020

Thread 1 cannot allocate new log, sequence 12255

Private strand flush not complete

Current log# 2 seq# 12254 mem# 0: /data/oradata/eas/redo02.log

Thread 1 advanced to log sequence 12255 (LGWR switch)

Current log# 3 seq# 12255 mem# 0: /data/oradata/eas/redo03.log

日志组被写满了，需要增加日志组:

SQL>select group#,sequence#,bytes,members,status from v$log; 查看每组日志的状态

GROUP# SEQUENCE# BYTES MEMBERS STATUS

---------- ---------- ---------- ---------- ----------------

1 16946 52428800 1 INACTIVE ## 空闲的

2 16947 52428800 1 INACTIVE ## 空闲的

3 16948 52428800 1 CURRENT ##正在使用的

增加日志组

1、alter database add logfile group 4 (‘/opt/oradata/orclbj/redo04.log‘) size 200M

alter database add logfile group 5 (‘/opt/oradata/orclbj/redo04.log‘) size 200M

2、alter system switch logfile; 多次切换日志组

然后把之前50M的日志组删除

1、alter database drop logfile group 1; #在线增加日志组的时候，删除日志组的时候只能删除日志组状态为 INACTIVE 的日志组。

alter database add logfile group 1 (‘/opt/oradata/orclbj/redo04.log‘) size 200M

alter database drop logfile group 2;

alter database add logfile group 2 (‘/opt/oradata/orclbj/redo04.log‘) size 200M

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)