Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


what is the step for rmanbackup?



what is the step for rmanbackup?..

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.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Security Interview Questions

What is default tablespace ?

3 Answers  


What are the system resources that can be controlled through Profile ?

3 Answers  


What is the use of ANALYZE command ?

3 Answers  


What is Auditing ?

3 Answers  


What is user Account in Oracle database ?

2 Answers  






What are the options available to refresh snapshots ?

2 Answers  


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

1 Answers  


what is snapshot log ?

2 Answers  


What are the use of Roles ?

3 Answers  


How can you Enforce Refrencial Integrity in snapshots ?

1 Answers  


What is Statement Auditing ?

2 Answers  


what is different between view and sequence?

4 Answers  






Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (509)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)