Wednesday, 11 May 2011

incomplete recovery of Oracle 11g R2 database with RMAN on secondary host

Introduction:
In this post we will see how to recover the Oracle 11g database past in time (incomplete recovery) on the secondary host.

CookBook:

Following things were done to achieve the objective.

1- Installation of the Oracle 11g R2 on secondary host.

2- There should be connectivity between the secondary host, RMAN server and Target database.

3- Target database name is ORA11G, Recovery Manager database is RMAN, and the recovered database would be called as AUX database.

4- The target database hot backup was made by using RMAN and the destination was a mounted file system on the target database server.

Following is the rman script which was used to recover the database past in time (incomplete recovery).


run {
set until time "to_date('08-MAY-2011 18:00:00','DD-MON-YYYY HH24:MI:SS')";
allocate auxiliary channel ch2 device type disk;
allocate auxiliary channel ch1 device type disk;
allocate auxiliary channel ch3 device type disk;
allocate auxiliary channel ch4 device type disk;
set newname for tempfile 1 to '/FS_restore/oracle/database/oradata/AUX/temp01.dbf';
set newname for tempfile 2 to '/FS_restore/oracle/database/oradata/AUX/temp02.dbf';
set newname for tempfile 3 to '/FS_restore/oracle/database/oradata/AUX/temp03.dbf';
set newname for datafile 4 to '/FS_restore/oracle/database/oradata/AUX/users01.dbf';
set newname for datafile 3 to '/FS_restore/oracle/database/oradata/AUX/undotbs01.dbf';
set newname for datafile 2 to '/FS_restore/oracle/database/oradata/AUX/sysaux01.dbf';
set newname for datafile 1 to '/FS_restore/oracle/database/oradata/AUX/system01.dbf';
set newname for datafile 5 to '/FS_restore/oracle/database/oradata/AUX/EAN_T_1.dbf';
set newname for datafile 6 to '/FS_restore/oracle/database/oradata/AUX/EAN_T_2.dbf';
set newname for datafile 7 to '/FS_restore/oracle/database/oradata/AUX/PAST_T_1.dbf';
set newname for datafile 8 to '/FS_restore/oracle/database/oradata/AUX/PAST_T_2.dbf';
set newname for datafile 9 to '/FS_restore/oracle/database/oradata/AUX/ON_T_1.dbf';
set newname for datafile 10 to '/FS_restore/oracle/database/oradata/AUX/ON_T_2.dbf';
set newname for datafile 11 to '/FS_restore/oracle/database/oradata/AUX/NFE_T_1.dbf';
set newname for datafile 12 to '/FS_restore/oracle/database/oradata/AUX/NFE_T_2.dbf';
set newname for datafile 13 to '/FS_restore/oracle/database/oradata/AUX/ORA11G_DATA_1.dbf';
set newname for datafile 14 to '/FS_restore/oracle/database/oradata/AUX/ORA11G_DATA_2.dbf';
set newname for datafile 15 to '/FS_restore/oracle/database/oradata/AUX/REPORTING_1.dbf';
set newname for datafile 16 to '/FS_restore/oracle/database/oradata/AUX/REPORTING_2.dbf';
set newname for datafile 17 to '/FS_restore/oracle/database/oradata/AUX/ORA11G_DATA_3.dbf';
set newname for datafile 18 to '/FS_restore/oracle/database/oradata/AUX/ORA11G_DATA_4.dbf';
set newname for datafile 19 to '/FS_restore/oracle/database/oradata/AUX/ORA11G_DATA_5.dbf';
set newname for datafile 20 to '/FS_restore/oracle/database/oradata/AUX/ORA11G_DATA_6.dbf';
set newname for datafile 21 to '/FS_restore/oracle/database/oradata/AUX/REPORTING_3.dbf';
set newname for datafile 22 to '/FS_restore/oracle/database/oradata/AUX/REPORTING_4.dbf';
set newname for datafile 23 to '/FS_restore/oracle/database/oradata/AUX/REPORTING_5.dbf';
set newname for datafile 24 to '/FS_restore/oracle/database/oradata/AUX/ORA11G_DATA_7.dbf';
set newname for datafile 25 to '/FS_restore/oracle/database/oradata/AUX/REPORTING_6.dbf';
set newname for datafile 26 to '/FS_restore/oracle/database/oradata/AUX/ORA11G_DATA_8.dbf';
set newname for datafile 27 to '/FS_restore/oracle/database/oradata/AUX/ORA11G_DATA_9.dbf';
set newname for datafile 28 to '/FS_restore/oracle/database/oradata/AUX/ORA11G_DATA_10.dbf';
set newname for datafile 29 to '/FS_restore/oracle/database/oradata/AUX/undotbs02.dbf';
set newname for datafile 30 to '/FS_restore/oracle/database/oradata/AUX/ORA11G_DATA_11.dbf';
set newname for datafile 31 to '/FS_restore/oracle/database/oradata/AUX/ORA11G_DATA_12.dbf';
set newname for datafile 32 to '/FS_restore/oracle/database/oradata/AUX/ORA11G_DATA_13.dbf';
set newname for datafile 33 to '/FS_restore/oracle/database/oradata/AUX/others01.dbf';
set newname for datafile 34 to '/FS_restore/oracle/database/oradata/AUX/REPORTING_7.dbf';
set newname for datafile 35 to '/FS_restore/oracle/database/oradata/AUX/ORA11G_DATA_14.dbf';
set newname for datafile 36 to '/FS_restore/oracle/database/oradata/AUX/ORA11G_DATA_15.dbf';
DUPLICATE TARGET DATABASE TO AUX
LOGFILE GROUP 1 ('/FS_restore/oracle/database/oradata/AUX/auxredo01a.log','/FS_restore/oracle/database/oradata/AUX/auxredo01b.log') SIZE 500M REUSE,
GROUP 2 ('/FS_restore/oracle/database/oradata/AUX/auxredo02a.log', '/FS_restore/oracle/database/oradata/AUX/auxredo02b.log') SIZE 500M REUSE,
GROUP 3 ('/FS_restore/oracle/database/oradata/AUX/aux1redo03a.log','/FS_restore/oracle/database/oradata/AUX/aux1redo03b.log') SIZE 500M REUSE;
release channel ch2;
release channel ch1;
release channel ch3;
release channel ch4;
}

