conn / as sysdba
4、shutdown immediate
startup mount;
alter database flashback off
alter database archivelog;
alter database open;
再次正常关闭数据库,并备份所有的数据文件和控制文件。
archive log list;
5、select tablespace_name, file_name from dba_data_files order by tablespace_name;
alter tablespace users begin backup;
alter tablespace users end backup;
alter dataspace backup controlfile to 'D:\app\Administrator\oradata\orcl\control1.bkp';
alter database backup controlfile to trace;
alter system archive log current;
alter system switch logfile;
6、create table hot(id number primary key) tablespace users;
insert into hot values(93);
7、
https://wenku.baidu.com/view/ff2bd901f011f18583d049649b6648d7c1c70898.html