Files - Expert Oracle Database Architecture - page 87

Using parameter settings in server-side spfile /home/ora12cr1/app/ora12cr1/product/12.1.0/dbhome_1/
dbs/spfileora12cr1.ora
System parameters with non-default values:
processes = 300
resource_limit = TRUE
sga_target = 4800M
control_files = "/home/ora12cr1/oradata/ORA12CR1/controlfile/o1_mf_8wvv2pml_.ctl"
control_files = "/home/ora12cr1/app/ora12cr1/fast_recovery_area/ORA12CR1/controlfile/
o1_mf_8wvv2ps2_.ctl"
db_block_size = 8192
compatible = "12.1.0.0.0"
db_create_file_dest = "/home/ora12cr1/oradata"
db_recovery_file_dest = "/home/ora12cr1/app/ora12cr1/fast_recovery_area"
db_recovery_file_dest_size = 4815M
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile = "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=ora12cr1XDB)"
local_listener = "(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.25)(PORT=1521))"
parallel_min_servers = 0
parallel_max_servers = 0
audit_file_dest = "/home/ora12cr1/app/ora12cr1/admin/ora12cr1/adump"
audit_trail = "DB"
db_name = "ora12cr1"
open_cursors = 300
_column_tracking_level = 1
pga_aggregate_target = 1600M
diagnostic_dest = "/home/ora12cr1/app/ora12cr1"
NOTE: remote asm mode is local (mode 0x1; from cluster type)
Starting background process PMON
Mon Sep 02 16:56:22 2013
PMON started with pid=2, OS id=21572
From this section, you can easily create a PFILE to be converted into a new SPFILE using the CREATE SPFILE
command.
Pluggable Databases
Pluggable databases are designed to be a set of files you can move from one root container database to another. That
is, we can unplug a pluggable database, and upon plugging it back into either the same root container database or
some other root container database, we would have our original pluggable database back—with all of the application
schemas, users, metadata, grants, data, and even our pluggable database parameter settings (settings that were not
inherited from the root container). This is achieved by storing pluggable database-specific parameter settings in a
data dictionary table: SYS.PDB_SPFILE$ . It is in this fashion that pluggable databases can override a parameter setting
for some parameters (not every parameter can be set at the pluggable database level) in an SPFILE and have those
parameter settings travel with them as they move from root container database to root container database.