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 ;
Subscribe to:
Post Comments (Atom)
ALCATEL 6900
write memory copy running certified reload from working no rollback-timeout
-
grant execute on utl_http to wc grant execute on dbms_lock to wc; BEGIN DBMS_NETWORK_ACL_ADMIN.create_acl ( acl => ...
-
:system view system-view or sys :show all config dis current-configuration :create vlan vlan vlan_number :show ip interface ...
-
SET LLDP System NAME: system name ALL-Uplink system location SIAM-FL11 SHOW LLDP Configure: show lldp config or show lldp local-syste...
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.