【数据迁移初始化】impdp导入遇到的种种

使用impdp导入数据，
若是数据量不大，应该完全不需要考虑太多，直接干就是；
若数据量有点规模，那么下面这些可能会遇到，是要提前考虑的。

故障1： 归档日志切换不过来

要怎么解？加呗。。。

alter database add logfile group 9  '/mnt/vdd1/oradata/redo09.log' size 8192M;
alter database add logfile group 10 '/mnt/vdd1/oradata/redo10.log' size 8192M;
alter database add logfile group 11 '/mnt/vdd1/oradata/redo11.log' size 8192M;
alter database add logfile group 12 '/mnt/vdb1/oradata/redo12.log' size 8192M;
alter database add logfile group 13 '/mnt/vdb1/oradata/redo13.log' size 8192M;

PS：文件的大小、目录、数量按需；若有DG，要考虑更充分些，将standby log也加上

故障2：undo表空间爆满

ORA-39171: Job is experiencing a resumable wait.
ORA-30036: unable to extend segment by 8 in undo tablespace ‘UNDOTBS1’

statement in resumable session ‘SYS.SYS_IMPORT_FULL_03.12’ was suspended due to
ORA-30036: unable to extend segment by 8 in undo tablespace ‘UNDOTBS1’

要怎么解？加呗

alter tablespace undotbs1 add datafile 
'/mnt/vdb1/oradata/UNDOTBS1_5.dbf' size 512m  AUTOEXTEND ON NEXT 512M MAXSIZE 32767M,
'/mnt/vdb1/oradata/UNDOTBS1_6.dbf' size 512m  AUTOEXTEND ON NEXT 512M MAXSIZE 32767M,
'/mnt/vdb1/oradata/UNDOTBS1_7.dbf' size 512m  AUTOEXTEND ON NEXT 512M MAXSIZE 32767M;

故障3：临时表空间爆满

加 ！！！

ALTER TABLESPACE TEMP ADD TEMPFILE '/mnt/vdb1/temp02.dbf';

故障4：磁盘 100% 爆满（归档日志撑爆的）

Tue Jul 11 11:20:14 2023
ARC1: Encountered disk I/O error 19502
ARC1: Closing local archive destination LOG_ARCHIVE_DEST_1: '/mnt/vde1/archivelog/ARC0000451_055555.0001.arc' (error 19502) (orcl)
ARC1: I/O error 19502 archiving log 8 to '/mnt/vde1/archivelog/ARC0000451_055555.0001.arc'
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance orcl - Archival Error
ORA-16038: log 8 sequence# 451234 cannot be archived
ORA-19502: write error on file "", block number  (block size=)
ORA-00312: online log 8 thread 1: '/mnt/vdd1/oradata/redo08.log'
Archiver process freed from errors. No longer stopped

怎么办？扩容磁盘或者备份删除归档日志，腾空出来

1. 是否能停下来扩容，这是首先考虑的
2. rman备份归档文件，要考虑当前系统负载
3. 迁移到其他盘或删除（若实在不太需要的话），然后告诉oracle我磁盘有空间了

rman target /
crosschek archivelog all;
delete expired archivelog all;