Oracle Backups
The simple way of backup, can be divided into logical backup, cold backup (offline backup), hot backup (online backup), in fact, cold backup and hot backup can also be called physical backup
According to the Backup tool, it can be divided into Exp/imp backup, OS copy, RMAN, third party tools, such as Veritas
1.3.1. exp/imp logical backup
Import/Export is the oldest surviving two command-line tool for Oracle, the right thing
optimum performance and availability [original book information]
Author: Geoff Ingram
Translator: Zhang Jianming
ISBN: 7-302-06424-5
Page Number: 592
Publisher: Wiley Publishing, Tsinghua University Press, original publishing house
Rating: Four stars
The subtitle of the book-"proven methods of getting the best performance and usability"-reveals the perspective the book faces.
Some chapters, such as stress testing and benchmarking/oracle highly available
, our test destination/ Global/oradata is built on one of the LUNs, uses 8 disks, and Raid10,stripe (that is, Ncol) is set to 4 with Veritas Volum Manager.
bonnie++-d/global/oradata-s 8192-m d2new-u Oracle
Using uid:1001, gid:101.
Writing with PUTC () ... done
Writing Intelligently...done
Rewriting...done
Reading with getc () ... done
Reading Intelligently...done
Start ' Em...done...done...done ...
Create files in sequential order...done.
St
better at performance. Data synchronization scenarios provided by third parties: Mainly according to the implementation mechanism is divided into two major categories: 1, using the method of mining database log to realizeThe market is used more, such as Quest Shareplex, DSG RealSync. This type of software is similar to Oracle's newly acquired Goldengate tool. 2, the use of related software at the storage level to replicateStorage vendors such as IBM,EMC can be implemented using Third-party stor
automatic monitoring, continuous capture and backup data changes, the database for hot backup even if the server added a punctuation mark, "UPM database bodyguards" can also be real-time, accurate backup down. The first time the software is run, the UPM database bodyguard "will make a full backup of the main database, then the main database has any changes, the software will immediately back to the station, to ensure real-time data synchronization, to achieve real-time database backup effect, t
available disks without human intervention, thereby reducing the likelihood of hot spots appearing.
Stripe width: Segments in redo log files can be subdivided (K for faster transfer rates), and for data files, bands are slightly larger (MB, to one-time
Transfer a large number of data blocks).
Buffering: ASM file system does not buffer, direct input/output.
Mirroring: If hardware mirroring is not available, software mirroring can be easily established.
Core asynchronous I/O: implementation
1.1 Nbu Backup Oracle
NBU Backup Oracle Steps
1, install the NBU client on the server where the Oracle database resides.
2. Modify Oracle Backup Database script
9.1.1 Modify Backup Scripts
Default script path generated after the client is installed:
Backup scripts in the NBU installation directory, Oracle data is generally the default location: C:\Program Files\veritas\netbackup\dbext\oracle\samples\rman
Copy the script to the C:\Scripts dire
replication, some are good at backup, while others have better performance in recovery and access control. Storage management software vendors tend to provide the most complete set of management packages. However, multi-platform support and optimal performance characteristics are not easy to achieve.
Several mirroring methods have been developed in the area of data replication. Many storage vendors provide a three-tier mirror structure, and VERITAS
large.Scenario: Small to restore on other servers Logical Backup features :Backup set is the structure and content information obtained from the database based on the query MySQL serviceBackup slower than physical backupThe data backup file is larger than the physical backup, because it is stored in a pure text, the data is not compressed, generally using gzip or tar compressionBackup and recovery granularity is more flexible, either at the service level (all databases) or some table in a libra
ready (full backup) --Archive log backups (Archivelog backup) --Incremental backups (Increment backup) Develop a reasonable backup strategy based on your business needs. Example: Archive backups once per night Incremental backup next day (large data volume) Weekly Full-time Common scenarios for Rman hot backup -Veritas NetBackUp + RMAN --IBM TSM + RMAN --EMC Legato + RMAN --Rman Script --Other ... Backup software uses: --Management with library
operations are faster under lock tables because MySQL does not empty the critical cache for locked tables until unlock table is called. Typically, the critical cache is emptied after each SQL statement.· If you are using a storage engine that does not support transactions in MySQL, you must use lock TABLES if you want to determine that there are no other threads between select and update. The example shown here requires lock TABLES for safe execution:· mysql> LOCK TABLES Trans READ, customer WR
cluster, node configuration is not the same, such as server model, CPU cores/frequency differences, etc., so more need to test to verify the robustness of the scheme.5) on-line maintenance is more complex and requires higher DBA requirements. Later, if you need to scale out horizontally, you have the same complexity and need the same human resources configuration.If the ASM solution is the natural advantage, I think that ASM does not need to synchronize the data through the San Network (third-p
Rman script back to the file system, the other is the use of specialized backup software for backup (usually backed up to the virtual library), such specialized backup software is: A:commvault, Chinese name is Cang B: Symantec Veritas NetBackup (NBU), C:HP Company's HPDP (Data Protector), d:oracle of OSB (Oracle Secure Backup) E:EMC Company's NE Tworker and Data Domain, F:IBM Company's TSM (Tivoli Storage Manager) has a problem with the backup of o
Application and database development Cluster also need HA software? The so-called cluster technology (Cluster), also translated into clusters, covering three technical directions: Highly AvailableHA(High availability); Load BalancingLB(Load Balance); High Performance ComputingHPC(High performance Computing). For the business sectorITapplications are primarily concerned with high availabilityHAand load BalancingLBthese two parts. In order to ensure high availability of the application, the operat
considerations, because the query business module may need to involve some intermediate processing, if you need to process in the database (depending on the application requirements and design), so reader DB still needs to be writable. Let's talk about the problem of data synchronization technology selection: There are many techniques for real-time data synchronization, based on the OS layer (for example, VERITAS VVR), storage-based replication (whic
Hibernate. And Db4o's excellent performance, let us believe: more OO does not necessarily sacrifice performance. Figure 1. HSQLDB Benchmark Test At the same time, db4o is characterized by the need for DBA management, small footprint, which is ideal for embedded applications and Cache applications, so since Db4o was released, it has quickly attracted a large number of users to use db4o for a wide variety of embedded systems, including mobile software, medical devices, and real-time control syst
applications on various servers (including Linux servers), this capability has exploded over the past two years. Although a virtualized system can use any backup system (including shell scripts) for backup, there are many software that is most suitable for virtualization backup.
For example, Symantec Veritas NetBackup allows administrators to take a single snapshot of a physical server and capture all virtualized servers running on this server witho
make comprehensive observation and judgment on the entire network connection system, in this way, network fault resolution efficiency can be improved. The difference between a smart switch and a traditional LAN switch is that a smart switch supports a dedicated "Blade" server with application functions.
These include Protocol sessions, remote images, tape simulation, and Intranet file and data sharing. From an architecture with additional processing capabilities for each port and highly integra
Problem Description:Rman> Run {2> Allocate channel T1 type ' Sbt_tape ';3> send ' NB_ORA_SERV=NETBACKUP,NB_ORA_CLIENT=HZ1 ';4> restore Controlfile to '/oracle11/oradata/control01.ctl ' from '/c-3201563006-20141026-02 ';5> release channel T1;6>}Allocated CHANNEL:T1Channel t1:sid=239 Device Type=sbt_tapeChannel T1:veritas NetBackup for Oracle-release 7.0 (2010010501)Sent command to CHANNEL:T1Starting restore at 29-oct-14Channel t1:restoring Control File
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.