Oracle数据库基于用户管理的备份与恢复

数据复制SQL> conn evan/evan   Connected.   SQL> insert into t_evan values(oracle);   1 row created.   SQL> insert into t_evan values(java);   1 row created.   SQL> commit;   Commit complete.   SQL> select * from t_evan;   TEXT   --------------------------------------------------------------------------------   oracle   java   --sysdba执行备份   SQL> conn / as sysdba   Connected.   SQL> select name from v$datafile;   NAME   --------------------------------------------------------------------------------   /oracle/10g/oracle/product/10.2.0/oradata/oralife/system01.dbf   /oracle/10g/oracle/product/10.2.0/oradata/oralife/undotbs01.dbf   /oracle/10g/oracle/product/10.2.0/oradata/oralife/sysaux01.dbf   /oracle/10g/oracle/product/10.2.0/oradata/oralife/users01.dbf   /oracle/10g/oracle/product/10.2.0/oradata/oralife/example01.dbf   SQL> alter database begin backup;   Database altered.   SQL> host cp /oracle/10g/oracle/product/10.2.0/oradata/oralife/*.dbf /oracle/10g/oracle/bakup/database/   --备份所有数据文件   SQL> alter database backup controlfile to /oracle/10g/oracle/bakup/database/oralife.ctl;  --备份控制文件   Database altered.   -----------------------------------------------------------------------------------------------------------------------------------------   忘记了alter database end backup;   -----------------------------------------------------------------------------------------------------------------------------------------   SQL> alter system archive log current; --归档当前日志组   System altered.  1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56.57.58.59.60.61.62.63.64.65.66.67.

本文地址：http://www.bzuk.cn/news/356b7899565.html