数据库安装及数据库问题解决（六）

数据库文件丢失，找不回来了
只能数据库启动到mount状态
startup mount
alter database datafile 11 offline for drop;
alter database open; 
备份控制文件为文本文件
alter database backup controlfile to trace as '/opt/oracle/345.ora';
alter database backup controlfile to trace as '/opt/oracle/222.ora' reuse noresetlogs;
-------------------------------------------------------------------------------------
ORA-00257: archiver error. Connect internal only, until freed.
归档表空间已经满了，可以改初始化参数db_recovery_file_dest_size 改得大一点
-----------------------------------------------------------------------------------------
看执行计划 http://www.itpub.net/forum.php?mod=viewthread&tid=48185
改 oracle@/opt/oracle$提示符：export PS1='$(whoami)@$PWD$'