Rogerio Antonio

 FRA – Flash Recover area   Central location for backup data Logs Archive logs Backups Control file Location a ASM filesystem Allow RMAN Retention policies Parameters DB_RECOVERY_FILE_DEST DB_RECOVERY_DEST_SIZE  How to ..  --- check the flash_recovery_area parameters SQL> show parameter DB_RECOVERY_FILE_DEST NAME                                             TYPE               VALUE ------------------------------------         -----------         ------------------------------ db_recovery_file_dest                string              /u01/app/oracle/flash_recovery_area db_recovery_file_dest_size       big integer     3852M SQL> col name form a30 col value form a30 select name, value from v$parameter where name like 'log_arc%' order by 1 asc NAME                           VALUE ------------------------------ ------------------------------ log_archive_config log_archive_dest l... log_archive_dest_31 .. l

ASM - Automatic Storage Management Is a LVM   (Logical Volume Manager) that provides storage abstraction layer The  RDBMS  see only Diskgroups (set of  RAW disks ) Can’t  store binaries on Diskgroups Uses OMF (Oracle Managed Files) Striping Coarse - 1MB allocation units | OLTP | small IO Fine - 128 kb allocation units | Data warehouses | high IO Allows three Redundancy types High Normal External Installed in separated dedicated instance (+ASM) as part of Grid Infrastructure No DB or data dictionary => +ASM instance will be mount never open Where the users are saved?  Password file. Managed by users with SYSASM role Specific processes RBAL - Coordinates disk activity for disk groups (Rebalance Master)  ARBn - Perform the extent movement (Rebalance "Slave") ASMB -  Perform the communication between database and the ASM instance ASM  + RMAN Backup ASM disks Migrate databases from OS filesystem to ASM ASM Utility ASMCMD