Answer Posted / ravi shankar dwivedi

i am trying to give u the ans
use it and tell me if found problm.
----------------------------------------------
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 (all 3
files or any one file). 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
(for security).

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 'RCVCAT';

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.

No New Questions to Answer in this Category !!    You can

Post New Questions

Answer Questions in Different Category