How to use RMAN on AIX?
Using RMAN (Recovery Manager) on AIX (AIX) is the standard way to manage Oracle database backup, recovery, and media management on systems running on IBM Power Systems. RMAN works the same on AIX as on other UNIX systems, but performance and storage integration are often tuned for Power environments.
Below is a practical, enterprise-focused guide.
RMAN is used for:
👉 It replaces manual file copy backups.
Login as oracle:
su - oracle
Set environment:
export ORACLE_HOME=/u01/app/oracle/product/19c/dbhome_1
export ORACLE_SID=orcl
export PATH=$ORACLE_HOME/bin:$PATH
Connect to database:
rman target /
Or with password:
rman target sys/password@orcl
👉 This opens RMAN interface.
Basic backup:
BACKUP DATABASE;
BACKUP DATABASE PLUS ARCHIVELOG;
👉 Includes data + redo logs for full recovery.
Check mode:
ARCHIVE LOG LIST;
Enable if needed:
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
BACKUP ARCHIVELOG ALL;
Or delete after backup:
BACKUP ARCHIVELOG ALL DELETE INPUT;
👉 Prevents disk overflow.
BACKUP INCREMENTAL LEVEL 0 DATABASE;
BACKUP INCREMENTAL LEVEL 1 DATABASE;
👉 Reduces backup time and storage usage.
Set destination:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup/rman/%U';
On AIX:
Check backup integrity:
BACKUP VALIDATE DATABASE;
Or simulate restore:
RESTORE DATABASE VALIDATE;
👉 Ensures backups are usable.
RESTORE DATABASE;
RECOVER DATABASE;
👉 RMAN automatically applies archive logs.
Use cron:
0 2 * * * /u01/scripts/rman_backup.sh
Example script:
#!/bin/bash
rman target / <<EOF
BACKUP DATABASE PLUS ARCHIVELOG;
DELETE NOPROMPT OBSOLETE;
EOF
CONFIGURE DEVICE TYPE DISK PARALLELISM 4;
BACKUP AS COMPRESSED BACKUPSET DATABASE;
👉 Important for large Oracle workloads.
On IBM PowerVM:
iostat
With IBM PowerHA:
Check logs:
tail -f rman_backup.log
Oracle views:
V$RMAN_BACKUP_JOB_DETAILS
V$BACKUP_SET
AIX tools:
df -k → disk usage
iostat → I/O load
Enterprise Oracle on AIX:
👉 Result:
Using RMAN on AIX involves:
rman target /