Thursday, 17 November 2011

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 <spool /erptestdb/home/scripts/check_wf_mailer.log

set lines 1000
set head off
# column tablespace_name format a50
select COMPONENT_STATUS
from apps.FND_SVC_COMPONENTS
where component_type='WF_MAILER'
/

spool off
exit
!
#SCRIPT_DIR=/test/appl/homes/oratest/scripts

if [ -s $SCRIPT_DIR/check_wf_mailer.log ]; then
#COUNT=`cat check_ts.log | wc -l `
COUNT=0
STATUS=`cat $SCRIPT_DIR/check_wf_mailer.log | awk '{print $1}'`
VSTATUS='RUNNING'
echo "v status is: " $VSTATUS
echo "file is present"
echo "Script Dir: " $SCRIPT_DIR
echo "status is " $STATUS
if [ $STATUS != $VSTATUS ] ; then
echo "status is in the if stmt " $STATUS
mailx -s "Oracle Workflow Mailer is down in APPS R12, please check " appsdba@test.com < /erptestdb/home/scripts/check_wf_mailer.log

fi
fi

Thursday, 13 October 2011

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!

Saturday, 9 July 2011

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.

Thursday, 30 June 2011

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

---------

Sunday, 19 June 2011

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.

Saturday, 11 June 2011

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.

Wednesday, 11 May 2011

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

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

CookBook:

Following things were done to achieve the objective.

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

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

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

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

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


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

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

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

Following is the error messages which we got.

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

failover to previous backup

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

Recovery Manager complete.

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

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


Starting restore at 08-MAY-11

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

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

-----------

And following is the complete log of rman script.

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

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

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

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

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

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

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

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

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

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting Duplicate Db at O8-MAY-11

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

executing command: SET until clause

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

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

Oracle instance shut down

Oracle instance started

Total System Global Area 8554O87360 bytes

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

Starting restore at O8-MAY-11

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

executing command: SET until clause

Starting recover at O8-MAY-11

starting NFEia recovery

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

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

database dismounted
Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area 8554O87360 bytes

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

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

sql statement: alter system reset db_unique_name scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area 8554O87360 bytes

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


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

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

database opened
Finished Duplicate Db at 08-MAY-11

released channel: ch2

released channel: ch1

released channel: ch3

released channel: ch4

Recovery Manager complete.



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

Friday, 25 February 2011

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.

Monday, 31 January 2011

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