Q
Manage Learn to apply best practices and optimize your operations.

Which backup strategy should I use for my Oracle 10g database?

Database Backup and Recovery expert Brian Peasland explains how multiple backup strategies exist to backup an Oracle database.

I want to take a backup of our SAP production server which has Oracle Database 10g. How do I take the backup? And how do I increase tablespace?
There are multiple ways to backup an Oracle database. Each method has its pros and cons. The method you use depends on your recovery requirements. So you'll need to figure out what type of recovery scenarios you will need and then tailor your backup strategy to fit those needs. To understand more about these methods, please read the following document:

Oraclce Backup and Recovery Basics

To increase a tablespace's size, you can increase the datafile sizes associated with the tablespace. First, query the Data Dictionary to see the files associated with the tablespace:

 

 SELECT file_name,bytes FROM dba_data_files WHERE tablespace_name='ts_name';

Then increase the file's sizes with a command similar to the following:

 

 ALTER DATABASE DATAFILE '/directory/filename' RESIZE size;>
Where size is something like "100K", "10M" or "1G". Make sure the new size is larger than the old size. Alternatively, you can let the file automatically grow when it runs out of space by issuing the following:

 

 ALTER DATABASE DATAFILE '/directory/filename' AUTOEXTEND ON NEXT xxxM MAXSIZE yyyM;

The last alternative is to add a new datafile to the tablespace similar to the following:

 

 ALTER TABLESPACE ts_name ADD DATAFILE '/directory/filename' AUTOEXTEND ON NEXT xxxM MAXSIZE yyyM;

For more on Oracle backup and recovery:

Database storage management all-in-one guide: This learning guide will help you become an expert in backup and recovery.

Oracle 11g: Backup and Recovery concepts: Download this chapter to learn the basic concepts behind Oracle's backup and recovery mechanisms.

Dig Deeper on Oracle database administration

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close