Dicas ORACLE DBA

First Configure public Yum Repository: http://public-yum.oracle.com/ Run oracle-validated: [root@localhost yum.repos.d]# yum install oracle-validated Loading "security" plugin Setting up Install Process Parsing package install arguments Resolving Dependencies --> Running transaction check ---> Package oracle-validated.x86_64 0:1.1.0-14.el5 set to be updated filelists.xml.gz          100% |=========================| 3.1 kB    00:00 filelists.xml.gz          100% |=========================| 2.9 MB    00:10 filelists.xml.gz          100% |=========================| 2.7 MB    00:15 filelists.xml.gz          100% |=========================| 3.2 MB    00:18 filelists.xml.gz          100% |=========================| 2.6 MB    00:14 filelists.xml.gz          100% |===========...

DATAFILE_BLOCKS The number of data blocks in the datafile BLOCKS The number of data blocks written to the backup BLOCK_SIZE The size of the data blocks in bytes So BLOCKS * BLOCK_SIZE will give the number of bytes written for this particular datafile and hence the size of the backup piece may be calculated. SQL> select bs_key, sum(blocks*block_size) from rc_backup_datafile group by bs_key; If you do not use catalog (controlfile): SQL>select bs_key, sum(blocks*block_size) from v$backup_datafile group by bs_key;

BEGIN  DBMS_AUTO_TASK_ADMIN.DISABLE(  client_name => 'auto optimizer stats collection',  operation => NULL,  window_name => NULL);  END;  / to verify: SQL> select client_name,status from Dba_Autotask_Client;  CLIENT_NAME                        STATUS ---------------------------------- -------- auto optimizer stats collection    DISABLED auto space advisor                 ENABLED sql tuning advisor                 ENABLED

1. Using the adctrl utility, shutdown the workers. a. adctrl b. Select option 3 "Tell worker to shutdown/quit" 2. Backup the FND_INSTALL_PROCESSES table which is owned by the APPLSYS schema a. sqlplus applsys/ b. create table fnd_Install_processes_back as select * from fnd_Install_processes; c. The 2 tables should have the same number of records. select count(*) from fnd_Install_processes_back; select count(*) from fnd_Install_processes; 3. Backup the AD_DEFERRED_JOBS table. a. sqlplus applsys/ b. create table AD_DEFERRED_JOBS_backas select * from AD_DEFERRED_JOBS; c. The 2 tables should have the same number of records. select count(*) from AD_DEFERRED_JOBS_back; select count(*) from AD_DEFERRED_JOBS; 4. Backup the .rf9 files located in $APPL_TOP/admin//restart directory. At this point, the adpatch session should have ended and the cursor should be back at the Unix prompt. a. cd $APPL_TOP/admin/ b. mv restart restart_back c. mkdir rest...