removed database
A user on IDS 9.4 found one of his databases had vanished and asked how to find information about a dropped/deleted database. No single confirmed fix is recorded, but respondents offered recovery options: restore the instance to a separate machine, roll logs forward to a point in time when the database still existed, then unload and reload the data into the original server; or (on v10) recreate an empty database and use point-in-time table-level restore, recovering systables/syscolumns first to rebuild the schema, then the user tables and indexes. Another noted that raw forensic recovery from IDS disk structures might be possible but only if acted on quickly before pages are overwritten.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
hello all, where can i find information about a removed or deleted database? i have several databases on ids 9.4 server and somehow one of them has been removed (is missing). thax in advance shahram
Off topic but on Version 10 Point In Time Table Level Restore could be used for a dropped table. What about a dropped database? If you created the database back empty could you do a PITTLR for each table?
shahram said: > hello all, > > where can i find information about a removed or deleted database? i have > several databases on ids 9.4 server and somehow one of them has been > removed (is missing). Just hop in your De Lorean and head back in time! ;o) -- Bye now, Obnoxio Information within this post contains forward looking statements within the meaning of Section 27A of the Securities Act of 1933 and Section 21B of the S E C Act of 1934. Statements that involve discussions with respect to projections of future events are not statements of historical fact and may be forward looking statements. Don't rely on them to make a decision. The poster is not a reporting company registered under the Exchange Act of 1934. I have received a life peerage from Her Majesty, who is not an officer, minister or affiliate Labour party member. I intend to recover my loan now, which could cause the parliamentary majority to go down, resulting in losses for you. Today's Labour party has: an accumulated deficit and a reliance on loans from officers and affiliates to pay expenses. It is not an operating political party. The party is going to need financing to continue as a going concern. A failure to finance could cause the party to go out of business. This report shall not be construed as any kind of investment advice or solicitation. You can lose all your money by investing in this party.
shahram wrote > where can i find information about a removed or deleted > database? i have > several databases on ids 9.4 server and somehow one of them has been > removed (is missing). > I assume, your other databases have been active all the time. So a Point in Time (PIT) restore of the system is probably not an otpion for you. But you can restore the system to a different site, roll forward the logs up to a PIT where you are sure the DB exists . The unload it and reload it into your orginial system. Regards Tilman
"If you created the database back empty could you do a PITTLR for each table? " Yes! If you cannot remember the database schema - Create an empty database with two tables that match systables/syscolumns - PITR back systables, syscolumns into these 2 tables - Use these to create the other sys* tables as other table names - PITR the other system tables - Use these to create the schema for the other tables with no indexes/constraints etc. - PITR the other tables - Use the sys* tables to crteate indexes etc. Art Kagel, Could do change myschema to have an option to extract the schema from the renamed sys* tables? Perhaps r_sys... rather than sys..??? David.
shahram wrote: > hello all, > > where can i find information about a removed or deleted database? i have > several databases on ids 9.4 server and somehow one of them has been > removed (is missing). > > thax in advance > shahram One could go looking for the (important) remainders of your database, but that would really be detective or forensic work for someone familiar with IDS disk structures. Depending on the value of the lost data ... it might be worth the efforts. And: the sooner the better of course, otherwise things will be overwritten and lost forever. Andreas