[oracle@lax:db01]/home/oracle

$ rman @restore_tag_easy.rman

Recovery Manager: Release 11.2.0.3.0 - Production on Sun Sep 8 18:32:09 2013

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

RMAN> connect target;

2> configure controlfile autobackup on;

3> show all;

4> ########################################

5> # BACKUP USING TAG

6> ########################################

7> run{

8> allocate channel d1 device type disk;

9> backup incremental level 0 database tag 'BBB';

10> backup archivelog all delete input tag 'BBB';

11> release channel d1;

12> }

13> run{

14> allocate channel d2 device type disk;

15> startup force nomount;

16> set dbid 1452485914

17> restore controlfile from autobackup;

18> alter database mount;

19> restore database from tag 'BBB';

20> recover database;

21> alter database open resetlogs;

22> release channel d2;

23> }

24> exit

connected to target database: DB01 (DBID=1452485914)

using target database control file instead of recovery catalog

old RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP ON;

new RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP ON;

new RMAN configuration parameters are successfully stored

RMAN configuration parameters for database with db_unique_name LAX_DB01 are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0.3/db_1/dbs/snapcf_db01.f'; # default

allocated channel: d1

channel d1: SID=40 device type=DISK

Starting backup at 08-sep-2013 18:32:12

channel d1: starting incremental level 0 datafile backup set

channel d1: specifying datafile(s) in backup set

input datafile file number=00003 name=/oracle/oradata/LAX_DB01/datafile/o1_mf_undotbs_8ymzsr1w_.dbf

input datafile file number=00004 name=/oracle/oradata/LAX_DB01/datafile/o1_mf_user_dat_8yo8879m_.dbf

input datafile file number=00001 name=/oracle/oradata/LAX_DB01/datafile/o1_mf_system_8ymzrcgk_.dbf

input datafile file number=00002 name=/oracle/oradata/LAX_DB01/datafile/o1_mf_sysaux_8ymzrr20_.dbf

channel d1: starting piece 1 at 08-sep-2013 18:32:12

channel d1: finished piece 1 at 08-sep-2013 18:33:08

piece handle=/oracle/flashrecovery/LAX_DB01/backupset/2013_09_08/o1_mf_nnnd0_BBB_92t98y89_.bkp tag=BBB comment=NONE

channel d1: backup set complete, elapsed time: 00:00:56

Finished backup at 08-sep-2013 18:33:08

Starting backup at 08-sep-2013 18:33:13

current log archived

channel d1: starting archived log backup set

channel d1: specifying archived log(s) in backup set

input archived log thread=1 sequence=4 RECID=207 STAMP=825618393

input archived log thread=1 sequence=5 RECID=208 STAMP=825618795

channel d1: starting piece 1 at 08-sep-2013 18:33:16

channel d1: finished piece 1 at 08-sep-2013 18:33:19

piece handle=/oracle/flashrecovery/LAX_DB01/backupset/2013_09_08/o1_mf_annnn_BBB_92t9bwqn_.bkp tag=BBB comment=NONE

channel d1: backup set complete, elapsed time: 00:00:03

channel d1: deleting archived log(s)

archived log file name=/oracle/flashrecovery/LAX_DB01/archivelog/2013_09_08/o1_mf_1_4_92t8y8bg_.arc RECID=207 STAMP=825618393

archived log file name=/oracle/flashrecovery/LAX_DB01/archivelog/2013_09_08/o1_mf_1_5_92t9bv43_.arc RECID=208 STAMP=825618795

Finished backup at 08-sep-2013 18:33:21

Starting Control File and SPFILE Autobackup at 08-sep-2013 18:33:22

piece handle=/oracle/flashrecovery/LAX_DB01/autobackup/2013_09_08/o1_mf_s_825618802_92t9c77l_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 08-sep-2013 18:33:37

released channel: d1

allocated channel: d2

channel d2: SID=40 device type=DISK

Oracle instance started

Total System Global Area     534462464 bytes

Fixed Size                     2230072 bytes

Variable Size                276826312 bytes

Database Buffers             251658240 bytes

Redo Buffers                   3747840 bytes

allocated channel: d2

channel d2: SID=18 device type=DISK

executing command: SET DBID

Starting restore at 08-sep-2013 18:33:45

recovery area destination: /oracle/flashrecovery

database name (or database unique name) used for search: LAX_DB01

channel d2: AUTOBACKUP /oracle/flashrecovery/LAX_DB01/autobackup/2013_09_08/o1_mf_s_825618802_92t9c77l_.bkp found in the recovery area

channel d2: looking for AUTOBACKUP on day: 20130908

channel d2: restoring control file from AUTOBACKUP /oracle/flashrecovery/LAX_DB01/autobackup/2013_09_08/o1_mf_s_825618802_92t9c77l_.bkp

