|
How to take Backup
using RMAN
RMAN is an Oracle tool for taking the backup and recovering the
databases. You can copy, restore, and recover datafiles, control files and
archived redo logs. It has command line utility as well as GUI-based
Enterprise Manager Backup. Here we are discussing the command line
utility.
For example, we have TEST and PROD databases. Here TEST is the catalog
database and PROD is the target database for which the backup has to be
taken. You may loose your backup if you have your catalog and target
databases on the same box and the box crashes .So it is always advisable
to keep a separate database for RMAN catalog .
Create two databases. One for RMAN catalog(Test) and one target(PROD).
Both the Databases should be archive log mode.
In catalog database (test)
create a tablespace 'CATALOG'
create a user rman/rman and give the connect , resource,
recovery_catalog_owner
Also give unlimited quota on CATALOG tablespace.
Create recovery catalog
c:\rman catalog rman/rman@test log = create_rmanlog.log
Recovery Manager: Release 8.1.7.0.0 - Production
RMAN-06008: connected to recovery catalog database
RMAN-06428:
recovery catalog is not installed
RMAN>
RMAN> create catalog tablespace 'CATALOG';
RMAN-06431: recovery
catalog created
RMAN>
Register the database
c:\>rman catalog rman/rman@test target
internal/oracle@prod
Recovery Manager: Release 8.1.7.0.0 - Production
RMAN-06005:
connected to target database: PROD (DBID=4145212838)
RMAN-06008:
connected to recovery catalog database
RMAN> register database;
RMAN-03022: compiling command: register
RMAN-03023: executing
command: register
RMAN-08006: database registered in recovery catalog
RMAN-03023: executing command: full resync
RMAN-08002: starting
full resync of recovery catalog
RMAN-08004: full resync complete
Backup the datafile
RMAN> run{
Allocate channel c1 type disk;
Backup datafile
‘c:\orawin_815\oradata\prod\system01.dbf’ format
‘c:\backup\temp01.dbf’;
}
You can change the backup
fine format including the destination. In this example, this
backup file is created on the local drive of
the system. <
/P>
| 
