 |
|
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.
|