------------------

Here are the few scenarios which we discovered while doing the incomplete recovery.

Following is the error messages which we got.

channel ch2: starting datafile backup set restore
channel ch2: restoring control file
channel ch2: reading from backup piece /appl/oracle/flash_recovery_area/REPORTING/autobackup/2011_02_04/o1_mf_s_742230501_6nqv1p5j_.bkp
channel ch2: ORA-19870: error while restoring backup piece /appl/oracle/flash_recovery_area/REPORTING/autobackup/2011_02_04/o1_mf_s_742230501_6nqv1p5j_.bkp
ORA-19505: failed to identify file "/appl/oracle/flash_recovery_area/REPORTING/autobackup/2011_02_04/o1_mf_s_742230501_6nqv1p5j_.bkp"
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

failover to previous backup

released channel: ch2
released channel: ch1
released channel: ch3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/12/2011 21:10:29
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore

Recovery Manager complete.

-------
When we studied the above messages we came to know that RMAN is not able to find the control file backup, as the file system it is showing in the error messages was the file system on the Target database, we made the same file system on the Secondary database server (AUX database) and copied the same directories which RMAN was trying to search and having done this we again run the same script and this time it didnt show the above errors.

after mounting the file system we again ran the rman script and this time it was able to restore the control file and mounted the database, following is the informatio from log file.
----------


Starting restore at 08-MAY-11

channel ch2: starting datafile backup set restore
channel ch2: restoring control file
channel ch2: reading from backup piece /appl/oracle/flash_recovery_area/REPORTING/autobackup/2011_04_08/o1_mf_s_747924939_6sxpwvx2_.bkp
channel ch2: piece handle=/appl/oracle/flash_recovery_area/REPORTING/autobackup/2011_04_08/o1_mf_s_747924939_6sxpwvx2_.bkp tag=TAG20110408T125539
channel ch2: restored backup piece 1
channel ch2: restore complete, elapsed time: 00:00:03
output file name=/fs_restore/oracle/database/oradata/AUX/control01.ctl
output file name=/fs_restore/oracle/database/oradata/AUX/control02.ctl
Finished restore at 12-APR-11

database mounted
released channel: ch2
released channel: ch1
released channel: ch3

-----------

And following is the complete log of rman script.

-------------

Recovery Manager: Release 11.2.0.1.0 - Production on Wed MAY O8 05:10:55 2011

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

connected to target database: REPORTING (DBID=418O888985)
connected to recovery catalog database
connected to auxiliary database: AUX (not mounted)

RMAN> run {
2> set until time "to_date('08-MAY-2011 18:00:00','DD-MON-YYYY HH24:MI:SS')";
3> allocate auxiliary channel ch2 device type disk;
4> allocate auxiliary channel ch1 device type disk;
5> allocate auxiliary channel ch3 device type disk;
6> allocate auxiliary channel ch4 device type disk;
7> set newname for tempfile 1 to '/fs_restore/oracle/database/oradata/AUX/temp01.dbf';
8> set newname for tempfile 2 to '/fs_restore/oracle/database/oradata/AUX/temp02.dbf';
9> set newname for tempfile 3 to '/fs_restore/oracle/database/oradata/AUX/temp03.dbf';
10> set newname for datafile 4 to '/fs_restore/oracle/database/oradata/AUX/users01.dbf';
11> set newname for datafile 3 to '/fs_restore/oracle/database/oradata/AUX/undotbs01.dbf';
O8> set newname for datafile 2 to '/fs_restore/oracle/database/oradata/AUX/sysaux01.dbf';
O8> set newname for datafile 1 to '/fs_restore/oracle/database/oradata/AUX/system01.dbf';
14> set newname for datafile 5 to '/fs_restore/oracle/database/oradata/AUX/EAN_T_1.dbf';
15> set newname for datafile 6 to '/fs_restore/oracle/database/oradata/AUX/EAN_T_2.dbf';
16> set newname for datafile 7 to '/fs_restore/oracle/database/oradata/AUX/PAST_1.dbf';
17> set newname for datafile 8 to '/fs_restore/oracle/database/oradata/AUX/PAST_T_2.dbf';
18> set newname for datafile 9 to '/fs_restore/oracle/database/oradata/AUX/ON_T_1.dbf';
19> set newname for datafile 10 to '/fs_restore/oracle/database/oradata/AUX/ON_T_2.dbf';
20> set newname for datafile 11 to '/fs_restore/oracle/database/oradata/AUX/NFE_T_1.dbf';
21> set newname for datafile O8 to '/fs_restore/oracle/database/oradata/AUX/NFE_T_2.dbf';
22> set newname for datafile O8 to '/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_1.dbf';
23> set newname for datafile 14 to '/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_2.dbf';
24> set newname for datafile 15 to '/fs_restore/oracle/database/oradata/AUX/REPORTING_1.dbf';
25> set newname for datafile 16 to '/fs_restore/oracle/database/oradata/AUX/REPORTING_2.dbf';
26> set newname for datafile 17 to '/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_3.dbf';
27> set newname for datafile 18 to '/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_4.dbf';
28> set newname for datafile 19 to '/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_5.dbf';
29> set newname for datafile 20 to '/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_6.dbf';
30> set newname for datafile 21 to '/fs_restore/oracle/database/oradata/AUX/REPORTING_3.dbf';
31> set newname for datafile 22 to '/fs_restore/oracle/database/oradata/AUX/REPORTING_4.dbf';
32> set newname for datafile 23 to '/fs_restore/oracle/database/oradata/AUX/REPORTING_5.dbf';
33> set newname for datafile 24 to '/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_7.dbf';
34> set newname for datafile 25 to '/fs_restore/oracle/database/oradata/AUX/REPORTING_6.dbf';
35> set newname for datafile 26 to '/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_8.dbf';
36> set newname for datafile 27 to '/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_9.dbf';
37> set newname for datafile 28 to '/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_10.dbf';
38> set newname for datafile 29 to '/fs_restore/oracle/database/oradata/AUX/undotbs02.dbf';
39> set newname for datafile 30 to '/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_11.dbf';
40> set newname for datafile 31 to '/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_O8.dbf';
41> set newname for datafile 32 to '/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_O8.dbf';
42> set newname for datafile 33 to '/fs_restore/oracle/database/oradata/AUX/others01.dbf';
43> set newname for datafile 34 to '/fs_restore/oracle/database/oradata/AUX/REPORTING_7.dbf';
44> set newname for datafile 35 to '/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_14.dbf';
45> set newname for datafile 36 to '/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_15.dbf';
46> DUPLICATE TARGET DATABASE TO AUX
47> LOGFILE GROUP 1 ('/fs_restore/oracle/database/oradata/AUX/auxredo01a.log','/fs_restore/oracle/database/oradata/AUX/auxredo01b.log') SIZE 500M REUSE,
48> GROUP 2 ('/fs_restore/oracle/database/oradata/AUX/auxredo02a.log', '/fs_restore/oracle/database/oradata/AUX/auxredo02b.log') SIZE 500M REUSE,
49> GROUP 3 ('/fs_restore/oracle/database/oradata/AUX/aux1redo03a.log','/fs_restore/oracle/database/oradata/AUX/aux1redo03b.log') SIZE 500M REUSE;
50> release channel ch2;
51> release channel ch1;
52> release channel ch3;
53> release channel ch4;
54> }
55>
56>
executing command: SET until clause

