Backup And Recovery User's Guide-從RMAN開始-備份處於非歸檔模式的資料庫

--一致資料庫備份

--0.使資料庫執行在非歸檔模式

--1.啟動RMAN連線到目標資料庫

[oracle@S1011:/export/home/oracle]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jul 4 13:07:44 2013

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

connected to target database: TESTDB11 (DBID=2578856066)

--2. 一致地關閉資料庫並且MOUNT資料庫（因為需要向控制檔案中寫RMAN記錄的資料）

RMAN> shutdown immediate

using target database control file instead of recovery catalog

database closed

database dismounted

Oracle instance shut down

RMAN> startup mount

connected to target database (not started)

Oracle instance started

database mounted

Total System Global Area     855982080 bytes

Fixed Size                     2230792 bytes

Variable Size                641730040 bytes

Database Buffers             209715200 bytes

Redo Buffers                   2306048 bytes

--3.備份資料庫到預設的備份裝置：RMAN> backup database;

--3.對資料庫中所有的資料檔案產生映象拷貝，備份到預設的備份裝置上

RMAN> backup as copy database;

Starting backup at 04-JUL-13

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=18 device type=DISK

channel ORA_DISK_1: starting datafile copy

input datafile file number=00001 name=/u01/app/oracle/oradata/TestDB11/system01.dbf

output file name=/u01/app/oracle/fast_recovery_area/TESTDB11/datafile/o1_mf_system_8xcn7o4s_.dbf tag=TAG20130704T144556 RECID=2 STAMP=819902826

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:16

channel ORA_DISK_1: starting datafile copy

input datafile file number=00002 name=/u01/app/oracle/oradata/TestDB11/sysaux01.dbf

output file name=/u01/app/oracle/fast_recovery_area/TESTDB11/datafile/o1_mf_sysaux_8xcnb0kw_.dbf tag=TAG20130704T144556 RECID=3 STAMP=819902892

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:05

channel ORA_DISK_1: starting datafile copy

input datafile file number=00005 name=/u01/app/oracle/oradata/TestDB11/example01.dbf

output file name=/u01/app/oracle/fast_recovery_area/TESTDB11/datafile/o1_mf_example_8xcnd1pr_.dbf tag=TAG20130704T144556 RECID=4 STAMP=819902919

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25

channel ORA_DISK_1: starting datafile copy

input datafile file number=00003 name=/u01/app/oracle/oradata/TestDB11/undotbs01.dbf

output file name=/u01/app/oracle/fast_recovery_area/TESTDB11/datafile/o1_mf_undotbs1_8xcndv33_.dbf tag=TAG20130704T144556 RECID=5 STAMP=819902974

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:55

channel ORA_DISK_1: starting datafile copy

input datafile file number=00004 name=/u01/app/oracle/oradata/TestDB11/users01.dbf

output file name=/u01/app/oracle/fast_recovery_area/TESTDB11/datafile/o1_mf_users_8xcngl78_.dbf tag=TAG20130704T144556 RECID=6 STAMP=819902979

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03

channel ORA_DISK_1: starting datafile copy

copying current control file

output file name=/u01/app/oracle/fast_recovery_area/TESTDB11/controlfile/o1_mf_TAG20130704T144556_8xcngodc_.ctl tag=TAG20130704T144556 RECID=7 STAMP=819902982

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

including current SPFILE in backup set

channel ORA_DISK_1: starting piece 1 at 04-JUL-13

channel ORA_DISK_1: finished piece 1 at 04-JUL-13

piece handle=/u01/app/oracle/fast_recovery_area/TESTDB11/backupset/2013_07_04/o1_mf_nnsnf_TAG20130704T144556_8xcngrjq_.bkp tag=TAG20130704T144556 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 04-JUL-13

--3.2 檢視快速恢復區中新產生的備份的檔案

[oracle@S1011:/u01/app/oracle/fast_recovery_area]$ ls -R

.:

TestDB11  TESTDB11

./TestDB11:

control02.ctl

./TESTDB11:

backupset    controlfile  datafile     onlinelog

./TESTDB11/backupset:

2013_07_04

./TESTDB11/backupset/2013_07_04:

o1_mf_nnsnf_TAG20130704T144556_8xcngrjq_.bkp

./TESTDB11/controlfile:

o1_mf_TAG20130704T144556_8xcngodc_.ctl

./TESTDB11/datafile:

o1_mf_example_8xcnd1pr_.dbf   o1_mf_sysaux_8xcnb0kw_.dbf    o1_mf_system_8xcn7o4s_.dbf    o1_mf_undotbs1_8xcndv33_.dbf  o1_mf_users_8xcngl78_.dbf

./TESTDB11/onlinelog:

--4.開啟資料庫

RMAN> alter database open;

database opened