shell script to check if the Workflow mailer is down in APPS R12

Introduction: We can use the following shell script and can schedule it with crontab. It is very handy, it will check the workflow mailer and if it is down it will send email to APPS DBA. Cookbook: Following is the script. #!/bin/sh ## ORACLE_HOME=`cat /etc/var/opt/oratab | grep ^TESTDB: | cut -f2 -d':'` ORACLE_HOME=/erptest/TST/db/tech_st/11.1.0 export ORACLE_HOME ORACLE_SID=ERPTEST export ORACLE_SID PATH=$PATH:$ORACLE_HOME/bin:. export PATH SCRIPT_DIR=/erptestdb/home/scripts export SCRIPT_DIR # check_ts.log $ORACLE_HOME/bin/sqlplus -s test_user/test_user <

APPS R12.1.1 post cloning for Database Tier error - ORA-12547: TNS:lost contact

Introduction: On post cloning of database tier of APPS R12.1.1 , it ended with errors "ORA-12547: TNS:lost contact" Resolution: Following were the errors which we got in ApplyDbTier. =============== LD_LIBRARY_PATH : /erptst/TST/db/tech_st/11.1.0/lib:/usr/dt/lib:/usr/openwin/lib:/erptst/TST/db/tech_st/11.1.0/ctx/lib:/erptst/TST/db/tech_st/11.1.0/lib32 Executable : /erptst/TST/db/tech_st/11.1.0/bin/sqlplus The log information will be written to /erptst/TST/db/tech_st/11.1.0/appsutil/log/TST_testmachine/adcrdb_TST.txt Creating the control file for TST_testm1 database ... SQL*Plus: Release 11.1.0.7.0 - Production on Mon Oct 10 16:00:59 2011 Copyright (c) 1982, 2008, Oracle. All rights reserved. ERROR: ORA-12547: TNS:lost contact ORA-12547: TNS:lost contact ERROR: ORA-12547: TNS:lost contact ORA-12547: TNS:lost contact SP2-0640: Not connected ============================== We tried to connect from sqlplus but after few seconds of wait it again gave the same error. We checked the inventory location and permission and it was all ok. We tried again the post clone, but this time we choose the different SID as CLN and gave the different port number, previously it was 01 and this time we chose 79. And this time the post clone went successful without any errors, this is so weird, but this is just what happened!

Oracle Application APEX admin user password reset by script

Introduction: If you dont know the password for admin user of Oracle Application APEX, and if version of APEX is 3 or higer then the password of admin can be reset by a script. CookBook: There is script in the directory of apex softwae and the script name is apxchpwd.sql, this can be run with sys user on sqlplus and it will ask the new password for admin, just type the new password and use it.

Oracle Application APEX admin user

Introduction:
How to create a second amdin user for Oracle Application APEX.

CookBook:

1- unlock the account FLOWS_030000 and login with FLOWS_030000 to Database where APEX was installed.

2- run the following procedure

begin
wwv_flow_api.set_security_group_id(p_security_group_id=>10);
wwv_flow_fnd_user_api.create_fnd_user(
p_user_name => 'admin2',
p_email_address => 'admin2@test.com',
p_web_password => 'admin2') ;
end;
/

3- test the new admin account from the url

http:/appserver.test.com:7778/pls/apex/apex_admin

it will ask the new admin username and password, in our case the username is "admin2" and password is "admin2", once logged in, the APEX will ask to change the old password.

4- in case you dont know the password for FLOWS_030000, you can change the password and once run the procedure in point 2, the FLOWS_030000 should be locked.

To find the sid and serial# of a Concurrent Request in Oracle Financials R 11i and R12

Objective: Some times we need to kill a hang concurrent request, and to kill it, we need to find the sid and serial# of that concurrent request. Cookbook: Following SQL query can be run with APPS user on APPS Database , it will need to provide the concurrent request id, and then it will give the sid and serial# of that concurrent requests, more information can also be obtained from v$session and v$sqlarea views. Following is the SQL query ---------- SELECT ses.sid, ses.serial# FROM v$session ses, v$process pro WHERE ses.paddr = pro.addr AND pro.spid IN (SELECT oracle_process_id FROM fnd_concurrent_requests WHERE request_id = &request_id); ---------

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