Oracle E-Business Suite Config Files Backup

Oracle E-Business Suite Config Files Backup

Ebs Config Files Backup Script

Oracle Database Configuration Files Backup

Oracle Database Configuration Files Backup

Database Config Files Backup

How to stop or cancel mrp process in standby?

How to stop or cancel mrp process in standby?

alter database recover managed standby database cancel;

alter database recover managed standby database disconnect from session;

For real time media recovery

alter database recover managed standby database using current logfile disconnect from session;

How to check the datafiles locations if it is in multiple locations ?

How to check the datafiles locations if it is in multiple locations ?

select distinct regexp_substr(name,'^.*/') from v$datafile;

select distinct regexp_substr(member,'^.*/') from v$logfile;
select distinct regexp_substr(name,'^.*/') from v$controlfile;

select name from v$datafile;
select name from v$controlfile;
select member from v$logfile;

How to take backup using the cp command?

How to take backup using the cp command?

Backup plan:

cp -Pr 10.1.2 10.1.2_beforejws_bkp14062022

cp -Pr 10.1.3 10.1.3_beforejws_bkp14062022

How to increase a datafile or adding extra space to tablespace in oracle database?

How to increase a datafile or adding extra space to tablespace in oracle database?

show parameter db_create_file_dest;

select file_name from dba_data_files;

select count(*) from dba_data_files;

select file_name, bytes/1024/1024 from dba_data_files where file_name like '%&file%';

select file_name, status from dba_data_files ;

select file_name,file_id,autoextensible,bytes/1024/1024/1024,status,maxbytes/1024/1024/1024 from dba_data_files where tablespace_name='&TABLESPACE_NAME';

alter tablespace help_data add datafile '/u04/oradata/qr10.dbf' size 3000m autoextend off;

alter database datafile '/u02/dbdata/qprod/heqa_01.dbf' resize 5g;

alter tablespace nfhprod_biplatform add datafile '+data' size 16m autoextend on maxsize 31g;

alter tablespace kuls_img_tbs add datafile '/u02/oracle/datafiles/nfhprod/kuls_img_tbs_03' size 1g autoextend on maxsize 20g;

To enable datafile autoextend and set the Maxsize

SQL> alter database datafile 'datafile_name' autoextend on maxsize 120 g;

To Resize Datafiles

SQL> alter database datafile 'datafile_name' resize 20G;