数据库恢复步骤.docx

一、完全恢复数据文件笔记：进入oracle 数据库的RMAN 环境中，在系统的命令窗口输入下面的命令：# rman target /查看该数据库是否有备份# list backup summary;进入到Oracle 数据库的数据文件目录，输入#sqlplus/as sysdba#shutdown immediate当系统中缺少某个数据文件找不到时，强制关闭数据库：# shutdown abort#startup#rman target/RMANrestore database;#lsRMANrecover database ;RMANsql ‘alter database open’;Exit#sqlplus /as sysdba查看数据库实例状态是否为open 状态#select instance_name,status from v$instance;#archive log list;二、不完全恢复之重做日志损坏的恢复笔记：# rman target /# list backup summary;#sqlplus/as sysdba切换Oracle 数据库的重做日志#alter system switch logfile;#shutdown immediate#startup#recover database until cancel;#ls#alter database open resetlogs;#archive log list;三、不完全恢复之控制文件数据损坏的恢复笔记：# rman target /#list backup#sqlplus/as sysdba尝试查询表的数据是否出错# select count(*) from backupuser.emp#shutdown abort#startup查询数据库实例状态# select instance_name, status from V$instance;设置环境变量#export oracle_sid=PRD# rman target /RMANrestore controlfile from autobackup;RMANalter database mount;RMANrestore database;#ls#sqlplus / as sysdba#recover database using backup controlfile until cancel;打开数据库，并重新生成数据库的重做日志文件#alter database open resetlogs;#archive log list;四、不完全恢复之丢失初始化文件数据的恢复笔记：# rman target /#list backup#sqlplus /as sysdba#show parameter spfile#ls#rm spfileecpora丢失初始化文件，查询数据是否报错#sqlplus/as sysdba#select count(*) from bankuser.emp#shutdown abort#startup查询当前数据库状态#select instance_name,status from v$instance;恢复数据库初始化文件Export ORACLE_SID=ecp# rman target /先从备份文件中复制初始化文件spfile, 在目录、、/u01/app/oracle/admin/oms/pfile#sqlplus /as sysdba#startup pfile=’ /u01/app/oracle/admin/oms/pfile/initoraak#select instance_name,status from v$instance;#restore spfile from autobackup;查看spfile#ls –l spfileecp.ora#show parameter spfile当读取不到控制文件时# rman target /#Restore controlfile from autobackup;#alter database mount;#restore database;#sqlplus/as sysdba#recover database using backup controlfile until cancel;#alter database open resetlogs;#archive log list;五、不完全恢复之恢复到某个时间点数据的恢复笔记：设置时间格式#alter session set nls_data_format=’yyyymmdd hh24:mi:ss’;查看当前数据