|
|
[oracle@oracle ~]$ rman target /. P! M9 D& L7 X) {& @
RMAN> backup current controlfile;
1 @+ F3 `* f8 X! {' u/u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_01_13/o1_mf_ncnnf_TAG20140113T112837_9f6qcg2z_.bkp 这是位置
9 F, _) z/ c- j. t9 D, F) D+ t8 b0 K. _4 ~& P6 |1 j ?) k
RMAN> backup database include current controlfile; 也可以这种方式
& A" o3 U7 M. x o( h# C, b
4 p$ S, X- [, o5 }, {, T) G RMAN> show all; 备份文件配置查看，可以用show all5 D" i5 C, Z: }& V" q
3 x! `% |1 Y! T8 C/ `4 ZRMAN> CONFIGURE CONTROLFILE AUTOBACKUP on; 设置为自动备份8 t$ V- i, `7 d4 g) L* j2 p. g
6 r* v( ~+ e( d) O9 f
/ d( \6 @; I3 Q6 zSQL> desc v$database 查询下视图
" i) Y% L1 b4 |0 f$ T) a5 \
5 _5 t" h) z4 p7 a! ^9 ZSQL> select archivelog_change# from v$database;& u x+ O) `) x% c4 u3 g6 `
, t+ A6 }' ?* e, w- s, H* q/ CARCHIVELOG_CHANGE## ^+ K5 C9 P% `8 D4 P# O; z- v
------------------
" K+ V. W, |; e' E 1957735
/ W6 A s1 S" r9 I$ D9 q7 G: C% `6 n# i8 \
SQL> select userenv('language') from dual;
) V4 [3 [( L/ ]& Y* L+ i |
|
发表于 2018-10-10 21:03:16