Home » RDBMS Server » Backup & Recovery » Recovery using copied oracle folder (Oracle 9i, windows 2003 server)
Recovery using copied oracle folder [message #540616] Tue, 24 January 2012 15:05 Go to next message
meetdileep
Messages: 4
Registered: January 2012
Location: India
Junior Member

Dear Friends,

Could any one help in opening the database with manually copied oracle data folders and files. Due to my server crashed we were forced to format the system. In that my friend by mistake copied the oracle folder (All data files, redo log files) manually instead of taking a backup in a procedural manner. Now we need to restore all the data. Would it be possible to restore the data with copied data file. If so how? Anybody please guide me how to restore my data back.

Thanks in Advance.

Dileep
Re: Recovery using copied oracle folder [message #540617 is a reply to message #540616] Tue, 24 January 2012 15:09 Go to previous messageGo to next message
BlackSwan
Messages: 26204
Registered: January 2009
Location: SoCal
Senior Member
It depends.

Was the database open & online when the datafiles were copied?

Re: Recovery using copied oracle folder [message #540618 is a reply to message #540617] Tue, 24 January 2012 15:14 Go to previous messageGo to next message
meetdileep
Messages: 4
Registered: January 2012
Location: India
Junior Member

yes the database was open and online.
Re: Recovery using copied oracle folder [message #540619 is a reply to message #540618] Tue, 24 January 2012 15:32 Go to previous messageGo to next message
BlackSwan
Messages: 26204
Registered: January 2009
Location: SoCal
Senior Member
>yes the database was open and online.

Even if the DB had archive mode enabled, it is likely that you have a fine collection of corrupted datafiles;
since the tablespaces were not placed into BACKUP mode prior to copying the datafiles.
Re: Recovery using copied oracle folder [message #540620 is a reply to message #540619] Tue, 24 January 2012 15:43 Go to previous messageGo to next message
meetdileep
Messages: 4
Registered: January 2012
Location: India
Junior Member

Thank you very much for the earlier reply.

Would it be possible any ways to recover the data? Kindly help me the possible ways.


I have tried to Create control file and assign the data files and redo log files to the backed up directory, finally after database mount it will say data file 1 need to be recovered to be consistent.

kindly help me to get out of this
Re: Recovery using copied oracle folder [message #540621 is a reply to message #540620] Tue, 24 January 2012 17:27 Go to previous messageGo to next message
ThomasG
Messages: 3208
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
IF the database was in archivelog mode you can try:

- restore all files
Then mount the database with:

startup nomount

alter database mount


then do an

RECOVER DATABASE UNTIL CANCEL


You will then be prompted with archived redo-log names. Confirm the name with enter if the archived redo log exist, otherwise enter "CANCEL" and enter.

then do an

ALTER DATABASE OPEN RESETLOGS


Re: Recovery using copied oracle folder [message #540622 is a reply to message #540620] Tue, 24 January 2012 17:38 Go to previous messageGo to next message
meetdileep
Messages: 4
Registered: January 2012
Location: India
Junior Member

As advised by you i have executed like this



SQL> recover database until cancel;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL> recover database until cancel using backup controlfile;
ORA-00279: change 103007360 generated at 01/13/2012 22:15:44 needed for thread
1
ORA-00289: suggestion : C:\ORACLE\ORADATA\ITOLL\ARCH_ITOLL_01087.ARC
ORA-00280: change 103007360 for thread 1 is in sequence #1087


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
c:\oracle\oradata\itoll\arch_itoll_01086.arcc'
ORA-01756: quoted string not properly terminated


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\ITOLL\SYSTEM01.DBF'


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\ITOLL\SYSTEM01.DBF'

I believe one of the archive file is missing. How to overcome that

Thanks in advance.
Re: Recovery using copied oracle folder [message #540632 is a reply to message #540622] Tue, 24 January 2012 23:13 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Once you went through all archived logs apply the onlinre redo logs.
So reexecute "recover database until cancel using backup controlfile" and give a redo log when Oracle asks you for a file.

Regards
Michel
Re: Recovery using copied oracle folder [message #540640 is a reply to message #540622] Wed, 25 January 2012 01:52 Go to previous messageGo to next message
John Watson
Messages: 7620
Registered: January 2010
Location: Global Village
Senior Member
You made a typing error:Quote:
c:\oracle\oradata\itoll\arch_itoll_01086.arcc'
ORA-01756: quoted string not properly terminated
therefore no recovery occured. Try again, without the quote.
And you had better check the filename too, why did you enter ....1086.arcc when you were prompted for ...1087.ARC ?

Re: Recovery using copied oracle folder [message #544443 is a reply to message #540640] Tue, 21 February 2012 15:45 Go to previous messageGo to next message
SPenn
Messages: 6
Registered: February 2012
Junior Member
Does this problem have a solution? I have the same problem and didn't want ask the same question if it has been answered.

Please advise.
Re: Recovery using copied oracle folder [message #544459 is a reply to message #544443] Tue, 21 February 2012 23:24 Go to previous message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Wed, 25 January 2012 06:13
Once you went through all archived logs apply the onlinre redo logs.
So reexecute "recover database until cancel using backup controlfile" and give a redo log when Oracle asks you for a file.

Regards
Michel

Previous Topic: Backup scenario Queries,Please help
Next Topic: database session for channel sbt_4 terminated unexpectedly
Goto Forum:
  


Current Time: Sun Oct 21 07:52:44 CDT 2018