Oracle & PostgreSQL - Developer & Administrator
Your Personal Trainer for Oracle & PostgreSQL
RMAN Command for Database Backup
** The database must be in Archivelog mode **
RMAN Command for Level 0 backup
run
{
allocate channel d1 device type disk format '/tmp/ORCL_L0_%U.bkp';
BACKUP AS COMPRESSED BACKUPSET incremental level 0 DATABASE PLUS ARCHIVELOG DELETE INPUT;
}
RMAN Command for Level 1 backup
run
{
allocate channel d1 device type disk format '/tmp/ORCL_L1_%U.bkp';
BACKUP AS COMPRESSED BACKUPSET incremental level 1 DATABASE PLUS ARCHIVELOG DELETE INPUT;
}
No comments:
Post a Comment
Home
Subscribe to:
Comments (Atom)
[ORACLE RMAN] - List Backup Commands
RMAN > LIST BACKUP; - Displays all backup sets, proxy copies, and image copies. RMAN > LIST BACKUP SUMMARY; - Provides a concise, one-...
No comments:
Post a Comment