SQL Server 2008 error: The SQL Server failed to initialize VIA support library QLVipl.dll

Introduction:
The Network protocol VIA was enabled, and after that SQL Server 2008 didnt startup and on checking the event log file, the following error was in the log file.

SQL Server The SQL Server failed to initialize VIA support library QLVipl.dll

CookBook:
On disabling the network protocol VIA, when SQL Server 2008 was started from SQL Server Configuration Manager , it started successfully.

Oracle APPS R12 cloning issue

Introduction: Having successfully cloned the db Tier, when we tried to clone the APPS Tier, it gave the following errors. Uploading Metadata file /APPS/TST/apps/apps_st/appl/ad/12.0.0/admin/template/adctxinf.tmp Metadata file /APPS/TST/apps/apps_st/appl/ad/12.0.0/admin/template/adctxinf.tmp upload failed. Check log file created by FNDCPUCF program. ERRORCODE = 137 ERRORCODE_END .end std out. ld.so.1: FNDCPUCF: fatal: /APPS/TST/apps/tech_st/10.1.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 Killed ld.so.1: FNDCPUCF: fatal: /APPS/TST/apps/tech_st/10.1.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 Killed CookBook: When we checked the logs and error messages , we came to know that os user of the apps tier i.e. appltst doesnt have the permissions on the oraInventory location. Having made a new directory of oraInventory when we again ran the "perl adcfgclone.pl appsTier" it was all successful.

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. ------------------

login with sysdba ORA-01031: insufficient privileges

Introduction: If you try to connect with sysdba from client machine, it might give you the following error ORA-01031: insufficient privileges Cookbook: You need to create the password for in $ORACLE_HOME/dbs location, and following is an example to create the password file. $ orapwd file=$ORACLE_HOME/dbs/orapwSID password=type_password entries once you run this command on the Oracle Server, then again try to login from the client with sysdba, it will work.

RMAN-20002: target database already registered in recovery catalog

Introduction: We moved one the Oracle 10g database from one server to other server, and database was opened with "resetlogs" option. And when we tried to do the register the database it gave the following error "RMAN-20002: target database already registered in recovery catalog" Cookbook: To resolve the issue we issued the following command on rman prompt and then every thing was fine. Following are the errors and command which we ran ---------- RMAN> register database; starting full resync of recovery catalog full resync complete RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of register command on default channel at 01/29/2011 22:00:48 RMAN-20002: target database already registered in recovery catalog RMAN> reset database; database incarnation already registered ----------

Oracle 10g AS R2 Webcache error - Permission denied when setting group ID

Objective: On startup of the Oracle 10g AS R2 middle tier, we got the following errors. Error --> Process (pid=9185) failed to start a managed process after the maximum retry limit Log: /u04/ora9i/ora10gAS/mtier/opmn/logs/WebCache~WebCache~1 And when we checked from the Enterprise Manager and opmn status command, it was showing that Portal and WebCache failed to start. CookBook: When we checked the event.log file under $ORACLE_HOME/webcache/logs directory it was showing the following messages. [02/Oct/2010:04:15:21 +0300] [notification 9612] [ecid: -] OracleAS Web Cache 10g (10.1.2), Build 10.1.2.0.2 050802 [02/Oct/2010:04:15:21 +0300] [notification 9403] [ecid: -] Maximum number of file/socket descriptors set to 900. [02/Oct/2010:04:15:21 +0300] [notification 13002] [ecid: -] Maximum allowed incoming connections are 700 [02/Oct/2010:04:15:21 +0300] [alert 9526] [ecid: -] Permission denied when setting group ID ( staff ). [02/Oct/2010:04:15:21 +0300] [alert 13003] [ecid: -] Configuration error. Stopping admin or cache server. [02/Oct/2010:04:15:21 +0300] [alert 9000] [ecid: -] Process 8259 exit(1) at 589:xmlcfglsnr.c [Build 10.1.2.0.2 050802] We found the error "Permission denied when setting group ID ( staff )". and on checking the logged in user, we found that user has the group other than "staff". we reset the group to staff, and restarted the application and every thing was fine.

Oracle APPS R12 Post Cloning issue - Form not launching

Introduction:
We faced one of the issue, after successfull cloning of APPS R12.1.1, when we tried to open the form, it was not launching.

CookBook:

We did the following steps, and form started coming up.

1- Stopped the APPS Tier services.

2- rename the directory "tldcache" under following directories.

a- /binaries/INST_NAME/inst/apps/INST_NAME_MACHINE_NAME/ora/10.1.3/j2ee/oafm

b- /binaries/INST_NAME/inst/apps/INST_NAME_MACHINE_NAME/ora/10.1.3/j2ee/oacore

c- /binaries/INST_NAME/inst/apps/INST_NAME_MACHINE_NAME/ora/10.1.3/j2ee/forms

3- create the emplty directory with the name "tldcache" under the above directories.

4- restart the APPS Tier services.

5- test the issue.