|
|
[oracle@oracle ~]$ rman target /. O3 ~1 S3 x1 R2 t9 _+ H; g7 y
RMAN> backup current controlfile;
1 [: C( U) b) V& a/u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_01_13/o1_mf_ncnnf_TAG20140113T112837_9f6qcg2z_.bkp 这是位置6 J7 N3 T7 v$ X+ I+ r
! K% z3 I8 L6 t, e6 s- r
RMAN> backup database include current controlfile; 也可以这种方式% D+ F; o& h6 |7 z7 ~. Q- H
. w) ]1 t+ n& m0 S* `# O
RMAN> show all; 备份文件配置查看，可以用show all0 S* v, Y% r, Y [/ w4 N7 A
% @2 h- T" x V) Z% O
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP on; 设置为自动备份; e& v& ^ b* S1 N* n
0 m( F f+ C. @! N1 x" n9 B
; i+ g x2 _" S, I2 Y% DSQL> desc v$database 查询下视图
1 u d! i. A) j; I- k" a8 Z9 u9 e" k; l8 g: C( z9 i
SQL> select archivelog_change# from v$database;- c( [- i3 a5 d
2 @, v8 _/ E# m* K9 g, hARCHIVELOG_CHANGE#
: @9 o. [- |7 m, C------------------$ y( J, ]- v, A; K; c
1957735
' n* r5 m+ d) N* q: G# O+ k |, E4 h
SQL> select userenv('language') from dual;
7 J# j: O, \' @9 e9 t7 U: `9 U, e: Z |
|
发表于 2018-10-10 21:03:16