rman 备份

admin

[oracle@oracle ~]$ rman target /
9 y% w! G; J) i! W4 f7 O! KRMAN> backup current controlfile;
/u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_01_13/o1_mf_ncnnf_TAG20140113T112837_9f6qcg2z_.bkp   这是位置
" m  h) u- n0 V" ~7 @- y
RMAN> backup database include current controlfile;  也可以这种方式
5 ^( f& j( y* g1 L
; n0 E8 W8 r4 F% S* e4 c- x RMAN> show all;   备份文件配置查看，可以用show all
' I) W. T: H* O" B6 D2 m+ l
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP on;  设置为自动备份

   
SQL> desc v$database     查询下视图

SQL> select archivelog_change# from v$database;
# ?- e2 r/ z. Q- k. _7 M' u7 M0 M3 x
, r0 n. }/ v) G  ~0 o% |ARCHIVELOG_CHANGE#
------------------
           1957735
& w4 p/ w* Z+ V- [- p
( k1 L( S/ a5 _( v; _! T5 TSQL> select userenv('language') from dual;