Oracle - SQL - MySQL DBA - Life Long Learning Experience

Exporting from lower version and Importing to Higher version of oracle. or Other words Application Schema Migration from one  database (11.2.0.4) (SUSE o/s )  to linux o/s running 12.2.0.1 database Steps taken to fulfil the activity . Though it is the simplest task to perform but providing steps  becomes handy . 1. Below  Steps to be performed target database. a) CREATE TABLESPACE NEIGHBOURHOOD DATAFILE   '/data/oragen1d/neighbourhood01.dbf' SIZE 4500M AUTOEXTEND ON NEXT 20M MAXSIZE 10000M LOGGING ONLINE EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; b) CREATE USER NEIGHBOURHOOD   IDENTIFIED BY nhood   DEFAULT TABLESPACE NEIGHBOURHOOD   TEMPORARY TABLESPACE TEMP   PROFILE DEFAULT   ACCOUNT UNLOCK; -- 1 Role for NEIGHBOURHOOD GRANT CONNECT TO NEIGHBOURHOOD; ALTER USER NEIGHBOURHOOD DEFAULT ROLE ALL; -- 6 System Privileges for NEIGHBOURHOOD GRANT CREATE INDEXTYPE TO NEIGHBOURHOOD; GRANT CREATE SEQUENCE TO NEIGHBOURHOOD; GRANT

How to create Redo Log Groups and Members on filesystem and ASM Diskgroup Create Redo Log member with a specific group number on Filesystem ALTER DATABASE ADD LOGFILE GROUP 1('/d01/oradata/orasbt1/redo1a.log', '/d02/oradata/orasbt1/redo1b.log') SIZE 100M; on ASM Diskgroup ALTER DATABASE ADD LOGFILE GROUP 1('+REDO', '+REDO') SIZE 100M; -- 2 members will be created on REDO disk group Create new Redo Log members for an existing group on Filesystem ALTER DATABASE ADD LOGFILE MEMBER '/d03/oradata/orasbt1/redo1c.log' TO GROUP 1; on ASM Diskgroup ALTER DATABASE ADD LOGFILE MEMBER '+REDO' TO GROUP 1;     Examples   ALTER DATABASE ADD LOGFILE GROUP 1('/redoa/oragen1d/redo01a.log', '/redob/oragen1d/redo01b.log') SIZE 100M; ALTER DATABASE ADD LOGFILE GROUP 2('/redoa/oragen1d/redo02a.log', '/redob/oragen1d/redo02b.log') SIZE 100M; ALTER DATABASE ADD LOGFILE GROUP 3('/redo