Creating IORM Plans on Oracle Exadata:

Create a simple plan:

CellCLI> alter iormplan
dbplan=((name=db1_prod, level=1, allocation=70),
(name=db2_prod, level=1, allocation=30),
(name=db1_dev, level=2, allocation=100),
(name=db1_test, level=3, allocation=70),
(name=other, level=3, allocation=40)),
catplan=''

CellCLI> alter iormplan active


Create a plan based on a Data Guard environment:

CellCLI> alter iormplan dbplan=( -
(name=mydbprod1, level=1, allocation=40, role=primary), -
(name=mydbprod2, level=1, allocation=30, role=primary), -
(name=mydbprod, level=2, allocation=20, role=standby), -
(name=mydbprod2, level=2, allocation=25, role=standby), -
(name=other, level=3, allocation = 50))


Best Regards,
Paulo Portugal