allocated channel: ch2
channel ch2: SID=817 device type=DISK

allocated channel: ch1
channel ch1: SID=851 device type=DISK

allocated channel: ch3
channel ch3: SID=885 device type=DISK

allocated channel: ch4
channel ch4: SID=919 device type=DISK

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting Duplicate Db at O8-MAY-11

contents of Memory Script:
{
set until scn 7345323564358;
sql clone "alter system set db_name =
''REPORTING'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''AUX'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone imNFEiate;
startup clone force nomount
restore clone primary controlfile;
alter clone database mount;
}
executing Memory Script

executing command: SET until clause

sql statement: alter system set db_name = ''REPORTING'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set db_unique_name = ''AUX'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area 8554O87360 bytes

Fixed Size 2165208 bytes
Variable Size 822089256 bytes
Database Buffers 7700742144 bytes
Redo Buffers 29O80752 bytes
allocated channel: ch2
channel ch2: SID=817 device type=DISK
allocated channel: ch1
channel ch1: SID=851 device type=DISK
allocated channel: ch3
channel ch3: SID=885 device type=DISK
allocated channel: ch4
channel ch4: SID=919 device type=DISK

Starting restore at O8-MAY-11

channel ch2: starting datafile backup set restore
channel ch2: restoring control file
channel ch2: reading from backup piece /fs/appl/oracle/flash_recovery_area/REPORTING/autobackup/2011_04_08/o1_mf_s_747924939_6sxpwvx2_.bkp
channel ch2: piece handle=/fs/appl/oracle/flash_recovery_area/REPORTING/autobackup/2011_04_08/o1_mf_s_747924939_6sxpwvx2_.bkp tag=TAG20110408TO85539
channel ch2: restored backup piece 1
channel ch2: restore complete, elapsed time: 00:00:03
output file name=/fs_restore/oracle/database/oradata/AUX/control01.ctl
output file name=/fs_restore/oracle/database/oradata/AUX/control02.ctl
Finished restore at O8-MAY-11

database mounted
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/system01.dbf for datafile 1 with checkpoint SCN of 7344671914096
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/sysaux01.dbf for datafile 2 with checkpoint SCN of 7344688377360
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/undotbs01.dbf for datafile 3 with checkpoint SCN of 73446719142O8
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/users01.dbf for datafile 4 with checkpoint SCN of 7344688377360
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/ean_T_1.dbf for datafile 5 with checkpoint SCN of 7344687623519
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/ean_T_2.dbf for datafile 6 with checkpoint SCN of 7344687623519
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/PAST_T_1.dbf for datafile 7 with checkpoint SCN of 7344688214802
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/PAST_T_2.dbf for datafile 8 with checkpoint SCN of 7344688214802
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/ON_T_1.dbf for datafile 9 with checkpoint SCN of 7344688214802
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/ON_T_2.dbf for datafile 10 with checkpoint SCN of 7344688377360
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/NFE_T_1.dbf for datafile 11 with checkpoint SCN of 7344687333584
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/NFE_T_2.dbf for datafile O8 with checkpoint SCN of 7344687333584
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_1.dbf for datafile O8 with checkpoint SCN of 73446719142O8
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_2.dbf for datafile 14 with checkpoint SCN of 7344671914096
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/REPORTING_1.dbf for datafile 15 with checkpoint SCN of 73446719142O8
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/REPORTING_2.dbf for datafile 16 with checkpoint SCN of 7344671914096
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_3.dbf for datafile 17 with checkpoint SCN of 7344687333584
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_4.dbf for datafile 18 with checkpoint SCN of 7344687623519
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_5.dbf for datafile 19 with checkpoint SCN of 7344688214802
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_6.dbf for datafile 20 with checkpoint SCN of 7344688377360
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/REPORTING_3.dbf for datafile 21 with checkpoint SCN of 7344687333584
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/REPORTING_4.dbf for datafile 22 with checkpoint SCN of 7344687623519
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/REPORTING_5.dbf for datafile 23 with checkpoint SCN of 7344688214802
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_7.dbf for datafile 24 with checkpoint SCN of 7344671914325
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/REPORTING_6.dbf for datafile 25 with checkpoint SCN of 7344688377360
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_8.dbf for datafile 26 with checkpoint SCN of 7344671914325
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_9.dbf for datafile 27 with checkpoint SCN of 7344687672604
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_10.dbf for datafile 28 with checkpoint SCN of 7344687672604
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/undotbs02.dbf for datafile 29 with checkpoint SCN of 7344671914096
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_11.dbf for datafile 30 with checkpoint SCN of 7344687672604
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_O8.dbf for datafile 31 with checkpoint SCN of 73446719142O8
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_O8.dbf for datafile 32 with checkpoint SCN of 7344671914096
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/others01.dbf for datafile 33 with checkpoint SCN of 73446719142O8
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/REPORTING_7.dbf for datafile 34 with checkpoint SCN of 7344671914325
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_14.dbf for datafile 35 with checkpoint SCN of 7344687333584
Using previous duplicated file /fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_15.dbf for datafile 36 with checkpoint SCN of 7344687623519

