| | Syntax to crosscheck archive logs in RMAN
Sometimes you end up with missing archive logs for whatever reason, and RMAN backup fails. Running crosscheck will fix the problem.
$ rman
Recovery Manager: Release 10.2.0.4.0 - Production on Wed Sep 1 10:05:02 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN> connect target /
connected to target database: [SID] (DBID=[DBID])
RMAN> crosscheck ... | | More... 09/01/10 | | | | | | | | |
|
| | Recover a dropped/deleted table from RMAN Backup
From 10g Onwards you can recover the dropped table from recyclebin, suppose the table is not available in recycle bin also flashback database in not enabled.
But you are having a recent RMAN backup containing that particular missing/deleted/dropped table.
you can recover the table by
1. create a duplicate database from production database ... | | More... 08/11/10 | | | | | | | | |
|
| | Drop wrongly added Datafile in Tablespace(10gR2)
Unfortunately, you can't. Prior to Oracle Database 10g Release 2, your only clean option for removing a datafile is to drop the entire tablespace and then rebuild it without that particular file. If the tablespace contains data, you have to go through the time-consuming and laborious process of storing the ... | |  More... 08/11/10 | | | | | | | | |
|
|
|
| | test
ops$oracle.PONP> @?/rdbms/admin/addmrpt
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
3392966083 PONP 1 PONP
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB ... | | More... 06/16/10 | | | | | | | | |
|
| | ADDM
ops$oracle.PONP> @?/rdbms/admin/addmrpt
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
3392966083 PONP 1 PONP
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB ... | | More... 06/16/10 | | | | | | | | |
|
|
| | Display system calls for a program on Unix
You can use truss to view system calls for a specific program, for example:
truss ls
execve("/usr/bin/ls", 0xFFBFFB1C, 0xFFBFFB24) argc = 1
resolvepath("/usr/lib/ld.so.1", "/usr/lib/ld.so.1", 1023) = 16
resolvepath("/usr/bin/ls", "/usr/bin/ls", 1023) = 11
stat("/usr/bin/ls", 0xFFBFF8E0) = 0
open("/var/ld/ld.config", O_RDONLY) ... | | More... 02/26/10 | | | | | | | | |
|
| | See the environment variables for a process when it was started
pargs -e
Example:
ps -ef | grep tnslsnr
oracle 20083 11285 Dec 30 ? 17:22
/apps/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit
pargs -e 20083
20083: /apps/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit
envp[0]: _=/apps/oracle/product/10.2.0/db_1/bin/lsnrctl
envp[1]: MANPATH=/usr/share/man
envp[2]: SSH_TTY=/dev/pts/1
envp[3]:
PATH=/usr/ccs/bin:/usr/bin:/usr/sbin:/usr/ucb:/usr/proc/bin:/usr/local/bin:/usr/bin/nsr:/opt/soe/local/bin:/apps/oracle/local/bin:/apps/oracle/product/10.2.0/db_1/bin
envp[4]: ORACLE_BASE=/apps/oracle
envp[5]: AWK=/usr/bin/nawk
envp[6]: ORACLE_PATH=.:/apps/oracle/local/bin
envp[7]: EDITOR=vi
envp[8]: LOGNAME=oracle
envp[9]: MAIL=/usr/mail/oracle
envp[11]: USER=oracle
envp[12]: TNS_ADMIN=/apps/oracle/net/admin
envp[13]: ORA_NLS10=/apps/oracle/product/10.2.0/db_1/nls/data
envp[15]: SHELL=/bin/ksh
envp[16]: ... | | More... 01/04/10 | | | | | | | | |
|