OraFAQ Forum: Backup & Recovery » Error in database cloing

Home » RDBMS Server » Backup & Recovery » Error in database cloing (orale ,9.2.0 ,linux 4 enterprese edition)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error in database cloing [message #463769]

Sat, 03 July 2010 05:17

noorkhanan
Messages: 3
Registered: June 2007
Location: Pakistan

Junior Member

Dears all,

I am cloning source database of 9i on target machine
when it completed up 70% it give errors.
actually i am using application 11i with database 9i.
when i check my v$datafile i found these three datafile
with values of
UNRECOVERABLE_CHANGE# UNRECOVERABLE_TIME NAME
5965393029349 6/29/2010 12:03:02 AM /roddata/a_txn_data02.dbf
5965393026407 6/29/2010 12:01:41 AM /roddata/a_txn_data01.dbf
5965389237343 6/25/2010 12:01:28 AM /proddata/a_txn_data03.dbf

and all other data files having 0 unrecoveralbe_chagne#.
as i know that some unrecoverable changes occurs on it.now how i chage it to zaro as other.as may database is runing in archiveing mode.and this is occuring when database in archiveing mode.

i only need to know that how i recover this changes.or did i recreate control file.

i need yours respectfully advice and help

Report message to a moderator

Re: Error in database cloing [message #463771 is a reply to message #463769]

Sat, 03 July 2010 05:18

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> when it completed up 70% it give errors.
What errors?
How are you cloning? RMAN?
Post the script you are using.
Copy and paste the exact session with output.

Report message to a moderator

Re: Error in database cloing [message #463772 is a reply to message #463769]

Sat, 03 July 2010 05:19

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

And please stop creating a dozen threads with the same message.

Report message to a moderator

Re: Error in database cloing [message #463779 is a reply to message #463772]

Sat, 03 July 2010 06:47

noorkhanan
Messages: 3
Registered: June 2007
Location: Pakistan

Junior Member

thanks Mahesh for reply.

i simeply run perl adcfgclone.pl dbTier

Target hostname [test]:test
[oraprod@test bin]$ perl adcfgclone.pl dbTier
Enter the APPS password [APPS]:
apps

First Creating a new context file for the cloned system.
The program is going to ask you for information about the new system:

Provide the values required for creation of the new Database Context file.

Do you want to use a virtual hostname for the target node (y/n) [n] ?:y

Target hostname [test]:test

Target instance is a Real Application Cluster (RAC) instance (y/n) [n]:

Target System database name [TEST]:TEST

Target system RDBMS ORACLE_HOME directory [/data1/prod/proddb/9.2.0]:

Target system utl_file accessible directories list [/usr/tmp]:

Number of DATA_TOP's on the target system [1]:

Target system DATA_TOP 1[/data1/prod/proddata]:

Do you want to preserve the Display set to test:0.0 (y/n) [y] ?:n

Target system Display [test:0.0]:

Clone Context uses the same port pool mechanism as the Rapid Install
Once you choose a port pool, Clone Context will validate the port availability.

Enter the port pool number [0-99]:
2

Checking the port pool 2
done: Port Pool 2 is free
Database port is 1523

Backing up /data1/prod/proddb/9.2.0/appsutil/TEST_test.xml to /data1/prod/proddb
/9.2.0/appsutil/TEST_test.xml37.bak

Creating the new Database Context file from :
/data1/prod/proddb/9.2.0/appsutil/template/adxdbctx.tmp

The new database context file has been created :
/data1/prod/proddb/9.2.0/appsutil/TEST_test.xml

Log file located at /data1/prod/proddb/9.2.0/appsutil/clone/bin/CloneContext_051
71117.log

Running Rapid Clone with command:
perl /data1/prod/proddb/9.2.0/appsutil/clone/bin/adclone.pl java=/data1/
prod/proddb/9.2.0/appsutil/clone/bin/../jre mode=apply stage=/data1/prod/proddb/
9.2.0/appsutil/clone/bin/.. component=dbTier method=CUSTOM dbctxtg=/data1/prod/p
roddb/9.2.0/appsutil/TEST_test.xml showProgress contextValidated=true

Beginning database tier Apply - Mon May 17 11:18:04 2010
Log file located at /data1/prod/proddb/9.2.0/appsutil/log/TEST_test/ApplyDBTier_
05171118.log
RC-50004: Fatal: Error occurred in ApplyDatabase:
Control file creation failed
\ 70% completed
ERROR while running Apply...

ERROR: Failed to execute /data1/prod/proddb/9.2.0/appsutil/clone/bin/adclone.pl

Please check logfile.

Report message to a moderator

Re: Error in database cloing [message #463781 is a reply to message #463779]

Sat, 03 July 2010 06:56

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Ah!. This is application thingy.
>> Please check logfile.
More diagnostic information should be available here.
A quick search in forum got me this. Please see if this helps.
http://www.orafaq.com/forum/t/141400/2/

Report message to a moderator

Re: Error in database cloing [message #463786 is a reply to message #463781]

Sat, 03 July 2010 08:14

noorkhanan
Messages: 3
Registered: June 2007
Location: Pakistan

Junior Member

Dear Mahesh ,

I studyed that like but i didn't got any information which helpful for me.
i think i am getting error due to UNRECOVERABLE_CHANGE# of datafiles.
if i recover this this error.i think cloning will be ok.as every day at the same time this
UNRECOVERABLE_CHANGE# fires.
if possible please brief me regarding it.

Report message to a moderator

Re: Error in database cloing [message #463981 is a reply to message #463786]

Mon, 05 July 2010 09:21

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>/data1/prod/proddb/9.2.0/appsutil/log/TEST_test/ApplyDBTier_05171118.log

Post the above log details

Babu

Report message to a moderator

Previous Topic:	Recovery after INDEX rebuild.
Next Topic:	failure of backup command

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 01:45:31 CDT 2024