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

what is the step for rmanbackup?

1 Answers  

---

What is Privilege Auditing ?

1 Answers  

---

What are the benefits of distributed options in databases ?

1 Answers  

---

What is Object Auditing ?

2 Answers  

---

What are the various type of snapshots ?

3 Answers  

---

How can you enable automatic archiving ?

2 Answers  

---

What are roles ? How can we implement roles ?

2 Answers  

---

What are the responsibilities of a Database Administrator ?

3 Answers  

---

What are the different Levels of Auditing ?

1 Answers  

---

What are the roles and user accounts created automatically with the database ?

1 Answers  

---

What are the steps to switch a database's archiving mode between NO ARCHIVELOG and ARCHIVELOG mode ?

1 Answers  

---

How can we reduce the network traffic ?

3 Answers   Keane India Ltd,

---