Back Up XML DB with RMAN

RMAN is the recommended solution to back up Oracle XML DB. RMAN provides comprehensive backup and recovery support for all Oracle data, including XMLTypes. Let’s go through the basic steps to run RMAN.

To set up RMAN, we first need to start the RMAN client with the rman command:

D:\>rman

Recovery Manager: Release 11.2.0.2.0 - Production on Wed Jun 2 20:21:47 2010 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. RMAN>

Then connect from the RMAN client to the target Oracle database using the connect target command. The following is an example:

RMAN> connect target sys@orcl11g

target database Password:

connected to target database: ORCL11G (DBID=815923617)

The Oracle Net service name is used ...

Get Oracle Database 11g Building Oracle XML DB Applications now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.