Phoenix_99的专栏

1.备份文件 define fil=/home/oracle/cdbk.sql define log=/home/oracle/cdbk.log spool &fil prompt connet sys/sysdba@asmdemo as sysdba; prompt shutdown immediate; select 'host cp ' || file_name|| '/u01/

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                                  *

1.rm -f system01.dbf   2.关闭数据库报错 SQL> shutdown immediate ORA-01116: error in opening database file 1 ORA-01110: data file 1: '/u01/app/oracle/oradata/demo/system01.dbf' ORA-27041: unable to open

1.删除redo log rm -f redo*   2.验证 alter database checkpoint; alter system switch logfile;   3.关闭数据库，启动到mount状态，生成控制文件 SQL> alter database backup controlfile to trace;   查看id号码 ps -ef oracle

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 file ORA-00202: control f