数据库在Open状态下，如何使用RMAN进行全备？

1、登陆

View Code

[oracle@DG1 ubackup]$ rman target sys/oracle@db200 nocatalog

Recovery Manager: Release 11.2.0.1.0 - Production on Wed Mar 27 18:22:10 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: POLI (DBID=3718810889)
using target database control file instead of recovery catalog

2、执行备份

View Code

RMAN> backup database format '/u01/ubackup/wb_%U';

Starting backup at 27-MAR-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=132 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/oradata/md/system01.dbf
input datafile file number=00002 name=/u01/oradata/md/sysaux01.dbf
input datafile file number=00005 name=/u01/oradata/md/example01.dbf
input datafile file number=00006 name=/u01/oradata/md/app1_01.dbf
input datafile file number=00003 name=/u01/oradata/md/undotbs01.dbf
input datafile file number=00004 name=/u01/oradata/md/users01.dbf
input datafile file number=00007 name=/u01/oradata/md/app2_01.dbf
channel ORA_DISK_1: starting piece 1 at 27-MAR-13
channel ORA_DISK_1: finished piece 1 at 27-MAR-13
piece handle=/u01/ubackup/wb_21o5jh40_1_1 tag=TAG20130327T182255 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:03:34
Finished backup at 27-MAR-13

Starting Control File and SPFILE Autobackup at 27-MAR-13
piece handle=/u01/flash_recovery_area/POLI/autobackup/2013_03_27/o1_mf_s_811189591_8o5lbstv_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 27-MAR-13

3、备份完成后，将当前的日志进行归档

View Code

RMAN> sql 'alter system archive log current';

sql statement: alter system archive log current

优质内容筛选与推荐>>
1、收藏个股（长期看好）
2、linux内核学习---as86语法
3、PHP XML DOM
4、darts.h注释 - 滴水穿石 - 歪酷博客 Ycool Blog
5、我再也不-或许永远不-用zend studio-受够了!

0 │ 收藏 │ 举报

朋友将在看一看看到

分享想法到看一看