Oracle OCP 9i to 11g Storage Enhancements

  1. What is a bigfile tablespace?
    A tablespace with a single but very large datafile
  2. What are the storage limitations of bigfile tablespaces?
    Only locally managed with ASSM
  3. What is the largest possible size of a bigfile tablespace?
  4. What are the advantages of bigfile tablespaces?
    • MAXDATAFILES parmeter can be lower
    • SGA smaller for datafile information
    • Size of the controlfile is smaller
  5. If you attempt to create bigfile tablespace with EXTENT MANAGEMENT DICTIONARY or SEGMENT SPACE MANAGEMENT MANUAL what happens?
    An error is returned
  6. What happens is you attempt to create a second datafile in a bigfile tablespace?
    An error is returned
  7. What happens if one attempts to rename SYSTEM and SYSAUX tablespace?
    An error is returned
  8. What happens is you attempt to rename a temporary tablespace?
    It is renamed!!
  9. What happens if you attempt to rename a readonly tablespace?
    • Datafile headers are not updates with the new name
    • A message is written to the alertlog
  10. What happens if a single instance database is using a pfile rather than spfile?
    A message in alertlog stating pfile value must be changed
  11. What is the syntax for rename tablespace?
  12. What is the default tablespace for users in 11g
  13. How can one change the default tablespace?
  14. What is Oracle's Volume Manager better known as?
  15. What are the advantages of ASM?
    • Simplifies operations such as Creating databases and managing diskspace
    • Distributes data across physical disks for uniform performance
    • Rebalances data automatically
  16. What are ASM Disk Groups?
    A collection of ASM disk managed as a logical unit
  17. What are ASM Files?
    A files stored in an ASM disk group DB, control, redo etc
  18. What are ASM Extents?
    Raw storage holding contents of ASM file. Made up of ASM Allocation Units
  19. What are ASM Disks?
    • A storage device assigned to Oracle ASM disk group
    • Physical Disk or Partition
    • Logical Unit Number from storage array
    • Logical volume
    • Network attached file
  20. What is the fundamental unit within an ASM disk group?
    ASM Allocation Units
  21. Which background process coordinates disk activity on ASM instance?
  22. Which background process performs extent movement between disks in disk groups?
  23. Which background Processes performs comms between database and ASM instances
  24. Which background process performs open and close of the disk in diskgroup on behalf of instance?
  25. In ASM command line what is the command to copy files?
  26. In ASM command line what is the command to list disk visible to ASM?
  27. What command starts the ASM commandline interface?
  28. Which views does lsdsk in ASM commandline use?
  29. What is the default ASM SID for a single instance database?
  30. In RAC, how are ASM instances named?
  31. What must the instance_type parameter be set to when using ASM?
  32. What happens when STARTUP command is issues in an ASM instance?
    Oracle attempts to mount ASM disk groups
  33. What does STARTUP FORCE do in an ASM instance?
    Issues a SHUTDOWN ABORT to the Oracle ASM instance before restarting it.
  34. What does STARTUP MOUNT or OPEN do in an ASM instance?
    Mounts the disk groups specified in the ASM_DISKGROUPS initialization
  35. What does STARTUP NOMOUNT do in an ASM instance?
    Starts up the Oracle ASM instance without mounting any disk groups.
  36. What does STARTUP RESTRICT do in an ASM instance?
    Only users with both the CREATE SESSION and RESTRICTED SESSION system privileges can connect.
  37. What does SHUTDOWN IMMEDIATE or TRANSACTIONAL do in an ASM instance?
    • Waits for any in-progress SQL to complete
    • Dismounts all of the disk groups
    • Shuts down the Oracle ASM instance
  38. When will SHUTDOWN IMMEDIATE or TRANSACTIONAL result in an error in an ASM instance?
    When a database instance in connected.
  39. What does SHUTDOWN ABORT do in an ASM instance?
    • The instance immediately shuts down without the orderly dismount of disk groups
    • This requires recovery on the next Oracle ASM startup
    • Any connected database will also perform a shutdown abort
  40. what are the possible redundancy levels for a disk group?
    • NORMAL REDUNDANCY (2-way mirroring by default for most file types)
    • HIGH REDUNDANCY (3-way mirroring for all files)
    • EXTERNAL REDUNDANCY if you do not want mirroring by Oracle ASM
  41. When creating an ASM diskgroup, what must be specified?
    • A unique name
    • Redundancy Level
    • The disk to be formatted as an ASM disk
  42. When creating an ASM diskgroup, what is optionally specified?
    • Disks belonging to failure groups
    • The type of failure group
    • Disk group attributes
  43. Which view allows DBA to monitor the status of ASM rebalances?
  44. What command allows disks to be added to a disk group?
    ALTER DISKGROUP data ADD DISK '/devices/disk6' NAME disk6;
  45. What does ASM fast mirror resynch do?
    allows a disk group to restore redundancy quickly after a transient disk failure.
  46. What does disk attribute DISK_REPAIR_TIME do?
    • A period when disk failure occurs when the drive is taken offline, but not dropped.
    • Allows for errors like loose cable, brief power loss etc
  47. What happens if a "failed" disk comes back online within DISK_REPAIR_TIME?
    Only modified extents are resyncronised.
  48. What is the default DISK_REPAIR_TIME?
    3.6 hours
  49. In which view can DISK_REPAIR_TIME be found?
  50. What are the possible extent sizes in ASM
  51. If ASM variable extent sizes are being used, how do they increment?
    • First 20,000 1*AU
    • second 20,000 8*AU
    • Beyond that 64*AU
  52. What does ASM init parameter ASM_DISKGROUPS do?
    List the diskgroups ASM mounts at startup
  53. What does ASM init parameter ASM_DISKSTRINGS do?
    Limits the disks ASM can see using masking
  54. What does ASM init parameter ASM_POWER_LIMITS do?
    Specifies the power for disk rebalancing
  55. What are the ranges for the ASM init parameter ASM_POWER_LIMITS?
  56. How does one disable disk rebalancing?
  57. What is the INSTANCE_TYPE parameter for and ASM instance?
  58. What init parameter are NOT required for an ASM instance?
  59. What Oracle file are not supported in ASM?
    admin files including: trace files, audit files, alert logs, export files, tar files, and core files.
  60. What is the prescibed naming method in ASM?
  61. What is a alias filename?
    Alias filenames can be used for referencing existing files and creating new ASM files
  62. Where cannot alias filenames exist?
    At root level (+)
  63. What is a restriction of creating an ASM file using an alias?
    The file is not an Oracle Managed File. The file will have to be deleted manually when the tablespace is dropped.
  64. What is the command to drop a datafile?
    ALTER DISKGROUP data DROP FILE '+data/ocpdb/ocp_undo_ts';
  65. What is the command to create a datafile using an alias?
    CREATE UNDO TABLESPACE ocpundo DATAFILE '+data/ocpdb/ocp_undo_ts' SIZE 200M;
Card Set
Oracle OCP 9i to 11g Storage Enhancements
Oracle OCP 9i to 11g Storage Enhancements