Restore database in Oracle

// Restore table from database dump file
impdp BINO_DB/BINO_DB@BINOBDX directory=BACKUP_DATABASE_DB dumpfile=BINO_DB.DMP logfile=BINO_DB_LF.log TABLES=BINO_DB.STOCK_LEDGER REMAP_TABLE=BINO_DB.STOCK_LEDGER:STOCK_LEDGER_280221
// Drop tablespace
DROP TABLESPACE BINO_DB INCLUDING CONTENTS AND DATAFILES;

// Create tablespace
CREATE TABLESPACE BINO_DB DATAFILE 
  '+DATA' SIZE 5120M AUTOEXTEND ON NEXT 10M MAXSIZE 20480M
LOGGING
ONLINE
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
// Restore Database
impdp PRODUCTION/GSG_ORACLE_12C#@ODAADF schemas=BINO_DB directory=DAILY_DB_ODA_BACKUP dumpfile=BINO_DB.DMP logfile=BINO_DB_LF.log

Read More