Browse Prior Art Database

Compact Oracle database snapshots

IP.com Disclosure Number: IPCOM000228742D
Publication Date: 2013-Jul-03
Document File: 5 page(s) / 277K

Publishing Venue

The IP.com Prior Art Database

Related People

Devavrat Mittal: INVENTOR [+2]

Abstract

This idea proposes a method of including the archived logs necessary for database recovery in the database snapshot itself, by utilizing two snapshot technologies, one at the filesystem level and another at the volume level  

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 53% of the total text.

Page 01 of 5

Compact Oracle database snapshots

Devavrat Mittal Vinod Sairaman

Symantec Corporation

Abstract

This idea proposes a method of including the archived logs necessary for database recovery in the database snapshot itself, by utilizing two snapshot technologies, one at the filesystem level and another at the volume level

Copyright © 2013 Symantec Corporation. All rights reserved. 1


Page 02 of 5

Copyright © 2013 Symantec Corporation. All rights reserved. Symantec and the Symantec Logo are trademarks or registered trademarks of Symantec Corporation or its affiliates in the U.S. and other countries. Other names may be trademarks of their respective owners. For a full list of Symantec trademarks, please visit http://www.symantec.com/about/profile/policies/trademarks/currentlist.jsp

Any Symantec products described in this document are distributed under licenses restricting their use, copying, distribution, and decompilation /reverse engineering. No part of this document may be reproduced in any form by any means without prior written authorization of Symantec Corporation and its licensors, if any.

THE DOCUMENTATION IS PROVIDED "AS IS" AND ALL EXPRESS OR IMPLIED CONDITIONS, REPRESENTATIONS AND WARRANTIES, INCLUDING ANY IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR NON-INFRINGEMENT, ARE DISCLAIMED, EXCEPT TO THE EXTENT THAT SUCH DISCLAIMERS ARE HELD TO BE LEGALLY INVALID. SYMANTEC CORPORATION SHALL NOT BE LIABLE FOR INCIDENTAL OR CONSEQUENTIAL DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE OF THIS DOCUMENTATION. THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS SUBJECT TO CHANGE WITHOUT NOTICE.

Symantec Corporation 350 Ellis Street Mountain View, CA 94043 United States

http://www.symantec.com

Copyright © 2013 Symantec Corporation. All rights reserved. 2


Page 03 of 5

Compact Oracle database snapshots

Problem Statement

     Many tools provide a snapshot and cloning facility for Oracle databases using Storage stack features (for example, filesystem-level or volume-level snapshots). Typically, the Database snapshot feature requires an administrator to snapshot the database as well as the database archived logs, in order to be able to clone a database. While only a few archived log files are actually required, we need to snapshot the whole archive log storage unnecessarily. Many administrators do not like this. It turns out that there is a way this can be avoided.

Publication Description

     Today, when we talk about split mirror snapshots for an Oracle database, , we need to snapshot two distinct components:

1) Data (this is the set of volumes consisting of Oracle control files, data files and online redo log files)


2) Arch (this is the volume where local log archiving happens).

Even though only a few archived logs are required for recovery of the clone database (which is created from the snapshot), we still need a mirr...