- 主库 expdp 导出作业
- 备库 impdp 导入作业- 排错命令集
- 排错命令集
- 闪回空间查询及调整
- 开启或关闭归档模式
- RMAN 删除归档、调整闪回区大小
- expdp/Impdp状态查看及中断方法
### 主库 expdp 导出作业
[oracle@M ~]$ ls -l /data/expdata
[oracle@M ~]$ sqlplus system/syspwd
SQL> -- drop directory expdata;
SQL> select * from dba_directories;
SQL> create directory expdata as '/data/expdata';
### 历史库需将 readonly 改为读写 状态,步骤:先关闭DB-->启动到mount--打开DB后改为 read write
SQL> shutdown immediate
SQL> startup mount
SQL> alter database open read write;
#导出主库 tablespace 清单,用之手动创建备库上的tablespace
SQL> select * from dba_data_files order by tablespace_name ;
SQL> select 'create tablespace ' || tablespace_name || ' datafile ''/data/oradata/DB6SFCHIS/datafile/' || tablespace_name || '01.dbf'' size 1G autoextend on next 50M maxsize unlimited;' from dba_data_files order by tablespace_name ;
#导出主库用户帐号,用之手动在备库上创建 用户,重复则创建无效
SQL> select Username,default_tablespace from dba_users order by Username;
SQL> select 'create user ' || username || ' identified by ' || username || ' default tablespace ' || default_tablespac