contents of Memory Script:
{
catalog clone datafilecopy "/fs_restore/oracle/database/oradata/AUX/system01.dbf",
"/fs_restore/oracle/database/oradata/AUX/sysaux01.dbf",
"/fs_restore/oracle/database/oradata/AUX/undotbs01.dbf",
"/fs_restore/oracle/database/oradata/AUX/users01.dbf",
"/fs_restore/oracle/database/oradata/AUX/ean_T_1.dbf",
"/fs_restore/oracle/database/oradata/AUX/ean_T_2.dbf",
"/fs_restore/oracle/database/oradata/AUX/PAST_T_1.dbf",
"/fs_restore/oracle/database/oradata/AUX/PAST_T_2.dbf",
"/fs_restore/oracle/database/oradata/AUX/ON_T_1.dbf",
"/fs_restore/oracle/database/oradata/AUX/ON_T_2.dbf",
"/fs_restore/oracle/database/oradata/AUX/NFE_T_1.dbf",
"/fs_restore/oracle/database/oradata/AUX/NFE_T_2.dbf",
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_1.dbf",
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_2.dbf",
"/fs_restore/oracle/database/oradata/AUX/REPORTING_1.dbf",
"/fs_restore/oracle/database/oradata/AUX/REPORTING_2.dbf",
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_3.dbf",
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_4.dbf",
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_5.dbf",
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_6.dbf",
"/fs_restore/oracle/database/oradata/AUX/REPORTING_3.dbf",
"/fs_restore/oracle/database/oradata/AUX/REPORTING_4.dbf",
"/fs_restore/oracle/database/oradata/AUX/REPORTING_5.dbf",
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_7.dbf",
"/fs_restore/oracle/database/oradata/AUX/REPORTING_6.dbf",
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_8.dbf",
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_9.dbf",
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_10.dbf",
"/fs_restore/oracle/database/oradata/AUX/undotbs02.dbf",
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_11.dbf",
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_O8.dbf",
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_O8.dbf",
"/fs_restore/oracle/database/oradata/AUX/others01.dbf",
"/fs_restore/oracle/database/oradata/AUX/REPORTING_7.dbf",
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_14.dbf",
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_15.dbf";
switch clone datafile 1 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/system01.dbf";
switch clone datafile 2 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/sysaux01.dbf";
switch clone datafile 3 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/undotbs01.dbf";
switch clone datafile 4 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/users01.dbf";
switch clone datafile 5 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/ean_T_1.dbf";
switch clone datafile 6 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/ean_T_2.dbf";
switch clone datafile 7 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/PAST_T_1.dbf";
switch clone datafile 8 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/PAST_T_2.dbf";
switch clone datafile 9 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/ON_T_1.dbf";
switch clone datafile 10 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/ON_T_2.dbf";
switch clone datafile 11 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/NFE_T_1.dbf";
switch clone datafile O8 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/NFE_T_2.dbf";
switch clone datafile O8 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_1.dbf";
switch clone datafile 14 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_2.dbf";
switch clone datafile 15 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/REPORTING_1.dbf";
switch clone datafile 16 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/REPORTING_2.dbf";
switch clone datafile 17 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_3.dbf";
switch clone datafile 18 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_4.dbf";
switch clone datafile 19 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_5.dbf";
switch clone datafile 20 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_6.dbf";
switch clone datafile 21 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/REPORTING_3.dbf";
switch clone datafile 22 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/REPORTING_4.dbf";
switch clone datafile 23 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/REPORTING_5.dbf";
switch clone datafile 24 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_7.dbf";
switch clone datafile 25 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/REPORTING_6.dbf";
switch clone datafile 26 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_8.dbf";
switch clone datafile 27 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_9.dbf";
switch clone datafile 28 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_10.dbf";
switch clone datafile 29 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/undotbs02.dbf";
switch clone datafile 30 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_11.dbf";
switch clone datafile 31 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_O8.dbf";
switch clone datafile 32 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_O8.dbf";
switch clone datafile 33 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/others01.dbf";
switch clone datafile 34 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/REPORTING_7.dbf";
switch clone datafile 35 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_14.dbf";
switch clone datafile 36 to datafilecopy
"/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_15.dbf";
}
executing Memory Script

cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/system01.dbf RECID=1 STAMP=748329314
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/sysaux01.dbf RECID=2 STAMP=748329314
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/undotbs01.dbf RECID=3 STAMP=748329315
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/users01.dbf RECID=4 STAMP=748329315
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/ean_T_1.dbf RECID=5 STAMP=748329316
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/ean_T_2.dbf RECID=6 STAMP=748329316
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/PAST_T_1.dbf RECID=7 STAMP=748329317
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/PAST_T_2.dbf RECID=8 STAMP=748329317
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/ON_T_1.dbf RECID=9 STAMP=748329318
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/ON_T_2.dbf RECID=10 STAMP=748329318
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/NFE_T_1.dbf RECID=11 STAMP=748329319
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/NFE_T_2.dbf RECID=O8 STAMP=748329320
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_1.dbf RECID=O8 STAMP=748329320
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_2.dbf RECID=14 STAMP=748329321
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/REPORTING_1.dbf RECID=15 STAMP=748329321
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/REPORTING_2.dbf RECID=16 STAMP=748329322
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_3.dbf RECID=17 STAMP=748329322
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_4.dbf RECID=18 STAMP=748329323
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_5.dbf RECID=19 STAMP=748329324
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_6.dbf RECID=20 STAMP=748329324
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/REPORTING_3.dbf RECID=21 STAMP=748329325
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/REPORTING_4.dbf RECID=22 STAMP=748329325
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/REPORTING_5.dbf RECID=23 STAMP=748329326
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_7.dbf RECID=24 STAMP=748329326
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/REPORTING_6.dbf RECID=25 STAMP=748329327
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_8.dbf RECID=26 STAMP=748329328
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_9.dbf RECID=27 STAMP=748329328
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_10.dbf RECID=28 STAMP=748329329
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/undotbs02.dbf RECID=29 STAMP=748329329
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_11.dbf RECID=30 STAMP=748329330
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_O8.dbf RECID=31 STAMP=748329330
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_O8.dbf RECID=32 STAMP=748329331
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/others01.dbf RECID=33 STAMP=748329331
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/REPORTING_7.dbf RECID=34 STAMP=748329332
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_14.dbf RECID=35 STAMP=748329332
cataloged datafile copy
datafile copy file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_15.dbf RECID=36 STAMP=748329333

datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=748329314 file name=/fs_restore/oracle/database/oradata/AUX/system01.dbf

datafile 2 switched to datafile copy
input datafile copy RECID=2 STAMP=748329314 file name=/fs_restore/oracle/database/oradata/AUX/sysaux01.dbf

datafile 3 switched to datafile copy
input datafile copy RECID=3 STAMP=748329315 file name=/fs_restore/oracle/database/oradata/AUX/undotbs01.dbf

datafile 4 switched to datafile copy
input datafile copy RECID=4 STAMP=748329315 file name=/fs_restore/oracle/database/oradata/AUX/users01.dbf

datafile 5 switched to datafile copy
input datafile copy RECID=5 STAMP=748329316 file name=/fs_restore/oracle/database/oradata/AUX/ean_T_1.dbf

datafile 6 switched to datafile copy
input datafile copy RECID=6 STAMP=748329316 file name=/fs_restore/oracle/database/oradata/AUX/ean_T_2.dbf

datafile 7 switched to datafile copy
input datafile copy RECID=7 STAMP=748329317 file name=/fs_restore/oracle/database/oradata/AUX/PAST_T_1.dbf

datafile 8 switched to datafile copy
input datafile copy RECID=8 STAMP=748329317 file name=/fs_restore/oracle/database/oradata/AUX/PAST_T_2.dbf

datafile 9 switched to datafile copy
input datafile copy RECID=9 STAMP=748329318 file name=/fs_restore/oracle/database/oradata/AUX/ON_T_1.dbf

datafile 10 switched to datafile copy
input datafile copy RECID=10 STAMP=748329318 file name=/fs_restore/oracle/database/oradata/AUX/ON_T_2.dbf

datafile 11 switched to datafile copy
input datafile copy RECID=11 STAMP=748329319 file name=/fs_restore/oracle/database/oradata/AUX/NFE_T_1.dbf

datafile O8 switched to datafile copy
input datafile copy RECID=O8 STAMP=748329320 file name=/fs_restore/oracle/database/oradata/AUX/NFE_T_2.dbf

datafile O8 switched to datafile copy
input datafile copy RECID=O8 STAMP=748329320 file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_1.dbf

datafile 14 switched to datafile copy
input datafile copy RECID=14 STAMP=748329321 file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_2.dbf

datafile 15 switched to datafile copy
input datafile copy RECID=15 STAMP=748329321 file name=/fs_restore/oracle/database/oradata/AUX/REPORTING_1.dbf

datafile 16 switched to datafile copy
input datafile copy RECID=16 STAMP=748329322 file name=/fs_restore/oracle/database/oradata/AUX/REPORTING_2.dbf

datafile 17 switched to datafile copy
input datafile copy RECID=17 STAMP=748329322 file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_3.dbf

datafile 18 switched to datafile copy
input datafile copy RECID=18 STAMP=748329323 file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_4.dbf

datafile 19 switched to datafile copy
input datafile copy RECID=19 STAMP=748329324 file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_5.dbf

datafile 20 switched to datafile copy
input datafile copy RECID=20 STAMP=748329324 file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_6.dbf

datafile 21 switched to datafile copy
input datafile copy RECID=21 STAMP=748329325 file name=/fs_restore/oracle/database/oradata/AUX/REPORTING_3.dbf

datafile 22 switched to datafile copy
input datafile copy RECID=22 STAMP=748329325 file name=/fs_restore/oracle/database/oradata/AUX/REPORTING_4.dbf

datafile 23 switched to datafile copy
input datafile copy RECID=23 STAMP=748329326 file name=/fs_restore/oracle/database/oradata/AUX/REPORTING_5.dbf

datafile 24 switched to datafile copy
input datafile copy RECID=24 STAMP=748329326 file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_7.dbf

datafile 25 switched to datafile copy
input datafile copy RECID=25 STAMP=748329327 file name=/fs_restore/oracle/database/oradata/AUX/REPORTING_6.dbf

datafile 26 switched to datafile copy
input datafile copy RECID=26 STAMP=748329328 file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_8.dbf

datafile 27 switched to datafile copy
input datafile copy RECID=27 STAMP=748329328 file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_9.dbf

datafile 28 switched to datafile copy
input datafile copy RECID=28 STAMP=748329329 file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_10.dbf

datafile 29 switched to datafile copy
input datafile copy RECID=29 STAMP=748329329 file name=/fs_restore/oracle/database/oradata/AUX/undotbs02.dbf

datafile 30 switched to datafile copy
input datafile copy RECID=30 STAMP=748329330 file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_11.dbf

datafile 31 switched to datafile copy
input datafile copy RECID=31 STAMP=748329330 file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_O8.dbf

datafile 32 switched to datafile copy
input datafile copy RECID=32 STAMP=748329331 file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_O8.dbf

datafile 33 switched to datafile copy
input datafile copy RECID=33 STAMP=748329331 file name=/fs_restore/oracle/database/oradata/AUX/others01.dbf

datafile 34 switched to datafile copy
input datafile copy RECID=34 STAMP=748329332 file name=/fs_restore/oracle/database/oradata/AUX/REPORTING_7.dbf

datafile 35 switched to datafile copy
input datafile copy RECID=35 STAMP=748329332 file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_14.dbf

datafile 36 switched to datafile copy
input datafile copy RECID=36 STAMP=748329333 file name=/fs_restore/oracle/database/oradata/AUX/ORA11G_DATA_15.dbf

contents of Memory Script:
{
set until time "to_date('08-MAY-2011 18:00:00','DD-MON-YYYY HH24:MI:SS')";
recover
clone database
delete archivelog
;
}
executing Memory Script

executing command: SET until clause

Starting recover at O8-MAY-11

starting NFEia recovery

