Home » RDBMS Server » Server Administration » archive/redologfile
archive/redologfile [message #58058] Tue, 29 July 2003 03:37 Go to next message
jack
Messages: 123
Registered: September 2000
Senior Member
hi can i recover a table's data if someone is droped acciently the table.the database already running in archived mode.The changes to the database will be written to redologfile then a logswitch occurs the contents will be archived .whether i will get those table data whena media failure occurs.it was not archived the changes in redologfiles logswitch did'nt happened when a media failure occurs
pls hlp

Report message to a moderator

Re: archive/redologfile [message #58060 is a reply to message #58058] Tue, 29 July 2003 04:00 Go to previous message
Shesh
Messages: 16
Registered: July 2003
Junior Member
Restore the backup files and do Time based recovery till the time the table was dropped.

Report message to a moderator

Previous Topic: Stand by database STATUS::::::::?
Next Topic: Password Management
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 06:28:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.