Home » RDBMS Server » Backup & Recovery » cold backup recovery (Oracle 10g)
cold backup recovery [message #450769] Fri, 09 April 2010 02:37 Go to next message
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
Re: cold backup recovery [message #450865 is a reply to message #450769] Fri, 09 April 2010 16:37 Go to previous messageGo to next message
babuknb
Messages: 1729
Registered: December 2005
Location: NJ
Senior Member

Post your pfile and controlfile.sql

Babu
Re: cold backup recovery [message #450870 is a reply to message #450769] Fri, 09 April 2010 17:06 Go to previous messageGo to next message
BlackSwan
Messages: 22725
Registered: January 2009
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

Re: cold backup recovery [message #450875 is a reply to message #450769] Sat, 10 April 2010 02:43 Go to previous messageGo to next message
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
Re: cold backup recovery [message #453284 is a reply to message #450769] Wed, 28 April 2010 02:50 Go to previous messageGo to next message
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 .
Re: cold backup recovery [message #459264 is a reply to message #453284] Fri, 04 June 2010 03:52 Go to previous message
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...
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:
  


Current Time: Tue Sep 02 03:24:22 CDT 2014

Total time taken to generate the page: 0.23686 seconds