channel ch2: starting archived log restore to default destination
channel ch2: restoring archived log
archived log thread=1 sequence=O86447
channel ch2: restoring archived log
archived log thread=1 sequence=O86448
channel ch2: restoring archived log
archived log thread=1 sequence=O86449
channel ch2: restoring archived log
archived log thread=1 sequence=O86450
channel ch2: restoring archived log
archived log thread=1 sequence=O86451
channel ch2: restoring archived log
archived log thread=1 sequence=O86452
channel ch2: restoring archived log
archived log thread=1 sequence=O86453
channel ch2: restoring archived log
archived log thread=1 sequence=O86454
channel ch2: restoring archived log
archived log thread=1 sequence=O86455
channel ch2: restoring archived log
archived log thread=1 sequence=O86456
channel ch2: reading from backup piece /fs_backup/arch_bkp/REPORTING_arch_O874_1_747665115
channel ch1: starting archived log restore to default destination
channel ch1: restoring archived log
archived log thread=1 sequence=O86457
channel ch1: restoring archived log
archived log thread=1 sequence=O86458
channel ch1: restoring archived log
archived log thread=1 sequence=O86459
channel ch1: restoring archived log
archived log thread=1 sequence=O86460
channel ch1: restoring archived log
archived log thread=1 sequence=O86461
channel ch1: restoring archived log
archived log thread=1 sequence=O86462
channel ch1: restoring archived log
archived log thread=1 sequence=O86463
channel ch1: restoring archived log
archived log thread=1 sequence=O86464
channel ch1: restoring archived log
archived log thread=1 sequence=O86465
channel ch1: restoring archived log
archived log thread=1 sequence=O86466
channel ch1: restoring archived log
archived log thread=1 sequence=O86467
channel ch1: restoring archived log
archived log thread=1 sequence=O86468
channel ch1: restoring archived log
archived log thread=1 sequence=O86469
channel ch1: restoring archived log
archived log thread=1 sequence=O86470
channel ch1: restoring archived log
archived log thread=1 sequence=O86471
channel ch1: restoring archived log
archived log thread=1 sequence=O86472
channel ch1: restoring archived log
archived log thread=1 sequence=O86473
channel ch1: restoring archived log
archived log thread=1 sequence=O86474
channel ch1: restoring archived log
archived log thread=1 sequence=O86475
channel ch1: restoring archived log
archived log thread=1 sequence=O86476
channel ch1: restoring archived log
archived log thread=1 sequence=O86477
channel ch1: restoring archived log
archived log thread=1 sequence=O86478
channel ch1: restoring archived log
archived log thread=1 sequence=O86479
channel ch1: restoring archived log
archived log thread=1 sequence=O86480
channel ch1: restoring archived log
archived log thread=1 sequence=O86481
channel ch1: restoring archived log
archived log thread=1 sequence=O86482
channel ch1: restoring archived log
archived log thread=1 sequence=O86689
channel ch3: reading from backup piece /fs_backup/arch_bkp/REPORTINGrpt_arch_O881_1_747837919
channel ch2: piece handle=/fs_backup/arch_bkp/REPORTINGrpt_arch_O874_1_747665115 tag=TAG20110405TO845O8
channel ch2: restored backup piece 1
channel ch2: restore complete, elapsed time: 01:28:05
archived log file name=/fs_backup/archv/AUX/REPORTINGRPT_1_O86447_727790523.arc thread=1 sequence=O86447
channel clone_default: deleting archived log(s)
archived log file name=/fs_backup/archv/AUX/REPORTINGRPT_1_O86447_727790523.arc RECID=40862 STAMP=748334746
archived log file name=/fs_backup/archv/AUX/REPORTINGRPT_1_O86448_727790523.arc thread=1 sequence=O86448
channel clone_default: deleting archived log(s)
archived log file name=/fs_backup/archv/AUX/REPORTINGRPT_1_O86448_727790523.arc RECID=40825 STAMP=748333359
archived log file name=/fs_backup/archv/AUX/REPORTINGRPT_1_O86449_727790523.arc thread=1 sequence=O86449
channel clone_default: deleting archived log(s)
archived log file name=/fs_backup/archv/AUX/REPORTINGRPT_1_O86449_727790523.arc RECID=40863 STAMP=748334748
archived log file name=/fs_backup/archv/AUX/REPORTINGRPT_1_O86450_727790523.arc thread=1 sequence=O86450
channel clone_default: deleting archived log(s)
archived log file name=/fs_backup/archv/AUX/REPORTINGRPT_1_O86450_727790523.arc RECID=40826 STAMP=748333360
archived log file name=/fs_backup/archv/AUX/REPORTINGRPT_1_O86451_727790523.arc thread=1 sequence=O86451
channel clone_default: deleting archived log(s)
archived log file name=/fs_backup/archv/AUX/REPORTINGRPT_1_O86451_727790523.arc RECID=40749 STAMP=748331040
archived log file name=/fs_backup/archv/AUX/REPORTINGRPT_1_O86452_727790523.arc thread=1 sequence=O86452
channel clone_default: deleting archived log(s)
archived log file name=/fs_backup/archv/AUX/REPORTINGRPT_1_O86452_727790523.arc RECID=40776 STAMP=748331782
archived log file name=/fs_backup/archv/AUX/REPORTINGRPT_1_O86453_727790523.arc thread=1 sequence=O86453
channel clone_default: deleting archived log(s)
archived log file name=/fs_backup/archv/AUX/REPORTINGRPT_1_O86453_727790523.arc RECID=40827 STAMP=748333362
archived log file name=/fs_backup/archv/AUX/REPORTINGRPT_1_O86454_727790523.arc thread=1 sequence=O86454
channel clone_default: deleting archived log(s)
archived log file name=/fs_backup/archv/AUX/REPORTINGRPT_1_O86454_727790523.arc RECID=40750 STAMP=748331042
archived log file name=/fs_backup/archv/AUX/REPORTINGRPT_1_O86455_727790523.arc thread=1 sequence=O86455
channel clone_default: deleting archived log(s)
archived log file name=/fs_backup/archv/AUX/REPORTINGRPT_1_O86455_727790523.arc RECID=40724 STAMP=748330244
archived log file name=/fs_backup/archv/AUX/REPORTINGRPT_1_O86456_727790523.arc thread=1 sequence=O86456
channel clone_default: deleting archived log(s)
archived log file name=/fs_backup/archv/AUX/REPORTINGRPT_1_O86456_727790523.arc RECID=40775 STAMP=748331781
channel ch2: starting archived log restore to default destination
channel ch2: restoring archived log
archived log thread=1 sequence=O86690
channel ch2: restoring archived log
archived log thread=1 sequence=O86691
channel ch2: restoring archived log
archived log thread=1 sequence=O86692
channel ch2: restoring archived log
archived log thread=1 sequence=O86693
channel ch2: restoring archived log
archived log thread=1 sequence=O86694
channel ch2: restoring archived log
archived log thread=1 sequence=O86695
channel ch2: restoring archived log
archived log thread=1 sequence=O86696
channel ch2: restoring archived log
archived log thread=1 sequence=O86697
channel ch2: restoring archived log
archived log thread=1 sequence=O86698
channel ch2: restoring archived log
archived log thread=1 sequence=O86699
channel ch2: restoring archived log
archived log thread=1 sequence=O86700
channel ch2: restoring archived log
archived log thread=1 sequence=O86701
channel ch2: restoring archived log
archived log thread=1 sequence=O86702
NFEia recovery complete, elapsed time: 00:54:14
Finished recover at 08-MAY-11

