月度存档: 五月 2009

how to enter the EXPORT MODE(INTERACTIVE MODE)

Oracle 10g的新工具expdp 很强大,但是有一点没有习惯的是, 如何去撤销这个expdp 呢?

在以前的exp中, ctrl+c 就可以撤销前的exp 进程,但是在expdp中,ctrl+c只是将当前的进程转化为后台进程,也就是说,ctrl+c 并没有撤销expdp的进程,在背景端,还在运行中,此时,dumpfile, logfile是不可以上出,不可以更名的。

那么如何撤销一个expdp的进程呢?
进入interactive mode, 然后kill_job

step 1: using interacitve mode
S:\>set oracle_sid=ora1
S:\>expdp ‘/ as sysdba’ attach

Export: Release 10.2.0.4.0 – 64bit Production on Thursday, 21 May, 2009 0:55:59

Copyright (c) 2003, 2007, oracle.  All rights reserved.

Connected to: oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit
Production
With the oracle Label Security, OLAP, Data Mining and Real Application Testing o
ptions
EXPORT>

看到EXPORT> 就表示进入了interactive mode了,这个时候就可以用如下指令来进行操作了

The following commands are valid while in interactive mode.
Note: abbreviations are allowed

Command               Description (Default)
——————————————————————————
CONTINUE_CLIENT       Return to logging mode. Job will be re-started if idle.
EXIT_CLIENT           Quit client session and leave job running.
HELP                  Summarize interactive commands.
KILL_JOB              Detach and delete job.
PARALLEL              Change the number of active workers for current job.
                      PARALLEL=<number of workers>.
START_JOB             Start/resume current job.
                      START_JOB=SKIP_CURRENT will start the job after skipping
                      any action which was in progress when job was stopped.
STATUS                Frequency (secs) job status is to be monitored where
                      the default (0) will show new status when available.
                      STATUS[=interval]
STOP_JOB              orderly shutdown of job execution and exits the client.
                      STOP_JOB=IMMEDIATE performs an immediate shutdown of the
                      Data Pump job.

for example

EXPORT> status

其中KILL_JOB就是删除当前的expdp的job. stop_job仅仅是停止这个job, 还是可以重新start起来的。

Unregister database in 9i

One of my databases has backup issue.

when trying to backup the database manually(before backing up database I want to find the configuration out), I get following error

————————————————————————————————–
RMAN> show all;

RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 05/17/2009 22:56:19
RMAN-06004: orACLE error from recovery catalog database: RMAN-20011: target data
base incarnation is not current in recovery catalog

RMAN>
————————————————————————————————–

继续阅读 »

My Vacation

我要休假啦!!
5/25~5/31 我要回家去咯~~

好久没有回家了,挺想的,以前总是因为工作的问题不能回家,要么oncall, 要么周末有事情,老是跟自己的计划冲突到。后来想想, 很不划算。所以定好自己的假期,让工作跟我的计划来安排吧!! 我半年也就休个5 天假期,为什么这5天里不以我自己的事优先呢…
老是在听人work life balance, 我觉得只要自己觉得可以没有什么是不可以balance的。

好期待我的假期阿,要开始准备礼物咯~~呵呵

母亲节

昨天听小敏说Dana 9月份的预产期,好惊喜阿,真是要好好恭喜恭喜呢!!

这个周日是母亲节,记得要给妈妈打电话阿!! 嘿嘿~~

我想回家

我想回家了,好久没有回家了。
因为胖子生病,一直都没有机会回家,好想妈妈啊。

不管了,五月我要抓住机会回家!!