OraFAQ Forum: Backup & Recovery » Recovery using copied oracle folder

Home » RDBMS Server » Backup & Recovery » Recovery using copied oracle folder (Oracle 9i, windows 2003 server)

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

Recovery using copied oracle folder [message #540616]

Tue, 24 January 2012 15:05

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

Report message to a moderator

Re: Recovery using copied oracle folder [message #540617 is a reply to message #540616]

Tue, 24 January 2012 15:09

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It depends.

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

Report message to a moderator

Re: Recovery using copied oracle folder [message #540618 is a reply to message #540617]

Tue, 24 January 2012 15:14

meetdileep
Messages: 4
Registered: January 2012
Location: India

Junior Member

yes the database was open and online.

Report message to a moderator

Re: Recovery using copied oracle folder [message #540619 is a reply to message #540618]

Tue, 24 January 2012 15:32

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Recovery using copied oracle folder [message #540620 is a reply to message #540619]

Tue, 24 January 2012 15:43

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

Report message to a moderator

Re: Recovery using copied oracle folder [message #540621 is a reply to message #540620]

Tue, 24 January 2012 17:27

ThomasG
Messages: 3212
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

Report message to a moderator

Re: Recovery using copied oracle folder [message #540622 is a reply to message #540620]

Tue, 24 January 2012 17:38

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.

Report message to a moderator

Re: Recovery using copied oracle folder [message #540632 is a reply to message #540622]

Tue, 24 January 2012 23:13

Michel Cadot
Messages: 68748
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Recovery using copied oracle folder [message #540640 is a reply to message #540622]

Wed, 25 January 2012 01:52

John Watson
Messages: 8968
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 ?

Report message to a moderator

Re: Recovery using copied oracle folder [message #544443 is a reply to message #540640]

Tue, 21 February 2012 15:45

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.

Report message to a moderator

Re: Recovery using copied oracle folder [message #544459 is a reply to message #544443]

Tue, 21 February 2012 23:24

Michel Cadot
Messages: 68748
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 06:51:05 CDT 2025