contents of Memory Script:
{
shutdown clone imNFEiate;
startup clone nomount;
sql clone "alter system set db_name =
''AUX'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system reset db_unique_name scope=spfile";
shutdown clone imNFEiate;
startup clone nomount;
}
executing Memory Script

database dismounted
Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area 8554O87360 bytes

Fixed Size 2165208 bytes
Variable Size 838866472 bytes
Database Buffers 7683964928 bytes
Redo Buffers 29O80752 bytes
allocated channel: ch2
channel ch2: SID=817 device type=DISK
allocated channel: ch1
channel ch1: SID=851 device type=DISK
allocated channel: ch3
channel ch3: SID=885 device type=DISK
allocated channel: ch4
channel ch4: SID=919 device type=DISK

sql statement: alter system set db_name = ''AUX'' comment= ''Reset to original value by RMAN'' scope=spfile

sql statement: alter system reset db_unique_name scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area 8554O87360 bytes

Fixed Size 2165208 bytes
Variable Size 838866472 bytes
Database Buffers 7683964928 bytes
Redo Buffers 29O80752 bytes
allocated channel: ch2
channel ch2: SID=817 device type=DISK
allocated channel: ch1
channel ch1: SID=851 device type=DISK
allocated channel: ch3
channel ch3: SID=885 device type=DISK
allocated channel: ch4
channel ch4: SID=919 device type=DISK
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "AUX" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGPASTORY 18688
LOGFILE
GROUP 1 ( '/FS_restore/oracle/database/oradata/AUX/auxredo01a.log', '/FS_restore/oracle/database/oradata/AUX/auxredo01b.log' ) SIZE 500 M REUSE,
GROUP 2 ( '/FS_restore/oracle/database/oradata/AUX/auxredo02a.log', '/FS_restore/oracle/database/oradata/AUX/auxredo02b.log' ) SIZE 500 M REUSE,
GROUP 3 ( '/FS_restore/oracle/database/oradata/AUX/aux1redo03a.log', '/FS_restore/oracle/database/oradata/AUX/aux1redo03b.log' ) SIZE 500 M REUSE
DATAFILE
'/FS_restore/oracle/database/oradata/AUX/system01.dbf'
CHARACTER SET AR8ISO8859P6


contents of Memory Script:
{
set newname for tempfile 1 to
"/FS_restore/oracle/database/oradata/AUX/temp01.dbf";
set newname for tempfile 2 to
"/FS_restore/oracle/database/oradata/AUX/temp02.dbf";
set newname for tempfile 3 to
"/FS_restore/oracle/database/oradata/AUX/temp03.dbf";
switch clone tempfile all;
catalog clone datafilecopy "/FS_restore/oracle/database/oradata/AUX/sysaux01.dbf",
"/FS_restore/oracle/database/oradata/AUX/undotbs01.dbf",
"/FS_restore/oracle/database/oradata/AUX/users01.dbf",
"/FS_restore/oracle/database/oradata/AUX/EAN_T_1.dbf",
"/FS_restore/oracle/database/oradata/AUX/EAN_T_2.dbf",
"/FS_restore/oracle/database/oradata/AUX/PAST_T_1.dbf",
"/FS_restore/oracle/database/oradata/AUX/PAST_T_2.dbf",
"/FS_restore/oracle/database/oradata/AUX/ON_T_1.dbf",
"/FS_restore/oracle/database/oradata/AUX/ON_T_2.dbf",
"/FS_restore/oracle/database/oradata/AUX/NEF_T_1.dbf",
"/FS_restore/oracle/database/oradata/AUX/NEF_T_2.dbf",
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_1.dbf",
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_2.dbf",
"/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_1.dbf",
"/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_2.dbf",
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_3.dbf",
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_4.dbf",
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_5.dbf",
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_6.dbf",
"/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_3.dbf",
"/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_4.dbf",
"/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_5.dbf",
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_7.dbf",
"/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_6.dbf",
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_8.dbf",
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_9.dbf",
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_10.dbf",
"/FS_restore/oracle/database/oradata/AUX/undotbs02.dbf",
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_11.dbf",
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_O8.dbf",
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_O8.dbf",
"/FS_restore/oracle/database/oradata/AUX/others01.dbf",
"/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_7.dbf",
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_14.dbf",
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_15.dbf";
switch clone datafile all;
switch clone datafile 2 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/sysaux01.dbf";
switch clone datafile 3 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/undotbs01.dbf";
switch clone datafile 4 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/users01.dbf";
switch clone datafile 5 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/EAN_T_1.dbf";
switch clone datafile 6 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/EAN_T_2.dbf";
switch clone datafile 7 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/PAST_T_1.dbf";
switch clone datafile 8 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/PAST_T_2.dbf";
switch clone datafile 9 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/ON_T_1.dbf";
switch clone datafile 10 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/ON_T_2.dbf";
switch clone datafile 11 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/NFE_T_1.dbf";
switch clone datafile O8 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/NFE_T_2.dbf";
switch clone datafile O8 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_1.dbf";
switch clone datafile 14 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_2.dbf";
switch clone datafile 15 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_1.dbf";
switch clone datafile 16 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_2.dbf";
switch clone datafile 17 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_3.dbf";
switch clone datafile 18 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_4.dbf";
switch clone datafile 19 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_5.dbf";
switch clone datafile 20 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_6.dbf";
switch clone datafile 21 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_3.dbf";
switch clone datafile 22 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_4.dbf";
switch clone datafile 23 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_5.dbf";
switch clone datafile 24 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_7.dbf";
switch clone datafile 25 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_6.dbf";
switch clone datafile 26 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_8.dbf";
switch clone datafile 27 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_9.dbf";
switch clone datafile 28 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_10.dbf";
switch clone datafile 29 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/undotbs02.dbf";
switch clone datafile 30 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_11.dbf";
switch clone datafile 31 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_O8.dbf";
switch clone datafile 32 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_O8.dbf";
switch clone datafile 33 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/others01.dbf";
switch clone datafile 34 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_7.dbf";
switch clone datafile 35 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_14.dbf";
switch clone datafile 36 to datafilecopy
"/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_15.dbf";
}
executing Memory Script

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

