Oracle热备份只读表空间

1.修改表空间为只读表空间

SQL> alter tablespace users read only;

2.备份表空间
SQL> !cp /u01/app/Oracle/oradata/demo1/users01.dbf /tmp

3.恢复表空间

SQL> alter tablespace users read write;

4.备份控制文件

SQL> alter database backup controlfile to '/tmp/ctlfile.ctl';

或

SQL> alter database backup controlfile to trace as '/tmp/ctl.sql';