FAST RECOVERY AREA
http://umardba.blogspot.com/2009/12/how-to-change-flash-recovery-area-to.html
sql> select value from v$parameter where name like ‘%db_recovery%;
sql> select value from v$paremeter where name=’control_files’;
sql> show parameter control_files;
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='+disk1' SCOPE=BOTH SID='*'; SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 10G SCOPE=BOTH;
SQL> startup mount
SQL> alter database archivelog;SQL> alter database open; sql> alter system switch logfile; rman> CONFIGURE CONTROLFILE AUTOBACKUP ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT; RMAN> show all; RMAN> list backup; RMAN> list expired backup;http://gavinsoorma.com/2009/12/11g-release-2-rman-backup-compression/RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET; RMAN> CONFIGURE COMPRESSION ALGORITHM ‘HIGH’; or RMAN> CONFIGURE COMPRESSION ALGORITHM ‘MEDIUM’; or RMAN> CONFIGURE COMPRESSION ALGORITHM ‘LOW’; or RMAN> CONFIGURE COMPRESSION ALGORITHM ‘BASIC’; Unfortunately, unless you have purchased the Advanced Compression Option, your only choice is BASIC.rman>list backup summary; rman>DELETE BACKUPSET
145913
,
145914
,
145915
,
145916
,
145917
;
rman>delete obsolete; rman> crosscheck backup; rman> crosscheck copy;rman> list archivelog all; rman> delete backup;rman> DELETE NOPROMPT ARCHIVELOG ALL;
rman> delete noprompt archivelog until time 'SYSDATE-10';SELECT * FROM v$recovery_file_dest; SELECT * FROM v$recovery_area_usage;
RMAN (Oracle docs) http://docs.oracle.com/cd/E29597_01/backup.1111/e10642/rcmmaint.htmORACLE 9i
rman> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup/ora_df%t_s%s_s%p'; Retention policy rman> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;