
	Home > Ask the Oracle Database / Applications Experts > Oracle database backup and recovery Questions & Answers > Time required for hot backup of 80GB database

Ask The Oracle Expert: Questions & Answers

EMAIL THIS

Time required for hot backup of 80GB database

EXPERT RESPONSE FROM: Brian Peasland

		Pose a Question

		Other Oracle Categories

		Meet all Oracle Experts
		Become an Expert for this site

Oracle tips, scripts, and expert advice

Digg This! StumbleUpon Del.icio.us

QUESTION POSED ON: 08 May 2006
How much time will it take to take a hot backup of an 80GB database?

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Oracle database backup and recovery
	How to export triggers in an Oracle export command
	How to precreate Oracle table extents and define extent size
	How to trim the Oracle listener log in Unix/Linux
	How to avoid invalid objects in Oracle when restoring the database
	How to perform an Oracle 9i upgrade with the Database Upgrade Assistant
	How to avoid Oracle error ORA-00060 when dropping a datafile in Oracle 10g
	How to precreate tablespaces in Oracle before a new database import
	How to solve an Oracle import error
	How to use Transportable Tablespaces in Oracle to copy files quickly
	How to use Oracle table extents to allocate less disk space

Oracle database backup and recovery

How to export triggers in an Oracle export command

How to precreate Oracle table extents and define extent size

How to trim the Oracle listener log in Unix/Linux

How to avoid invalid objects in Oracle when restoring the database

How to perform an Oracle 9i upgrade with the Database Upgrade Assistant

How to avoid Oracle error ORA-00060 when dropping a datafile in Oracle 10g

How to precreate tablespaces in Oracle before a new database import

How to use Transportable Tablespaces in Oracle to copy files quickly

How to solve an Oracle import error

Exadata: A first look at Oracle's entry into the appliance market

Oracle database backup and recovery Research

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

The time it takes to back up your database depends on a number of factors. Are you backing up to tape or disk? Tape is slower than disk-based backups, which is why many DBAs back up to disk first and then offload the backup to tape later. Is there contention for disk resources? If others are using the database with a high disk I/O volume, then this can slow down your backup as the disk units will be satisfying user requests as well as performing your backup. Hot backups are typically taken during non-peak hours. The size of your database can impact your backup window. The larger your database, the longer it will take. In today's environments, 80GB is not a very large database, so this should not take too long to back up. I cannot say the exact time since there are many factors at play.

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

Oracle White Papers: Fusion Middleware

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2003 - 2009, TechTarget \| Read our Privacy Policy