当参数文件丢失后,任何利用RMAN回复
1、startup nomount
2、set dbid 1239541193(dbid可到v$database中查找)
3、restore spfile from autobackup(autobackup 指命令会去自己寻找备份的目录中,是否有备份的spfile。如果不是在设置的备份目录中则:restore spfile from ‘/u01/xx.bak’
4、shutdown immediate
5、startup
Controlfile 丢失,利用RMAN恢复
1、startup nomount
1. restore controlfile from autobackup(autobackup 指命令会去自己寻找备份的目录中,是否有备份的controlfile。如果不是在设置的备份目录中则:restore controlfile from ‘/u01/xx.bak’
2. alter database mount;
3. recover database;
4. alter database open resetlogs;
redolog file 丢失,利用RMAN恢复
1、shutdown immediate
2、startup mount;
3、recover database until cancel;(restore archivelog all)
4、alter database open resetlogs;
表空间恢复
1、sql “alter tablespace tablespacename offline immediate”
2、restore tablespace tablespacename;
3、recove tablespace tablespacename;
4、sql”alter tablespace tablespacename online”
datafile 丢失,恢复
1、sql “alter database datafile fileid offline”
2、restore datafile fileid
3、recover datafile fileid
4、sql “alter database datafiel fileid online”
把数据文件拷贝成多份
backup copies 2( 拷贝份数 ) datafile fileid format ‘/u01/b1/copy_%u’, ‘/u01/b1/copy_%u’来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23861776/viewspace-664552/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23861776/viewspace-664552/