![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle备份
文章平均质量分 53
Phoenix_99
这个作者很懒,什么都没留下…
展开
-
oracle冷备----删除非系统表空间
1.备份文件define fil=/home/oracle/cdbk.sqldefine log=/home/oracle/cdbk.logspool &filprompt connet sys/sysdba@asmdemo as sysdba;prompt shutdown immediate;select 'host cp ' || file_name|| '/u01/原创 2011-11-01 21:49:07 · 862 阅读 · 0 评论 -
冷备份-----删除Undo表空间
1.删除undo表空间rm -f undotbs01.dbf 2.报错SQL> create table t3 as select * from dba_objects where rownum create table t3 as select * from dba_objects where rownum *原创 2011-11-01 23:07:55 · 350 阅读 · 0 评论 -
冷备份----删除系统表空间
1.rm -f system01.dbf 2.关闭数据库报错SQL> shutdown immediateORA-01116: error in opening database file 1ORA-01110: data file 1: '/u01/app/oracle/oradata/demo/system01.dbf'ORA-27041: unable to open原创 2011-11-01 22:26:36 · 409 阅读 · 0 评论 -
冷备份删除redo log
1.删除redo logrm -f redo* 2.验证alter database checkpoint;alter system switch logfile; 3.关闭数据库,启动到mount状态,生成控制文件SQL> alter database backup controlfile to trace; 查看id号码ps -eforacle原创 2011-12-14 22:17:23 · 432 阅读 · 0 评论 -
冷备份---删除控制文件
1.删除控制文件rm -f control0* 2.验证SQL> select * from v$datafile;select * from v$datafile *ERROR at line 1:ORA-00210: cannot open the specified control fileORA-00202: control f原创 2011-12-14 23:00:35 · 600 阅读 · 0 评论