|
|
[oracle@oracle ~]$ rman target /
# A. J5 Z# Q$ O2 h; f' HRMAN> backup current controlfile;
, i4 N: S" N; P4 K ~2 h+ z/u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_01_13/o1_mf_ncnnf_TAG20140113T112837_9f6qcg2z_.bkp 这是位置2 ~9 l j0 A# B2 b. _; [! v! f# f
* E5 m/ A _- l/ VRMAN> backup database include current controlfile; 也可以这种方式7 r1 ?8 Q& E: I( _4 z
3 U: k8 \3 y1 e, l RMAN> show all; 备份文件配置查看,可以用show all
P; ]" A; D% o* O) R
( R) M; S3 r8 B! z Q# ]8 IRMAN> CONFIGURE CONTROLFILE AUTOBACKUP on; 设置为自动备份
- V' T* s! J; H
: o0 I" R# H. L( a
7 K: s" L7 s T3 u0 L* I5 |& _SQL> desc v$database 查询下视图
) E/ v2 {. P8 S" F! ?+ @: s, r, c" M) P8 S! h
SQL> select archivelog_change# from v$database;- j% m/ L3 h1 d+ L& U
2 H9 W' X5 i- z# Y
ARCHIVELOG_CHANGE#1 ]5 x3 T; K; r' D; U
------------------! z- F3 `# I7 G% {/ {
1957735
& Q. v" N+ w+ k/ a; R: e3 x
/ H5 f. s# |% ~% SSQL> select userenv('language') from dual;: x( S6 N. {" D8 P# o$ P
|
|