不诉离殇的博客

SQL>show parameter controlrman target /RMAN>shutdown immediate;RMAN>set dbid=xxx;RMAN>startup force nomount;RMAN>restore controlfile from '/backups/CF_xxx';RMAN>alter database mount;RMAN>recover database;RMAN>alter d

rman target /RMAN>shutdown immediate;RMAN>set dbid=xxx;RMAN>startup force nomount;RMAN>restore spfile from '/rmanbackups/SP_xxx_xxx';RMAN>startup;1.如果rman没有备份，并且数据库还在运行。create spfile ='/tmp/spfile.ora' from memory;2.如果数据库关闭

利用oracle闪回特性：create table table_bak as select * from table as of timestamp to_timestamp ('2021-01-01 00:00:00' , 'YYYY-MM-DD HH24:MI:SS'）;然后从回复表向原表插入数据。

利用表空间的recycle特性（默认开启），show parameter recycle查看。1.查看recyclebin里被删除的表：select original_name,object_name from recyclebin ;2.恢复：flashback table “***” to before drop‘；