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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.