OraFAQ Forum: Backup & Recovery » Archive log issue

Home » RDBMS Server » Backup & Recovery » Archive log issue (oracle 9i,windows Xp)

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

Archive log issue [message #285721]

Wed, 05 December 2007 07:01

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.

Report message to a moderator

Re: Archive log issue [message #285734 is a reply to message #285721]

Wed, 05 December 2007 07:18

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

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

Report message to a moderator

Re: Archive log issue [message #285742 is a reply to message #285734]

Wed, 05 December 2007 07:26

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.

Report message to a moderator