Daily Archives: November 21, 2013
detailed time in RMAN using the list backup command
RMAN> list backup; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ——- —- — ———- ———– ———— ————— 1 Full 432.00K DISK 00:00:01 21-NOV-13 BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20090912T125258 Piece Name: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TEST\BACKUPSET \2013_21_11\O1_MF_NNNDF_TAG20090912T125258_5BPNTTVT_.BKP List of Datafiles in backup set 1 File LV Type […]
Asmcmd /DATA backup
bash-3.2$ ps -afe | grep smon oracle 19016 1 0 Jun 20 ? 5:41 asm_smon_+ASM1 oracle 16578 1 0 Sep 15 ? 23:57 ora_smon_ANARDB1 oracle 3713 21935 0 19:37:34 pts/1 0:00 grep smon root 5429 1 0 Oct 01 ? 12061:59 /u02/app/oracle/product/grid/db_1/bin/osysmond.bin bash-3.2$ bash-3.2$ . oraenv ORACLE_SID = [ANARDB1] ? +ASM1 The Oracle base remains […]
change database character set
Step1. Check NLS_CHARACTERSET Connect to user SYS or SYSTEM SELECT * FROM V$NLS_PARAMETERS WHERE PARAMETER = ‘NLS_CHARACTERSET’; Parameter Value NLS_CHARACTERSET AL32UTF8 Change NLS_CHARACTERSET from AL32UTF8 to WE8ISO8859P1 Step2. Connect to user SYS Step3. Update value UPDATE PROPS$ SET VALUE$ = ‘WE8ISO8859P1’ WHERE NAME = ‘NLS_CHARACTERSET’; COMMIT; Step4. Restart database SHUT IMMEDIATE; STARTUP; Step5. Check NLS_CHARACTERSET Connect […]
DATABASE KİLİT MEKANİZMASI
Database kilit işlemleri çeşitli aşamalrda olabilir.Örneğin statemnt bazında oluşan hata aşağıdaki gibi olabilir. Örneğin aynı anda iki kullanıcı tablo üzerinde statemnt çalıştırıp kilide yol açabilirler. Bu şu an bir probleme yol açmaz ama aşağıdaki gib bir durum olursa, Bu kaosu önlemenin yolu 1.transactionun commit edilmesidir. İki tip lock tipi vardır.DML işlemleri için ve DDL işlemleri […]
Unix Commands (BASIC)
Getting help man – view manual pages for Unix commands Unix users id– print user identity For example: [oracle@BAKUANARDBDB ~]$ id uid=502(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),506(asmdba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 [oracle@BAKUANARDBDB ~]$ Unix file operations ls – list files and directories cat – concatenate files and show contents to the standard output cp – copy rm – remove the file mv – move […]
umask
The umask specifies what permission bits will be set on a new file or directory when created. It is an octal number that is used to determine what permission bits a file or directory is created with: New Directory: 777 – 022: 755 => rwxr-xr-x New file: […]
General Rollback Segment Information
SELECT t1.name , t2.extents, t2.rssize, t2.optsize, t2.hwmsize, t2.xacts, t2.status FROM v$rollname t1, v$rollstat t2 WHERE t2.usn = t1.usn ;
current number of extents and blocks allocated to a seg
SELECT SEGMENT_NAME,TABLESPACE_NAME,EXTENTS,max(BLOCKS) FROM DBA_SEGMENTS group by SEGMENT_NAME,TABLESPACE_NAME,EXTENTS