channel d2: control file restore from AUTOBACKUP complete

output file name=/oracle/oradata/LAX_DB01/controlfile/o1_mf_8ymzlb9v_.ctl

output file name=/oracle/oradata/LAX_DB01/controlfile/o1_mf_8ymzlc18_.ctl

Finished restore at 08-sep-2013 18:33:48

database mounted

Starting restore at 08-sep-2013 18:33:57

Starting implicit crosscheck backup at 08-sep-2013 18:33:57

Crosschecked 21 objects

Finished implicit crosscheck backup at 08-sep-2013 18:33:59

Starting implicit crosscheck copy at 08-sep-2013 18:33:59

Finished implicit crosscheck copy at 08-sep-2013 18:33:59

searching for all files in the recovery area

cataloging files...

cataloging done

List of Cataloged Files

=======================

File Name: /oracle/flashrecovery/LAX_DB01/autobackup/2013_09_07/o1_mf_s_825505909_92pv3b3h_.bkp

File Name: /oracle/flashrecovery/LAX_DB01/autobackup/2013_09_07/o1_mf_s_825505443_92ptnrnx_.bkp

File Name: /oracle/flashrecovery/LAX_DB01/autobackup/2013_09_07/o1_mf_s_825504089_92psbj4c_.bkp

File Name: /oracle/flashrecovery/LAX_DB01/autobackup/2013_09_08/o1_mf_s_825583565_92s6y2sj_.bkp

File Name: /oracle/flashrecovery/LAX_DB01/autobackup/2013_09_08/o1_mf_s_825615853_92t6h3h6_.bkp

File Name: /oracle/flashrecovery/LAX_DB01/autobackup/2013_09_08/o1_mf_s_825598193_92so75ts_.bkp

File Name: /oracle/flashrecovery/LAX_DB01/autobackup/2013_09_08/o1_mf_s_825583673_92s71h73_.bkp

File Name: /oracle/flashrecovery/LAX_DB01/autobackup/2013_09_08/o1_mf_s_825616001_92t6mq6t_.bkp

File Name: /oracle/flashrecovery/LAX_DB01/autobackup/2013_09_08/o1_mf_s_825618802_92t9c77l_.bkp

File Name: /oracle/flashrecovery/LAX_DB01/autobackup/2013_09_08/o1_mf_s_825598316_92soc0g8_.bkp

File Name: /oracle/flashrecovery/LAX_DB01/autobackup/2013_09_08/o1_mf_s_825591733_92sgx9ko_.bkp

File Name: /oracle/flashrecovery/LAX_DB01/autobackup/2013_09_08/o1_mf_s_825591847_92sh0vqj_.bkp

channel d2: starting datafile backup set restore

channel d2: specifying datafile(s) to restore from backup set

channel d2: restoring datafile 00001 to /oracle/oradata/LAX_DB01/datafile/o1_mf_system_8ymzrcgk_.dbf

channel d2: restoring datafile 00002 to /oracle/oradata/LAX_DB01/datafile/o1_mf_sysaux_8ymzrr20_.dbf

channel d2: restoring datafile 00003 to /oracle/oradata/LAX_DB01/datafile/o1_mf_undotbs_8ymzsr1w_.dbf

channel d2: restoring datafile 00004 to /oracle/oradata/LAX_DB01/datafile/o1_mf_user_dat_8yo8879m_.dbf

channel d2: reading from backup piece /oracle/flashrecovery/LAX_DB01/backupset/2013_09_08/o1_mf_nnnd0_BBB_92t98y89_.bkp

channel d2: piece handle=/oracle/flashrecovery/LAX_DB01/backupset/2013_09_08/o1_mf_nnnd0_BBB_92t98y89_.bkp tag=BBB

channel d2: restored backup piece 1

channel d2: restore complete, elapsed time: 00:00:45

Finished restore at 08-sep-2013 18:34:47

Starting recover at 08-sep-2013 18:34:49

starting media recovery

archived log for thread 1 with sequence 5 is already on disk as file /oracle/oradata/LAX_DB01/onlinelog/o1_mf_1_8ymzlfdm_.log

archived log for thread 1 with sequence 6 is already on disk as file /oracle/oradata/LAX_DB01/onlinelog/o1_mf_2_8ymzlfph_.log

archived log file name=/oracle/oradata/LAX_DB01/onlinelog/o1_mf_1_8ymzlfdm_.log thread=1 sequence=5

archived log file name=/oracle/oradata/LAX_DB01/onlinelog/o1_mf_2_8ymzlfph_.log thread=1 sequence=6

media recovery complete, elapsed time: 00:00:02

Finished recover at 08-sep-2013 18:35:11

database opened

released channel: d2

Recovery Manager complete.

[oracle@lax:db01]/home/oracle

$