Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

 

   
 

RMAN Begin Backup Command



Oracle Tips by Burleson

Oracle 10g RMAN Full Database Begin Backup Command

Oracle 10g allows all of the data files in the database to be placed in online backup mode using a single command:

SQL> ALTER DATABASE BEGIN BACKUP;

You no longer need to place each tablespace in online backup mode individually:

SQL> ALTER TABLESPACE user BEGIN BACKUP;
SQL> ALTER TABLESPACE example BEGIN BACKUP;

The ALTER DATABASE BEGIN BACKUP command places all data files in the database in online backup mode.  The database must be in mounted or open mode when you issue this command.

Example 1: Issue BEGIN BACKUP command when data files belonging to a tablespace are in READ-ONLY mode

SQL> alter tablespace users read only;

Tablespace altered.

SQL> alter tablespace users begin backup;
alter tablespace users begin backup
*
ERROR at line 1:
ORA-01642: begin backup not needed for read only tablespace 'USERS'

SQL> alter database begin backup;

Database altered.

Example 2: Issue BEGIN BACKUP command when data files belonging to a tablespace are in READ-ONLY mode

SQL> alter tablespace example offline;

Tablespace altered.

SQL> alter tablespace example begin backup;
alter tablespace example begin backup
*
ERROR at line 1:
ORA-01128: cannot start online backup - file 5 is offline
ORA-01110: data file 5: 'C:\ORACLE\ORADATA\GRID\EXAMPLE01.DBF'

 

RMAN Full Database Begin Backup Command

SQL> alter database begin backup;

Database altered.

The two examples above demonstrate that when you issue the ALTER DATABASE BEGIN BACKP command, any read-only and offline data files are simply skipped, and processing continues.

 

Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster



Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA   

 

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks