Home » RDBMS Server » Backup & Recovery » Archive log issue (oracle 9i,windows Xp)
Archive log issue [message #285721] Wed, 05 December 2007 07:01 Go to next message
SRIVASUWIN
Messages: 45
Registered: October 2006
Location: TRICHY
Member


Hi everybody,

May i know how to recover the dropped DDLs content and tablespaces by using archived logs.

At the time of archived log sequence # 53 We had 2 tablespace after that we have deleted those tablespaces now our current archived log sequence number is 57
we have tried to recover those two tablespace but recovery command shows the following below error

ORA-00277: illegal option to the UNTIL recovery flag LOG

Please help me how to recover those 2 tablespace by using archived logs without using any backups.


- Thanks in advance.


Re: Archive log issue [message #285734 is a reply to message #285721] Wed, 05 December 2007 07:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you have a backup?
Do you have all archived logs?
Are you in archivelog mode?
Hiw do you take your backup?
What is your Oracle version (at least 3 decimals).

Regards
Michel
Re: Archive log issue [message #285742 is a reply to message #285734] Wed, 05 December 2007 07:26 Go to previous messageGo to next message
SRIVASUWIN
Messages: 45
Registered: October 2006
Location: TRICHY
Member

We didn't have any backup, We are in archive log mode,yes we have all archived log for last 30 days our oracle version 9.0.1.0.1

There is anyway to recover our tablespace.


-Thank you.

Re: Archive log issue [message #285749 is a reply to message #285742] Wed, 05 December 2007 07:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You need to have all archived logs since the tablespace was created.
Is this the case?
If not, you can't.

Regards
Michel
Re: Archive log issue [message #285929 is a reply to message #285749] Thu, 06 December 2007 02:07 Go to previous message
SRIVASUWIN
Messages: 45
Registered: October 2006
Location: TRICHY
Member


Thank you michel i did.
Previous Topic: Scenarios When Control Files Are Lost
Next Topic: RMAN Recovery
Goto Forum:
  


Current Time: Sun Dec 04 19:04:45 CST 2016

Total time taken to generate the page: 0.07691 seconds