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:
Recovery Manager: Release 188.8.131.52.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 ...