OraFAQ Forum: Backup & Recovery » cold backup recovery

Home » RDBMS Server » Backup & Recovery » cold backup recovery (Oracle 10g)

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

cold backup recovery [message #450769]

Fri, 09 April 2010 02:37

gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai

Member

Hi,

i am cloning the database using coldbackup.

I am getting the following errors:
SQL> @controlfile.sql
CREATE CONTROLFILE SET DATABASE "DEVLDB" RESETLOGS NOARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01159: file is not from same database as previous files - wrong database id
ORA-01110: data file 24: '/storage/devl/oddata/proddata/APPS_TS_TX_DATA24.dbf'

Steps i did:
copy coldbackup files from prod to test database.
taken controlfile trace and copy to test.
SQL>startup nomount pfile='pfile_i_had_created';
SQL> @controlfile.sql

Kindly guide me to solve the issue.

Thanks

Report message to a moderator

Re: cold backup recovery [message #450865 is a reply to message #450769]

Fri, 09 April 2010 16:37

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Post your pfile and controlfile.sql

Babu

Report message to a moderator

Re: cold backup recovery [message #450870 is a reply to message #450769]

Fri, 09 April 2010 17:06

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>i am cloning the database using coldbackup.
EXCUSE ME!

Opening the cloned DB should be done EXACTLY as is done with the source DB.
The new datafiles do not know or care they reside on a new system.

just open both DBs normally.

sqlplus
/ as sysdba
startup

Report message to a moderator

Re: cold backup recovery [message #450875 is a reply to message #450769]

Sat, 10 April 2010 02:43

gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai

Member

Hi All,

Thanks for the update given.

I solved the prob.

I just again restored the datafiles from the target DB location to test DB location, run the create controlfile(same used , with the first time created).

But the cause is still unknown to me.

Thanks

Report message to a moderator

Re: cold backup recovery [message #453284 is a reply to message #450769]

Wed, 28 April 2010 02:50

zodiacsom
Messages: 37
Registered: December 2009
Location: pune

Member

check file location in both pfile and control file and make sure they exist physically there at specific location .

Report message to a moderator

Re: cold backup recovery [message #459264 is a reply to message #453284]

Fri, 04 June 2010 03:52

sureshramasamy
Messages: 2
Registered: June 2010
Location: Bangalore

Junior Member

hi
i want to take the automating hotbackup through the crontab in linux

.sh file was created in that bellow script

* * * * * /home/oracle/hot.sh > /home/oracle/oracle/new.log

But new.log file was doesn't created

so give me some tips...

Report message to a moderator

Previous Topic:	CREATE CONTROLFILE failed, physical block size 2048 does not match size 512 of other members
Next Topic:	logical vs physical corruption

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 22 15:17:50 CDT 2025