Starting RMAN
Use RMAN to back up and restore an Oracle database.
About this task
In this example, the catalog database contains a registered target database. Start an RMAN session with this command:
$> rman target xxx/yyy@target rcvcat aaa/bbb@catalog
cmdfile bkdb.scr msglog bkdb.log RMAN starts in the sequence shown.
target xxx/yyy@target: connect to target database
using user xxx and password yyy with connect string target
rcvcat aaa/bbb@catalog: connect to catalog database
using user aaa and password bbb with connect string catalog
cmdfile bkdb.scr: run bkdb.scr script
msglog bkdb.log: log the output messages in bkdb.logTip: In the example, RMAN creates a log file, bkdb.log,
in the current working directory. If an error occurs, the error stack
is logged to the log file.
Attention: For
backup and restore operations in a Linux™ environment,
Oracle recommends that the Oracle LD_ASSUME_KERNEL variable
is set for the Oracle user. For example:
LD_ASSUME_KERNEL=2.4.21; export LD_ASSUME_KERNEL
After
a completed backup or restore operation, view the throughput rate
and encryption status for a backup object in the IBM® Storage Protect
server activity
log file. Run the IBM Storage Protect
server QUERY
ACTLOG command in the IBM Storage Protect
server administrative
client window. A message similar to the following is displayed:
08/03/11 12:41:27 ANE4991I (Session: 67, Node: MACHINE_ORC) DP Oracle AIX ANU0599 TDP for Oracle: (5508): =>() ANU2526I Backup details for backup piece /adsmorc//df_727444762_116_1 (database "orcl"). Total bytes processed: 9961472. Deduplicated: Yes. Bytes after deduplication: 2272805. Deduplication reduction: 77.18%. Compressed: Yes. Bytes after compression: 52253. Compressed by: 97.70%. Encryption: None. LAN-Free: No. Total bytes sent: 52253. Total data reduction: 99.48%. Total processing time: 00:00:01. Throughput rate: 9728.00Kb/Sec. (SESSION: 67)
08/03/11 16:23:08 ANE4991I (Session: 67, Node: MACHINE_ORC) DP Oracle Win64 ANU0599 TDP for Oracle: (5508): =>() ANU2526I Backup details for backup piece \adsmorc\orcnt\df_727444762_116_1 (database "orcl"). Total bytes processed: 9961472. Deduplicated: Yes. Bytes after deduplication: 2272805. Deduplication reduction: 77.18%. Compressed: Yes. Bytes after compression: 52253. Compressed by: 97.70%. Encryption: None. LAN-Free: No. Total bytes sent: 52253. Total data reduction: 99.48%. Total processing time: 00:00:01. Throughput rate: 9728.00Kb/Sec. (SESSION: 67)