Monthly Archives: July 2015

Restore database


Restore edeceyimiz database ucun asagdaki Rman scriptini istifade ede bilerik. RUN { RESTORE CONTROLFILE FROM ‘/data/AZKKUAT/controlfile/cntrlfile.copy’; ALTER DATABASE MOUNT; RESTORE DATABASE FROM TAG before_test; recover database FROM TAG archbackup; ALTER DATABASE OPEN RESETLOGS; } Daha saglam sekilde restore etmek ucun yuxarida yazmis oldugumuz Rman scriptini 3 yere bolubadim adim ilerleye bilerik. Rman ile baglandiqdan sonra […]

exadata session kill


SELECT ‘ALTER SYSTEM KILL SESSION (‘ || ”” || sid || ‘,’ || serial# || ‘,’ || ‘@’ || inst_id || ”’) immediate; ‘ FROM gv$session WHERE TYPE <> ‘BACKGROUND’;

dbms_space


set serveroutput on declare total_blocks NUMBER ; total_bytes NUMBER ; unused_blocks NUMBER; unused_bytes NUMBER ; last_used_extent_file_id NUMBER ; last_used_extent_block_id NUMBER ; last_used_block NUMBER ; BEGIN dbms_space.unused_space(‘&Username’,’&Table_Name’ ,’TABLE’ , total_blocks,total_bytes, unused_blocks ,unused_bytes, last_used_extent_file_id , last_used_extent_block_id , last_used_block, ‘&Partition_Name’ ); dbms_output.put_line( ‘********************************************************************************’); dbms_output.put_line( ‘total number of blocks in the segment :’||TO_CHAR(total_blocks) ); dbms_output.put_line( ‘Total Mbytes :’||TO_CHAR(total_bytes/1024/1024) ); […]

How to apply patchset updates to your grid infrastructure


root@azkkdbdr # cd /oracle_upgrade/ root@azkkdbdr # cd bp16/ root@azkkdbdr # ls 20834641 PatchSearch.xml p20834641_112040_SOLARIS64.zip root@azkkdbdr # ls -l total 986258 drwxr-xr-x 5 oracle oinstall 512 Apr 13 19:57 20834641 -rw-rw-r– 1 oracle oinstall 125660 Apr 14 17:58 PatchSearch.xml -rw-r–r– 1 oracle oinstall 504558767 Jul 7 10:01 p20834641_112040_SOLARIS64.zip root@azkkdbdr # cd 20834641/ root@azkkdbdr # ls 19852360 […]

recover standby database (GAP)


bash-3.2$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Jul 6 19:15:15 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> startup mount; ORACLE instance started. Total System Global Area 2.0583E+10 bytes Fixed Size 2190488 bytes Variable Size 3019903848 bytes Database Buffers 1.7515E+10 bytes Redo Buffers 45883392 […]

Exadata Cell Services Administration


Exadata storage cell is new to the industry and only oracle is offering such a customized storage for oracle database. Unlike the traditional SAN storage ,Exadata data storage will help to reduce the processing at the DB node level. Since the exadata storage cell has its own processors and 64GB physical memory , it can […]