The Oracle System ID (SID) is used to uniquely identify a particular database on a system. For this reason, one cannot have more than one database with the same SID on a computer system.
When using RAC, all instances belonging to the same database must have unique SID's.
http://www.orafaq.com/wiki/ORACLE_SID
Sunday, July 28, 2013
Sunday, July 21, 2013
Reporting
- JFreeChart is a free 100% Java chart library that makes it easy for developers to display professional quality charts in their applications. JFreeChart's extensive feature set includes:
- BIRT is an open source Eclipse-based reporting system that integrates with your Java/Java EE application to produce compelling reports.
- The JasperReports Library is the world's most popular open source reporting engine. It is entirely written in Java and it is able to use data coming from any kind of data source and produce pixel-perfect documents that can be viewed, printed or exported in a variety of document formats including HTML, PDF, Excel, OpenOffice and Word.
- Open Source Charting & Reporting Tools in Java
- Google Charts
- Jaspersoft Studio is the new Eclipse-based report designer for JasperReports and JasperReports Server.
http://community.jaspersoft.com/project/jaspersoft-studio
Saturday, July 20, 2013
Types of backup
Types of backup
Copy backup
A copy backup copies all the files you select, but does not mark each file as havingbeen backed up (in other words, the archive attribute is not cleared ). Copying is useful if you want to back up files between normal and incremental backups because copying does not affect these other backup operations.
Daily backup
A daily backup copies all the filesthat you select that have been modified on the day the daily backup is performed . The backed-up files are not marked as having been backed up (in other words, the archive attribute is not cleared ).
Normal backup
A normal backup copies all the files you select and marks each file as having been backed up (in other words, the archive attribute is cleared ). With normal backups, you only need the most recent copy of the backup file or tape to restore all of the files. You usually perform a normal backup the first time you create a backup set.
http://technet.microsoft.com/en-us/library/cc784306(v=ws.10).aspx
type of data backup that preserves data, saving only the difference in the data since the last full backup
A differential backup is a cumulative backup of all changes made since the last full backup, i.e., the differences since the last full backup.
The advantage to this is the quicker recovery time, requiring only a full backup and the last differential backup to restore the entire data repository.
The disadvantage is that for each day elapsed since the last full backup, more data needs tobe backed up, especially if a significant proportion of the data has changed, thus increasing backup time as compared to the incremental backup method.
http://en.wikipedia.org/wiki/Differential_backup
it is one that backs up only the data that changed since the last backup — be it a full or incremental backup
The most basic form of incremental backupconsists of identifying, recording and, thus, preserving only those files that have changed since the last backup. Since changes are typically low, incremental backups are much smaller and quicker than full backups. For instance, following a full backup on Friday, a Monday backup will contain only those files that changed since Friday. A Tuesday backup contains only those files that changed since Monday, and so on. A full restoration of data will naturally be slower, since all increments must be restored
http://en.wikipedia.org/wiki/Incremental_backup
a backup of all files that are new or changed since the last backup whether it was a full oran incremental .
The advantage ofan Incremental is that it takes the least amount of time and media of all the backup methods.
In the case of restoring with Incremental backups, all the Incremental backups since the last full backup plus the last full backup would be necessary.
A Differential backup backs up only the selected files that have their archive bit set to ON but does not set the archive bit back to OFF.
A Differential backup will back up all selected files that are new and changed since the last full backup.
at restore time; you'll need only the last full backup and the last differential to get a complete restore
Reference:
http://wiki.answers.com/Q/What_is_the_difference_between_an_incremental_backup_and_a_differential_backup
Bacula is a set of Open Source, computer programs that permit you (or the system administrator) to manage backup, recovery, and verification of computer data across a network of computers of different kinds
http://blog.bacula.org/
Bacula is an open source network backup solution that allows you create backups and perform data recovery of your computer systems.
it follows the server-client backup model;
we will focus more on the backup server and the backup clients than the individual Bacula components.
A Bacula server, which we will also refer to as the "backup server", has these components:
Bacula Director (DIR): Software that controls the backup and restore operations thatare performed by the File and Storage daemons
Storage Daemon (SD): Software that performs reads and writes on the storage devices used for backups
Catalog: Services that maintain a database of files thatare backed up. The database is stored in an SQL database such as MySQL or PostgreSQL
Bacula Console: A command-line interface that allows the backup administrator to interact with, and control, Bacula Director
Note: The Bacula server componentsdon't need to run on the same server, but they all work together to provide the backup server functionality.
A Bacula client, i.e. a server that willbe backed up, runs the File Daemon (FD) component.
Daemon is software that provides the Bacula server (the Director, specifically) access to the data that willbe backed up.
By default,Bacula is set to use the PostgreSQL library.
https://www.digitalocean.com/community/tutorials/how-to-install-bacula-server-on-centos-7
https://www.zmanda.com/amanda-community-edition.html
Copy backup
A copy backup copies all the files you select, but does not mark each file as having
Daily backup
A daily backup copies all the files
Normal backup
http://technet.microsoft.com/en-us/library/cc784306(v=ws.10).aspx
- Differential backup
A differential backup is a cumulative backup of all changes made since the last full backup, i.e., the differences since the last full backup.
The advantage to this is the quicker recovery time, requiring only a full backup and the last differential backup to restore the entire data repository.
The disadvantage is that for each day elapsed since the last full backup, more data needs to
http://en.wikipedia.org/wiki/Differential_backup
- Incremental backup
it is one that backs up only the data that changed since the last backup — be it a full or incremental backup
The most basic form of incremental backup
http://en.wikipedia.org/wiki/Incremental_backup
- An Incremental backup backs up only the selected files that have their archive bit set to ON, setting them back to OFF.
a backup of all files that are new or changed since the last backup whether it was a full or
The advantage of
A Differential backup backs up only the selected files that have their archive bit set to ON but does not set the archive bit back to OFF.
A Differential backup will back up all selected files that are new and changed since the last full backup.
at restore time; you'll need only the last full backup and the last differential to get a complete restore
Reference:
http://wiki.answers.com/Q/What_is_the_difference_between_an_incremental_backup_and_a_differential_backup
- The Bacula® Open Source Network Backup Solution
Bacula is a set of Open Source, computer programs that permit you (or the system administrator) to manage backup, recovery, and verification of computer data across a network of computers of different kinds
http://blog.bacula.org/
Bacula is an open source network backup solution that allows you create backups and perform data recovery of your computer systems.
it follows the server-client backup model;
we will focus more on the backup server and the backup clients than the individual Bacula components.
A Bacula server, which we will also refer to as the "backup server", has these components:
Bacula Director (DIR): Software that controls the backup and restore operations that
Storage Daemon (SD): Software that performs reads and writes on the storage devices used for backups
Catalog: Services that maintain a database of files that
Bacula Console: A command-line interface that allows the backup administrator to interact with, and control, Bacula Director
Note: The Bacula server components
A Bacula client, i.e. a server that will
Daemon is software that provides the Bacula server (the Director, specifically) access to the data that will
By default,
https://www.digitalocean.com/community/tutorials/how-to-install-bacula-server-on-centos-7
- Amanda Community Edition
https://www.zmanda.com/amanda-community-edition.html