Dears:
How to cancel the rman processes which are runing?
Thanks

-----Original Message-----
From: Ralf
[mailto:oracledba-ezmlmshield-x58312005.[Email address protected]
Sent: Friday, February 29, 2008 5:37 PM
To: LazyDBA Discussion
Subject: Re: RMAN Recovery Issue Through SEQ# and CHN# ?

Hai da, Irfan Ahmad!!

Use LogMiner to find the corresponding SCN...

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/logminer.
htm#SUTIL019

restore database/recover database until (change) SCN...

RMAN>
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/flashptr0
06.htm#sthref669
SQL>
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/osrecov00
8.htm

Hope this helps... ?!

:-)))


Dear friends
I want to apply incomplete recovery through seq # or SCN #. Suppose i
have
taken my db backup and during my work i drop my user accidently. Now
please tell me how i find what was the seq# or chn# when i drop my user
and how i will perform my incomplete recovery.

Waiting for quick response.

Thanks & Regard

Irfan Ahmad
Lahore, Pakistan


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page