Primary/Mirror Issues
Paul Gathogo asked whether dropped tables, deleted data or a dropped dbspace on the primary chunk would be restored from the mirror. Keith Simmons, Art Kagel and Clifton Bean all answered no, since the mirror mirrors every change. Keith added that recovery needs a pre-deletion archive restore, or a table-level restore in version 10.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi all, Someone please advice me, when i drop a table from the primary chunk, or delete data inside tables from the primary chunk, will the tables or data get restored back automatically from the mirror chunks? What about if i drop a dbspace from the primary chunk, will this again get restored from the mirror chunk? Paul
On 08/02/07, PAUL GATHOGO <pgathogo@gmail.com> wrote: > Hi all, > > Someone please advice me, when i drop a table from the primary chunk, or > delete data inside tables from the primary chunk, will the tables or data get > restored back automatically from the mirror chunks? > > What about if i drop a dbspace from the primary chunk, will this again get > restored from the mirror chunk? > > Paul > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > Paul No. Provided both chunks are on-line they will remain in step with each other (effectivly they are visible as a single chunk with mirroring providing continuation/recovery in the event of disk failure (they are on separate spindles aren't they !! ) ). If one chunk (of the pair) goes off-line for any reason the remaining will continue to service the engine and be kept up to date. When the off-line chunks comes back on-line it will be refreshed from the up to date chunks. To recover deleted data as you suggest you need to either restore a pre-deletion archive and extract the data or, if you have V10, undertake a table level restore. Keith
No Paul, the objects on the mirror chunks will be dropped/deleted as well. Art S. Kagel ----- Original Message ----- From: Paul Gathogo <ids@iiug.org> At: 2/08 1:48:52 Hi all, Someone please advice me, when i drop a table from the primary chunk, or delete data inside tables from the primary chunk, will the tables or data get restored back automatically from the mirror chunks? What about if i drop a dbspace from the primary chunk, will this again get restored from the mirror chunk? Paul ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
The answer is "no" to both questions. The mirror is exactly that, it will reflect the actions taken upon the primary chunk. The purpose of the mirror is to backup the primary chunk. The only way it can do that is to contain exactly what is stored within the primary. Take care. Clifton -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of PAUL GATHOGO Sent: Thursday, February 08, 2007 12:48 AM To: ids@iiug.org Subject: Primary/Mirror Issues [8378] Hi all, Someone please advice me, when i drop a table from the primary chunk, or delete data inside tables from the primary chunk, will the tables or data get restored back automatically from the mirror chunks? What about if i drop a dbspace from the primary chunk, will this again get restored from the mirror chunk? Paul **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.