Posts

RMAN Database Restore from ASM (NON-RAC) TO File System (NON-RAC)

RMAN Database Restore from ASM to File System RMAN Database Restore from ASM (NON-RAC) TO File System (NON-RAC) 0. Environment On Source Server 1. Backup database 2. Create pfile from spfile 3. Push backup files/pfile to target server On Target Server 4. Edit pfile 5. Create Required Folders 6. Add the entry in oratab 7. Startup Nomount 8. Restore controlfile 9. Mount database 10. Catalog backup pieces 11. Restore/recover database 12. Change dbname/DBID uisng NID 13. Modify DB_NAME in init file and start the database 14. Add TNS entry 15. Verify 0. Environment Source: DB: SBPROD, Diskgroup: DATA Node: YesBrac1, DB Version: 11.2.0.3 Target: DB: YESBTEST, File System: /u01 Node: YesBrac2, DB Version: 11.2.0.3 On Source SERVER ================== Step 1: Backup database w148p – source [oracle@YesBrac1 ~]$ cat open0.rcv run { allocate channel t1 type disk; backup incremental level 0 database format '/u01/share/backup/database_%d_%u_%s'; release channel t1; } sql '

ASMCA utility Features in 19C

Welcome to ASM Configuration Assistant Oracle ASM Configuration Assistant (ASMCA) supports installing and configuring Oracle ASM instances, Oracle ASM disk groups, Oracle ASM Dynamic Volume Manager (Oracle ADVM) volumes and Oracle Automatic Storage Management Cluster File System (Oracle ACFS) file systems. In addition, you can use the ASMCA command line-line interface. Oracle ASM Configuration Assistant enables you to: Manage disk groups Create, configure or drop an Oracle ASM disk group Add disks to and drop disks from the disk group Edit the disk group attributes Manage templates for the disk group Create an Oracle ACFS file system on the disk group for database use Mount or dismount the disk group Add, list or drop quota groups Add, move or drop file groups Manage Oracle ADVM volumes Create or configure an Oracle ADVM volume Enable or disable Oracle ADVM volume View status details Resize or delete volumes Manage Oracle ACFS file systems Create or configure an Oracle ACFS file sy

Generic - Exploration of ERP Modules in Oracle E-Business Suite

Exploration of ERP Modules in Oracle E-Business Suite ERP stands for enterprise resource planning. It refers to the systems and software packages used by organizations to manage day-to-day business. Oracle E-Business Suite is one of the most reputed ERP product which is currently available in the market – developed by Oracle. In the world of enterprise resource planning, very few software products have really made to the top ranks when it comes to worldwide implementations. Based on market share – SAP, Microsoft Dynamics are the close vendors who try to get the ERP share in almost all the regions. What is Oracle E-Business Suite? Oracle’s E-Business Suite (also known as Applications/Apps or EB-Suite/EBS) consists of a collection of enterprise resource planning (ERP), customer relationship management (CRM), and supply-chain management (SCM) computer applications either developed or acquired by Oracle. Top Vendors in the market Based on market share – SAP, Oracle, and Microsoft D

ORA2PG Demo

-------------------------At Oracle--------------------------------------------------- PREREQUEST: 1.In a database all schema size: set linesize 150 set pagesize 5000 col owner for a15 col segment_name for a30 col segment_type for a20 col TABLESPACE_NAME for a30 clear breaks clear computes compute sum of SIZE_IN_GB on report break on report select OWNER,sum(bytes)/1024/1024/1000 "SIZE_IN_GB" from dba_segments group by owner order by owner; 2.issuing below script you will extract the size & path of datafiles along with tablespace name,allocated space in GB, used space in GB & free space in GB. set linesize 200 set pagesize 2000 COLUMN tablespace_name format a10 COLUMN file_name format a45 COLUMN free% format a7 SELECT df.tablespace_name,SUBSTR (df.file_name, 1, 60) file_name, df.bytes/1024/1024/1024 allocated_GB, round(((df.bytes/1024 /1024/1024) – NVL(SUM(dfs.bytes)/1024/1024 /1024, 0)),1) used_GB, round(NVL(SUM (dfs.bytes)/1024/1024/1024, 0),2) free_space_GB FROM dba_

# Migration # From Oracle to PostgreSQL By Using ora2pg open source tool

@ Oracle  PREREQUEST: 1.In a database all schema size: set linesize 150 set pagesize 5000 col owner for a15 col segment_name for a30 col segment_type for a20 col TABLESPACE_NAME for a30 clear breaks clear computes compute sum of SIZE_IN_GB on report break on report select OWNER,sum(bytes)/1024/1024/1000 "SIZE_IN_GB" from dba_segments group by owner order by owner; 2.issuing below script you will extract the size & path of datafiles along with tablespace name,allocated space in GB, used space in GB & free space in GB. set linesize 200 set pagesize 2000 COLUMN tablespace_name format a10 COLUMN file_name format a45 COLUMN free% format a7 SELECT df.tablespace_name,SUBSTR (df.file_name, 1, 60) file_name, df.bytes/1024/1024/1024 allocated_GB, round(((df.bytes/1024 /1024/1024) – NVL(SUM(dfs.bytes)/1024/1024 /1024, 0)),1) used_GB, round(NVL(SUM (dfs.bytes)/1024/1024/1024, 0),2) free_space_GB FROM dba_data_files df, dba_free_space dfs WHERE df.FILE_ID = dfs.file_id(+) GROUP BY