renaNFE tempfile 1 to /FS_restore/oracle/database/oradata/AUX/temp01.dbf in control file
renaNFE tempfile 2 to /FS_restore/oracle/database/oradata/AUX/temp02.dbf in control file
renaNFE tempfile 3 to /FS_restore/oracle/database/oradata/AUX/temp03.dbf in control file

cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/sysaux01.dbf RECID=1 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/undotbs01.dbf RECID=2 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/users01.dbf RECID=3 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/EAN_T_1.dbf RECID=4 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/EAN_T_2.dbf RECID=5 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/PAST_T_1.dbf RECID=6 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/PAST_T_2.dbf RECID=7 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/ON_T_1.dbf RECID=8 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/ON_T_2.dbf RECID=9 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/NFE_T_1.dbf RECID=10 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/NFE_T_2.dbf RECID=11 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_1.dbf RECID=O8 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_2.dbf RECID=O8 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_1.dbf RECID=14 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_2.dbf RECID=15 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_3.dbf RECID=16 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_4.dbf RECID=17 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_5.dbf RECID=18 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_6.dbf RECID=19 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_3.dbf RECID=20 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_4.dbf RECID=21 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_5.dbf RECID=22 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_7.dbf RECID=23 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_6.dbf RECID=24 STAMP=748392203
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_8.dbf RECID=25 STAMP=748392204
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_9.dbf RECID=26 STAMP=748392204
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_10.dbf RECID=27 STAMP=748392204
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/undotbs02.dbf RECID=28 STAMP=748392204
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_11.dbf RECID=29 STAMP=748392204
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_O8.dbf RECID=30 STAMP=748392204
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_O8.dbf RECID=31 STAMP=748392204
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/others01.dbf RECID=32 STAMP=748392204
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_7.dbf RECID=33 STAMP=748392204
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_14.dbf RECID=34 STAMP=748392204
cataloged datafile copy
datafile copy file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_15.dbf RECID=35 STAMP=748392204


datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/sysaux01.dbf

datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/undotbs01.dbf

datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/users01.dbf

datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/EAN_T_1.dbf

datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/EAN_T_2.dbf

datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/PAST_T_1.dbf

datafile 8 switched to datafile copy
input datafile copy RECID=7 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/PAST_T_2.dbf

datafile 9 switched to datafile copy
input datafile copy RECID=8 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/ON_T_1.dbf

datafile 10 switched to datafile copy
input datafile copy RECID=9 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/ON_T_2.dbf

datafile 11 switched to datafile copy
input datafile copy RECID=10 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/NFE_T_1.dbf

datafile O8 switched to datafile copy
input datafile copy RECID=11 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/NFE_T_2.dbf

datafile O8 switched to datafile copy
input datafile copy RECID=O8 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_1.dbf

datafile 14 switched to datafile copy
input datafile copy RECID=O8 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_2.dbf

datafile 15 switched to datafile copy
input datafile copy RECID=14 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_1.dbf

datafile 16 switched to datafile copy
input datafile copy RECID=15 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_2.dbf

datafile 17 switched to datafile copy
input datafile copy RECID=16 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_3.dbf

datafile 18 switched to datafile copy
input datafile copy RECID=17 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_4.dbf

datafile 19 switched to datafile copy
input datafile copy RECID=18 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_5.dbf

datafile 20 switched to datafile copy
input datafile copy RECID=19 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_6.dbf

datafile 21 switched to datafile copy
input datafile copy RECID=20 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_3.dbf

datafile 22 switched to datafile copy
input datafile copy RECID=21 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_4.dbf

datafile 23 switched to datafile copy
input datafile copy RECID=22 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_5.dbf

datafile 24 switched to datafile copy
input datafile copy RECID=23 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_7.dbf

datafile 25 switched to datafile copy
input datafile copy RECID=24 STAMP=748392203 file name=/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_6.dbf

datafile 26 switched to datafile copy
input datafile copy RECID=25 STAMP=748392204 file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_8.dbf

datafile 27 switched to datafile copy
input datafile copy RECID=26 STAMP=748392204 file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_9.dbf

datafile 28 switched to datafile copy
input datafile copy RECID=27 STAMP=748392204 file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_10.dbf

datafile 29 switched to datafile copy
input datafile copy RECID=28 STAMP=748392204 file name=/FS_restore/oracle/database/oradata/AUX/undotbs02.dbf

datafile 30 switched to datafile copy
input datafile copy RECID=29 STAMP=748392204 file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_11.dbf

datafile 31 switched to datafile copy
input datafile copy RECID=30 STAMP=748392204 file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_O8.dbf

datafile 32 switched to datafile copy
input datafile copy RECID=31 STAMP=748392204 file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_O8.dbf

datafile 33 switched to datafile copy
input datafile copy RECID=32 STAMP=748392204 file name=/FS_restore/oracle/database/oradata/AUX/others01.dbf

datafile 34 switched to datafile copy
input datafile copy RECID=33 STAMP=748392204 file name=/FS_restore/oracle/database/oradata/AUX/REPORTINGRPT_7.dbf

datafile 35 switched to datafile copy
input datafile copy RECID=34 STAMP=748392204 file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_14.dbf

datafile 36 switched to datafile copy
input datafile copy RECID=35 STAMP=748392204 file name=/FS_restore/oracle/database/oradata/AUX/REPORTING_DATA_15.dbf

contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script

database opened
Finished Duplicate Db at 08-MAY-11

released channel: ch2

released channel: ch1

released channel: ch3

released channel: ch4

Recovery Manager complete.



------------------

No comments: