SELECT STATUS, FILENAME
FROM V$BLOCK_CHANGE_TRACKING;
Mount the database and move the change tracking file to a location that has more space
ALTER DATABASE RENAME FILE
'/disk1/bct/RDBMS/changetracking/o1_mf_2f71np5j_.chg' TO
'/disk2/bct/RDBMS/changetracking/o1_mf_2f71np5j_.chg';
To make a long-term archival backup
===================================
RUN {
ALLOCATE CHANNEL c1
DEVICE TYPE sbt
PARMS 'ENV=(OB_MEDIA_FAMILY=archival_backup)';
BACKUP DATABASE
TAG quarterly
KEEP FOREVER # KEEP UNTIL TIME 'SYSDATE+365'
RESTORE POINT FY06Q4;
}
To back up backup sets from disk to tape
========================================
list backupset 3;
BACKUP device type sbt BACKUPSET ALL
DELETE INPUT;
BACKUP device type sbt BACKUPSET 1,2
DELETE INPUT;
To back up image copies from disk to tape
=========================================
BACKUP DATAFILE COPY FROM TAG monDBCopy;
BACKUP DEVICE TYPE sbt
TAG "quarterly_backup"
COPY OF DATABASE
DELETE INPUT;
ARCHIVELOG DELETION POLICY
==========================
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 3 TIMES TO DISK;
RMAN> backup archivelog all delete input;
RMAN-08138: WARNING: archived log not deleted - must create more backups
RMAN> delete archivelog all;
RMAN-08138: WARNING: archived log not deleted - must create more backups
BACKUP OPTIMIZATION
===================
CONFIGURE BACKUP OPTIMIZATION ON;
skipping archived log file /u01/app/oracle/product/11.2.0/db_1/dbs/arch/1_42_808520212.dbf; already backed up 1 time(s)
Advanced
=========
To limit the size of backup sets
================================
BACKUP DEVICE TYPE sbt
MAXSETSIZE 100M
ARCHIVELOG ALL;
To backup with multisection
===========================
run {
allocate channel c1 device type disk;
allocate channel c2 device type disk;
backup section size 100M database format '/u01/backup/full_%D_%s_%p_%T'
plus archivelog format '/u01/backup/arc_%D_%s_%p_%T';
}
To make a split mirror backup of a tablespace by using SUSPEND/RESUME
=====================================================================
SQL 'ALTER TABLESPACE users BEGIN BACKUP';
SQL 'ALTER SYSTEM SUSPEND';
SQL 'ALTER SYSTEM RESUME';
SQL 'ALTER TABLESPACE users END BACKUP';
CATALOG DATAFILECOPY '/dk2/oradata/trgt/users01.dbf'; # catalog split mirror
BACKUP DATAFILECOPY '/dk2/oradata/trgt/users01.dbf';
CHANGE DATAFILECOPY '/dk2/oradata/trgt/users01.dbf' UNCATALOG;
To make dual-mode encrypted backups
===================================
SET ENCRYPTION IDENTIFIED BY password ON FOR ALL TABLESPACES;
BACKUP DATABASE PLUS ARCHIVELOG;
To specify a backup duration
============================
BACKUP
DURATION 4:00
TABLESPACE users;
restore preview
===============
RESTORE DATABASE PREVIEW;
RESTORE ARCHIVELOG FROM TIME 'SYSDATE-7' PREVIEW;
RESTORE DATABASE PREVIEW SUMMARY;
RESTORE DATABASE validate header;
You can use RESTORE ... PREVIEW RECALL to instruct the me