Oracle & PostgreSQL - Developer & Administrator
Your Personal Trainer for Oracle & PostgreSQL
Search This Blog
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:
Posts (Atom)
Oracle Dataguard – Views to check the Status & Apply Lags
V$DATAGUARD_STATS SELECT NAME, VALUE, TIME_COMPUTED FROM V$DATAGUARD_STATS WHERE NAME IN ('apply lag', 'transport lag’); V$MAN...
No comments:
Post a Comment