怎样联机备份表空间

Question

现在要联机备份表空间users，具体该怎么操作呢？

Answer 1

SQL> archive log list;
数据库日志模式             非存档模式
自动存档             禁用
存档终点            USE_DB_RECOVERY_FILE_DEST
最早的联机日志序列     3
当前日志序列           5
SQL> shutdown;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup mount pfile='E:\oracle\product\10.2.0\db_1\admin\orcl\pfile\init.ora.4172009132728';
ORACLE 例程已经启动。Total System Global Area  293601280 bytes                                       
Fixed Size                  1248600 bytes                                       
Variable Size              92275368 bytes                                       
Database Buffers          192937984 bytes                                       
Redo Buffers                7139328 bytes                                       
数据库装载完毕。
SQL>alter database archivelog;数据库已更改。SQL>conn sys/admin@orcl as sysdba;
已连接。SQL> archive log list;
数据库日志模式            存档模式
自动存档             启用
存档终点            USE_DB_RECOVERY_FILE_DEST
最早的联机日志序列     3
下一个存档日志序列   5
当前日志序列           5SQL> select file_name,tablespace_name from dba_data_files;FILE_NAME                                                                       
--------------------------------------------------------------------------------
TABLESPACE_NAME                                                                 
------------------------------                                                  
E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF                               
USERS                                                                           
                                                                                
E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF                              
SYSAUX                                                                          
                                                                                
E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF                             
UNDOTBS1                                                                        
                                                                                FILE_NAME                                                                       
--------------------------------------------------------------------------------
TABLESPACE_NAME                                                                 
------------------------------                                                  
E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF                              
SYSTEM                                                                          
                                                                                
E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF                             
EXAMPLE                                                                         
                                                                                SQL> alter tablespace users begin backup;表空间已更改。SQL> host copy E:\oracle\product\10.2.0\oradata\orcl\USERS01.dbf C:\oracle\backup\users01.dbf;SQL> alter tablespace users end backup;表空间已更改。