Thursday, March 14, 2013

resize fast_recovery_area & clear archive log using RMAN

Resize fast_recovery area
==================
$ sqlplus / as sysdba

SQL>archive log list;
SQL>show parameter db_recovery_file_dest
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /u01/app/oracle/fast_recovery_
                                                 area
db_recovery_file_dest_size           big integer 8G

SQL> !du -ksh /u01/app/oracle/fast_recovery_area
  12G   /u01/app/oracle/c

SQL> alter system set db_recovery_file_dest_size=8G;
SQL> alter system switch logfile;


Clear Archive log used RMAN

=======================

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';

BACKUP FORMAT '/u02/rman_backup/%na_fullbackup_%U' TAG FULL_20130314 DATABASE PLUS ARCHIVELOG DELETE ALL INPUT;


Set Retention Policy
===============
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS ;

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

ALCATEL 6900

write memory copy running certified reload from working no rollback-timeout