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博客

oracle备份恢复

最新文章