How to get the DDL for the group in Netezza database

Issue:
How to get the DDL for the group in Netezza database

Solution:
Netezza we have utility to get the  DDL for the group.

nz_ddl_group <group_name>


/export/home/nz> nz_ddl_group TESTGRP

\echo
\echo *****  Creating group:  "TESTGRP"
CREATE GROUP TESTGRP WITH RESOURCE MINIMUM 1 RESOURCE MAXIMUM 5 ;

oracle DB crashed when opened after the full restore

Issue:
we have got the below issue  after opening the database from restore and it crashed the instance and throw the below error.
Tue Aug 07 22:47:12 2018
SMON: enabling cache recovery
Errors in file /apporadb1/oracle/product/11.2.0/log/diag/rdbms/oradb1/oradb1/trace/oradb1_ora_25952386.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Errors in file /apporadb1/oracle/product/11.2.0/log/diag/rdbms/oradb1/oradb1/trace/oradb1_ora_25952386.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Error 704 happened during db open, shutting down database
USER (ospid: 25952386): terminating the instance due to error 704
Instance terminated by USER, pid = 25952386
ORA-1092 signalled during: alter database open resetlogs...
opiodr aborting process unknown ospid (25952386) as a result of ORA-1092

Root cause:after checking this error and looks like  Db asking for upgrade and  we noticed the source database was 11.2.0 and target would be 11.2.0.4 .so in order to open the database ,we  just need to upgrade the database  to 11.2.0.4.

Solution:

1)startup the DB in upgrade mode

2)run the catupgrd.sql

3)run the utlrp.sql

4)do the sanity check on the database again.