oracle备份恢复

select dbms_flashback.get_system_change_number from dual;

select sequence#,first_change#,next_change# from v$archived_log;

alter tablespace users offline;

alter tablespace users online;

alter system switch logfile;

select file#,checkpoint_change# from v$datafile;

select file#,checkpoint_change# from v$datafile_header;

alter system checkpoint;

recover datafile 4;

alter tablespace users begin backup;

select *from v$backup;

alter tablespace users end backup;

alter database begin backup;

alter database end backup;

recover database until cancel;

recover database until change 8035082;

alter database open resetlogs;

alter database drop logfile group 2;

alter database add logfile group 2 'D:\APP\MAXINE\ORADATA\SMART\LOG\REDO02.LOG' size 50m;

recover database using backup controlfile;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29622945/viewspace-1392007/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29622945/viewspace-1392007/