Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 

 
 

Oracle file group repository overview


Oracle Database Tips by Donald Burleson

 

Question:  I want to make incremental backups every night and track the relative generation of my backup data files.

 

I remember that IBM mainframes had generation data groups (GDG's), and I need to find a similar tool for Oracle where I can treat a groups of related files together and track their relative generation.  What is the equivalent if a GDG in Oracle, for tracking generations of related files?  I know about the RMAN retention

 

Answer: Starting in 10gr2 we see a push toward information provisioning tools and the new "file group repository" features which is very similar to a GDG, especially for the versioning of related datasets.  The new file group repository (FGR) allows you to create groups of related data (using the DBMS_FILE_GROUP package) and then track and version the data. 

 

This allows the Oracle DBA to use the file group repository to create incarnations of related files and manage them over time, as a single unit, dubbed a "version".

 

The Oracle documentation on information provisioning notes that the file group repository has special uses for Oracle Streams:

"Some data must be shared as it is created or changed, rather than occasionally shared in bulk.

 

Oracle Streams can stream data between databases, nodes, or blade farms in a grid and can keep two or more copies synchronized as updates are made."

The Oracle docs on information provisioning note the file group repository architecture with this simple example"

"In this scenario, a business sells books and music over the internet. The business runs weekly reports on the sales data in the inst1.net database and stores these reports in two HTML files on a computer file system.

 

The book_sales.htm file contains the report for book sales, and the music_sales.htm file contains the report for music sales.

 

The business wants to store these weekly reports in a file group repository at the inst2.net remote database.

 

Every week, the two reports are generated on the inst1.net database, transferred to the computer system running the inst2.net database, and added to the repository as a file group version.

 

The file group repository stores all of the file group versions that contain the reports for each week."

 

Description of Figure 16-5 follows


 

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts. 

You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.


 

 

��  
 
 
Oracle Training at Sea
 
 
 
 
oracle dba poster
 

 
Follow us on Twitter 
 
Oracle performance tuning software 
 
Oracle Linux poster
 
 
 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational