To continue reading for free, register below or login
To read more you must become a member of SearchOracle.com
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.
|
