-
编辑 删除
oracle 9i 系统空间很有限的情况下的迁移
[系统空间]select'CONFIGURE EXCLUDE FOR TABLESPACE 'name' ;'fromwherenamenotin'SYSTEM''TEMP'selectfrom--2 backup database and copy it to others tag format ;backupdatafile23456789--4 backup switch logfile more then 5 times ; 几次 恢复执行--5 backup controfile format ;--1 startup nomount--2 restore controlfile ;restoredatabase--4 copy other logrecoverdatabase--6 open database resetlogs ;[@more@]n
-
编辑 删除
坏块的处理思维（用程序制作坏块不如用系统）
--linux模拟坏块测试select * from dba_data_files;create table dd as select * from dictalter table dd move tablespace lihjtestselect dbms_rowid.rowid_relative_fno(t.rowid) || '_' || dbms_rowid.rowid_block_number(t.rowid), t.* from dd t; --1 mv lihjtest.dbf lihjtest.dbfbak dd if=lihjtest.dbfbak of=lihjtest.dbf bs=8192 count=70 --复制70个块 dd if=lihjtest.dbfbak of=lihjtest.dbf bs=8192 skip=69 count=1 seek=70 --复制第70个块到71块上 dd if=lihjtest.dbfbak of=lihjtest.dbf bs=8192 s
