UNDOTBS01.DBF,是表空间文件,主要就是为了undo,即撤销、回滚,只要有DML操作等,就会产生undo数据,久而久之会变得非常大,占用大量磁盘空间。...1、创建一个新的小空间的undo tablespace** create undo tablespace undotBS2 datafile 'C:\Oracle\oradata\oracle\undotbs02....dbf' size 500m; 2、设置新的表空间为系统undo_tablespace** alter system set undo_tablespace=undotBS2; 3、删除旧的表空间**...drop tablespace undotbs1 including contents; 其他方法 禁止undo tablespace自动增长 alter database datafile 'C:...C:\Oracle\oradata\oracle\undotbs01.dbf' resize 1g;
Disconnection forced 2、故障分析 #下面是alert 日志信息 #我们收到了错误提示: ORA-30012,UNDOTBS1不存在或者类型错误 Wed Apr 23 10:19:...Database 10g Release 10.2.0.5.0 - 64bit Production ORACLE_HOME = /users/oracle/OraHome10g System name: Linux...' does not exist or of wrong type #也是undo相关的问题,UNDOTBS1不存在或者类型错误 #也就是说undo参数没有正确的设置 3、故障解决 SQL> startup...=86400 #undo_retention=172800 --数据字典中记录的undo信息,没有undotbs1,这就是问题所在 SQL> select name from v$tablespace...where name like '%UNDO%'; NAME ------------------------------ UNDOTBS2 UNDOTBS --下面查看undo对应的数据文件,有
: linux1 GSD is running on node: linux1 Listener is running on node: linux1 ONS daemon is running...on node: linux1 ASM 实例的状态 $ srvctl status asm -n linux1 ASM instance +ASM1 is running on node linux1...datafile/sysaux.260.570913287 +ORCL_DATA1/orcl/datafile/system.262.570913215 +ORCL_DATA1/orcl/datafile/undotbs1.261.570913263...+ORCL_DATA1/orcl/datafile/undotbs1.271.570920865 +ORCL_DATA1/orcl/datafile/undotbs2.265.570913331...+ORCL_DATA1/orcl/datafile/undotbs2.272.570921065 +ORCL_DATA1/orcl/datafile/users.264.570913355 +ORCL_DATA1
: linux1 GSD is running on node: linux1 Listener is running on node: linux1 ONS daemon is running on...node: linux1 ASM 实例的状态 $ srvctl status asm -n linux1 ASM instance +ASM1 is running on node linux1....datafile/sysaux.260.570913287 +ORCL_DATA1/orcl/datafile/system.262.570913215 +ORCL_DATA1/orcl/datafile/undotbs1.261.570913263...+ORCL_DATA1/orcl/datafile/undotbs1.271.570920865 +ORCL_DATA1/orcl/datafile/undotbs2.265.570913331 +ORCL_DATA1.../orcl/datafile/undotbs2.272.570921065 +ORCL_DATA1/orcl/datafile/users.264.570913355 +ORCL_DATA1/orcl/
Release 10.2.0.1.0 - Prod PL/SQL Release 10.2.0.1.0 - Production CORE 10.2.0.1.0 Production TNS for Linux...OFFLINE _SYSSMU2$ UNDOTBS1 OFFLINE _SYSSMU3$ UNDOTBS1 OFFLINE _SYSSMU4$ UNDOTBS1 OFFLINE _SYSSMU5...$ UNDOTBS1 OFFLINE _SYSSMU6$ UNDOTBS1 OFFLINE _SYSSMU7$ UNDOTBS1 OFFLINE _SYSSMU8$ UNDOTBS1 OFFLINE...ONLINE _SYSSMU2$ UNDOTBS1 ONLINE _SYSSMU3$ UNDOTBS1 ONLINE _SYSSMU4$ UNDOTBS1 ONLINE _SYSSMU5$...UNDOTBS1 ONLINE _SYSSMU6$ UNDOTBS1 ONLINE _SYSSMU7$ UNDOTBS1 ONLINE _SYSSMU8$ UNDOTBS1 ONLINE _SYSSMU9
app/oracle/product/11.2.0/dbhome_1/dbs/] ORA-48187: specified directory does not exist Linux...db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux...oradata/orcl/redo01a.log' - file cannot be created ORA-27040: file create error, unable to create file Linux...初期化参数是UNDOTBS1,但是Create database文却是UNDOTBS。...UNDO TABLESPACE UNDOTBS DATAFILE '/u01/app/oracle/oradata/orcl/undotbs01.dbf' CREATE DATABASE
11.2.0.3.0 - 64bit Production PL/SQL Release 11.2.0.3.0 - Production CORE 11.2.0.3.0 Production TNS for Linux...5 345 EXAMPLE *** +DATA/orclasm/datafile/example.265.850260295 6 5 UNDOTBS2 *** +DATA/orclasm/datafile.../undotbs2.267.851204361 7 50 TBS_RC *** +DATA/orclasm/datafile/tbs_rc.268.852116523 8 100 TS_LHR **.../undotbs2.267.851204361 7 50 TBS_RC *** +DATA/orclasm/datafile/tbs_rc.268.852116523 8 100 TS_LHR **.../undotbs2.267.851204361 7 50 TBS_RC *** +DATA/orclasm/datafile/tbs_rc.268.852116523 8 100 TS_LHR **
说明:此环境为 Linux CentOS6.7 Oracle11.2.0.4 0、检查发现根目录 100% TEST:/home/oracle$df -h df: `/root/.gvfs': Permission....dbf 3 UNDOTBS1 30 /app/oracle/oradata/JiekeXutest/users01....dbf' to '/testdata/app/oracle/oradata/JiekeXutest/undotbs01.dbf'; alter database rename file '/app/oracle...01110: data file 6: '/app/product/11.2.0/db/dbs/D:test.ora' ORA-27037: unable to obtain file status Linux-x86....db 3 UNDOTBS1 30 f /testdata/app/oracle/oradata/JiekeXutest
@linux4 admin]$ tnsping AUX e、实施数据库克隆 [oracle@linux4 ~]$ export ORACLE_SID=sybo3 [oracle@linux4 ~]$...database/sybo3/oradata/sysaux01.dbf" datafile 3 auxiliary format "/u01/database/sybo3/oradata/undotbs01....dbf output file name=/u01/database/sybo3/oradata/undotbs01.dbf tag=TAG20130802T114457 channel ORA_DISK...to datafile copy input datafile copy RECID=7 STAMP=822397596 file name=/u01/database/sybo3/oradata/undotbs01...RECID=1 STAMP=822397612 cataloged datafile copy datafile copy file name=/u01/database/sybo3/oradata/undotbs01
database]$ cat /etc/issue Enterprise Linux Enterprise Linux Server release 5.5 (Carthage) Kernel...374341632 *.open_cursors=300 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.undo_tablespace='UNDOTBS1...oradata/sysaux01.dbf channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/database/sybo3/oradata/undotbs01...to datafile copy input datafile copy RECID=3 STAMP=822223969 file name=/u01/database/sybo3/oradata/undotbs01...RECID=1 STAMP=822223994 cataloged datafile copy datafile copy file name=/u01/database/sybo3/oradata/undotbs01
64bit Production PL/SQL Release 11.2.0.4.0 - Production CORE 11.2.0.4.0 Production TNS for Linux...---------------------------------- USERS /u01/app/oracle11/oradata/chendb/users01.dbf UNDOTBS1... /u01/app/oracle11/oradata/chendb/undotbs01.dbf SYSAUX /u01/app/oracle11/oradata... 3 /u01/app/oracle11/oradata/chendb/undotbs01.dbf USERS 4 /u01/app/oracle11...found ORA-01110: data file 7: '/home/oracle/cjctbs02.dbf' ORA-27037: unable to obtain file status Linux-x86
=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib 2、创建参数文件(位置:$ORACLE_HOME/dbs) [oracle@linux1...dbs]$ export ORACLE_SID=catadb [oracle@linux1 ~]$ cd $ORACLE_HOME/dbs [oracle@linux1 dbs]$ grep -v...TCP) (SERVICE=ORCLXDB)' open_cursors=300 remote_login_passwordfile='EXCLUSIVE' undo_tablespace='UNDOTBS1...~]$ mkdir -p /u03/uat/catadb [oracle@linux1 dbs]$ cd /u03/uat/catadb [oracle@linux1 catadb]$ mkdir...default tablespace user datafile '/u03/uat/catadb/oradata/userdata.dbf' size 100m undo tablespace undotbs1
undotbs2 goex_admin@CICCFIX> alter system set undo_tablespace='UNDOTBS2' scope=both; -->注,如果使用了pfile..._SYSSMU10$ UNDOTBS 131072 / 2 / 32765 OFFLINE 3,276,800 5 PUBLIC...._SYSSMU21$ UNDOTBS 131072 / 2 / 32765 OFFLINE 4,325,376 6 PUBLIC...._SYSSMU22$ UNDOTBS 131072 / 2 / 32765 OFFLINE 20,054,016 21 PUBLIC...._SYSSMU3$ UNDOTBS 131072 / 2 / 32765 OFFLINE 4,325,376 6 PUBLIC.
墨墨导读:本文来自墨天轮用户“你好我是李白”的投稿,记录一个Oracle数据库迁移过程 :异构传输表空间TTS HP-UX迁移至Redhat Linux 7.7。...环境准备 2.1 挂载NFS 源库30TB,HP-UX与Linux通过NFS挂载目标库NAS存储磁盘,直接convert转换数据文件至最终NAS存储,省去拷贝时间。...hard,bg,proto=tcp,rsize=32768,wsize=32768,nointr,noac,forcedirectio,llock xx.xx.xx.xx:/data/nfs /tts Linux...--------- -------------- ... 4 HP-UX IA (64-bit) Big ... 13 Linux...v_date}.log <<EOF run{ allocate channel c1 type disk; ... convert tablespace tbs1,tbs2... to platform 'Linux
.dbf' to '/u01/app/db/oradata/STDBY/datafile/o1_mf_undotbs2_88z27mbc_.dbf' dgcreate.DGrenameFiles: SELECT...STATUS FROM V$DATAFILE WHERE NAME = '/u01/app/oracle/oradata/disk_4/undotbs2.dbf' dgcreate.DGrenameFiles...|/u01/app/oracle/oradata/disk_5/undotbs01.dbf|YES|200M|65536||LOCAL|MANUAL|NO SYSTEM|/u01/app/oracle/...01110: data file 10: '/u01/app/oracle/oradata/disk_5/indx.dbf ' ORA-27037: unable to obtain file status Linux...01110: data file 10: '/u01/app/oracle/oradata/disk_5/indx.dbf ' ORA-27037: unable to obtain file status Linux
具体如下: 2.2.1 创建新的undo表空间undotbs2并设置为默认的undo表空间 SQL> create undo tablespace undotbs2; Tablespace created...2.2.2 删除旧的undotbs1表空间失败 SQL> drop tablespace undotbs1 including contents and datafiles; drop tablespace...NEEDS RECOVERY UNDOTBS1 4 _SYSSMU4_1640924022$ NEEDS RECOVERY UNDOTBS1...NEEDS RECOVERY UNDOTBS1 7 _SYSSMU7_387283697$ NEEDS RECOVERY UNDOTBS1...NEEDS RECOVERY UNDOTBS1 10 _SYSSMU10_1695440836$ NEEDS RECOVERY UNDOTBS1 10 rows
database]$ cat /etc/issue Enterprise Linux Enterprise Linux Server release 5.5 (Carthage) Kernel \r...374341632 *.open_cursors=300 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.undo_tablespace='UNDOTBS1...sysaux01.dbf'; 4> set newname for datafile 3 to '/u01/database/sybo5/oradata/undotbs01...to datafile copy input datafile copy RECID=9 STAMP=821716491 file name=/u01/database/sybo5/oradata/undotbs01...RECID=1 STAMP=821716521 cataloged datafile copy datafile copy file name=/u01/database/sybo5/oradata/undotbs01
47.9354248 .064575195 48 .134531657 可以看到,UNDOTBS1大小181G,UNDOTBS2大小48G。...undo表空间迁移到闪存: create undo tablespace UNDOTBS11 datafile '/flash/oradata/jydb5/undotbs101.dbf' SIZE 30G...undotbs11 add datafile '/flash/oradata/jydb5/undotbs102.dbf' SIZE 30G; alter tablespace undotbs11 add.../undotbs105.dbf' SIZE 30G; alter tablespace undotbs11 add datafile '/flash/oradata/jydb5/undotbs106.dbf...' SIZE 31G; alter tablespace undotbs21 add datafile '/flash/oradata/jydb5/undotbs202.dbf' SIZE 24G;
---------- ---------- ---------- ---------- ---------- --------- SYS _SYSSMU3_1723003836$ UNDOTBS1...---------- ---------- ---------- ---------- ---------- --------- SYS _SYSSMU3_1723003836$ UNDOTBS1...SQL> alter tablespace undotbs1 retention guarantee; Tablespace altered. 而这个部分的测试结果还是和之前没有差别。...SQL> select tablespace_name,contents,retention from dba_tablespaces where tablespace_name like '%UNDOTBS....dbf YES 275 UNDOTBS1 SQL> alter database datafile '/DATA/app/oracle/oradata/test11g/undotbs01
STANDBY LOGFILE DATAFILE '/oradata/orcl/system01.dbf', '/oradata/orcl/sysaux01.dbf', '/oradata/orcl/undotbs01...control file: '/u01/app/oracle/fast_recovery_area/orcl/control02.ctl' ORA-27041: unable to open file Linux-x86...control file ORA-00202: control file: '/oradata/orcl/control01.ctl' ORA-27041: unable to open file Linux-x86...control file ORA-00202: control file: '/oradata/orcl/control01.ctl' ORA-27041: unable to open file Linux-x86...control file ORA-00202: control file: '/oradata/orcl/control01.ctl' ORA-27041: unable to open file Linux-x86
领取专属 10元无门槛券
手把手带您无忧上云