| 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.
|
|
|
|
|
|
| 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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
