-
What is a bigfile tablespace?
A tablespace with a single but very large datafile
-
What are the storage limitations of bigfile tablespaces?
Only locally managed with ASSM
-
What is the largest possible size of a bigfile tablespace?
128TB
-
What are the advantages of bigfile tablespaces?
- MAXDATAFILES parmeter can be lower
- SGA smaller for datafile information
- Size of the controlfile is smaller
-
If you attempt to create bigfile tablespace with EXTENT MANAGEMENT DICTIONARY or SEGMENT SPACE MANAGEMENT MANUAL what happens?
An error is returned
-
What happens is you attempt to create a second datafile in a bigfile tablespace?
An error is returned
-
What happens if one attempts to rename SYSTEM and SYSAUX tablespace?
An error is returned
-
What happens is you attempt to rename a temporary tablespace?
It is renamed!!
-
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
-
What happens if a single instance database is using a pfile rather than spfile?
A message in alertlog stating pfile value must be changed
-
What is the syntax for rename tablespace?
ALTER TABLESPACE atbs RENAME TO btbs;
-
What is the default tablespace for users in 11g
USERS
-
How can one change the default tablespace?
ALTER DATABASE DEFAULT TABLESPACE data1;
-
What is Oracle's Volume Manager better known as?
ASM
-
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
-
What are ASM Disk Groups?
A collection of ASM disk managed as a logical unit
-
What are ASM Files?
A files stored in an ASM disk group DB, control, redo etc
-
What are ASM Extents?
Raw storage holding contents of ASM file. Made up of ASM Allocation Units
-
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
-
What is the fundamental unit within an ASM disk group?
ASM Allocation Units
-
Which background process coordinates disk activity on ASM instance?
RBAL
-
Which background process performs extent movement between disks in disk groups?
ARBn
-
Which background Processes performs comms between database and ASM instances
OSMB
-
Which background process performs open and close of the disk in diskgroup on behalf of instance?
RBAL
-
In ASM command line what is the command to copy files?
cp
-
In ASM command line what is the command to list disk visible to ASM?
lsdsk
-
What command starts the ASM commandline interface?
asmcmd
-
Which views does lsdsk in ASM commandline use?
V$ASM_DISK_STAT and V$ASM_DISK
-
What is the default ASM SID for a single instance database?
+ASM
-
In RAC, how are ASM instances named?
+ASMn
-
What must the instance_type parameter be set to when using ASM?
ASM
-
What happens when STARTUP command is issues in an ASM instance?
Oracle attempts to mount ASM disk groups
-
What does STARTUP FORCE do in an ASM instance?
Issues a SHUTDOWN ABORT to the Oracle ASM instance before restarting it.
-
What does STARTUP MOUNT or OPEN do in an ASM instance?
Mounts the disk groups specified in the ASM_DISKGROUPS initialization
-
What does STARTUP NOMOUNT do in an ASM instance?
Starts up the Oracle ASM instance without mounting any disk groups.
-
What does STARTUP RESTRICT do in an ASM instance?
Only users with both the CREATE SESSION and RESTRICTED SESSION system privileges can connect.
-
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
-
When will SHUTDOWN IMMEDIATE or TRANSACTIONAL result in an error in an ASM instance?
When a database instance in connected.
-
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
-
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
-
When creating an ASM diskgroup, what must be specified?
- A unique name
- Redundancy Level
- The disk to be formatted as an ASM disk
-
When creating an ASM diskgroup, what is optionally specified?
- Disks belonging to failure groups
- The type of failure group
- Disk group attributes
-
Which view allows DBA to monitor the status of ASM rebalances?
V$ASM_OPERATION
-
What command allows disks to be added to a disk group?
ALTER DISKGROUP data ADD DISK '/devices/disk6' NAME disk6;
-
What does ASM fast mirror resynch do?
allows a disk group to restore redundancy quickly after a transient disk failure.
-
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
-
What happens if a "failed" disk comes back online within DISK_REPAIR_TIME?
Only modified extents are resyncronised.
-
What is the default DISK_REPAIR_TIME?
3.6 hours
-
In which view can DISK_REPAIR_TIME be found?
V$ASM_ATTRIBUTE
-
What are the possible extent sizes in ASM
1,2,4,8,16,32,64M
-
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
-
What does ASM init parameter ASM_DISKGROUPS do?
List the diskgroups ASM mounts at startup
-
What does ASM init parameter ASM_DISKSTRINGS do?
Limits the disks ASM can see using masking
-
What does ASM init parameter ASM_POWER_LIMITS do?
Specifies the power for disk rebalancing
-
What are the ranges for the ASM init parameter ASM_POWER_LIMITS?
0-1024
-
How does one disable disk rebalancing?
Set ASM_POWER_LIMITS to 0
-
What is the INSTANCE_TYPE parameter for and ASM instance?
ASM
-
What init parameter are NOT required for an ASM instance?
- DB_CACHE_SIZE
- SHARED_POOL
- LARGE_POOL
-
What Oracle file are not supported in ASM?
admin files including: trace files, audit files, alert logs, export files, tar files, and core files.
-
What is the prescibed naming method in ASM?
+diskgroup/dbname/filetype/filetypetag.file.incarnation.
-
What is a alias filename?
Alias filenames can be used for referencing existing files and creating new ASM files
-
Where cannot alias filenames exist?
At root level (+)
-
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.
-
What is the command to drop a datafile?
ALTER DISKGROUP data DROP FILE '+data/ocpdb/ocp_undo_ts';
-
What is the command to create a datafile using an alias?
CREATE UNDO TABLESPACE ocpundo DATAFILE '+data/ocpdb/ocp_undo_ts' SIZE 200M;
|
|
