Oracle Server :: Abort / Stop backup operation using RMAN


	Abort / Stop backup operation using RMAN Hi, I would like to know if there is any way we can abort / stop backup operation using RMAN. For example: Lets say I have run > run { > allocate channel ch type abc; > backup mydatafile; > } Now I want to stop this backup job using a RMAN script. Please let me know if this is possible. Thanks in advance. Regards, Ganesh Tambat Forgot to mention the DB version number. I am using Oracle 10g. Thanks, Ganesh Tambat -----------------------------------------------Reply----------------------------------------------- On May 9, 3:19 am, Ganesh <ganesh.tam@gmail.com> wrote: > Forgot to mention the DB version number. I am using Oracle 10g. > Thanks, > Ganesh Tambat This becomes an interesting question when you realize that 'RMAN' where you type your commands is really only a shell that issues the commands to the database kernel. In other words, the backup command is actually run by the Oracle Database Instance, not by RMAN. How have you started RMAN? What state is the database/instance? Where do you want to issue the abort relative to the rman shell? Have you tried Control-C? -----------------------------------------------Reply----------------------------------------------- To rephrase the query ... I want to know a way to write RMAN script which will stop / abort the backup operation. The database is in open state. Thanks, Ganesh On May 9, 3:48 pm, Fuzzy <fuzzy.greybe@gmail.com> wrote: - Hide quoted text - > On May 9, 3:19 am, Ganesh <ganesh.tam@gmail.com> wrote: > > Forgot to mention the DB version number. I am using Oracle 10g. > > Thanks, > > Ganesh Tambat > This becomes an interesting question when you realize that 'RMAN' > where you type your commands is really only a shell that issues the > commands to the database kernel. In other words, the backup command > is actually run by the Oracle Database Instance, not by RMAN. > How have you started RMAN? > What state is the database/instance? > Where do you want to issue the abort relative to the rman shell? > Have you tried Control-C? On May 9, 9:00 am, Ganesh <ganesh.tam@gmail.com> wrote: - Hide quoted text - > To rephrase the query ... I want to know a way to write RMAN script > which will stop / abort the backup operation. > The database is in open state. > Thanks, > Ganesh > On May 9, 3:48 pm, Fuzzy <fuzzy.greybe@gmail.com> wrote: > > On May 9, 3:19 am, Ganesh <ganesh.tam@gmail.com> wrote: > > > Forgot to mention the DB version number. I am using Oracle 10g. > > > Thanks, > > > Ganesh Tambat > > This becomes an interesting question when you realize that 'RMAN' > > where you type your commands is really only a shell that issues the > > commands to the database kernel. In other words, the backup command > > is actually run by the Oracle Database Instance, not by RMAN. > > How have you started RMAN? > > What state is the database/instance? > > Where do you want to issue the abort relative to the rman shell? > > Have you tried Control-C? It's in the documentation somewhere... in fact Oracle will tell you how to kill the rman session from the OS, from within Oracle, and if you're running interactively (ctrl-c). They suggest terminating the RMAN channels. From my experience, you occasionally have to kill the actual RMAN parent process as well. Terminating the job from the OS has proved the cleanest for me (on Solaris and linux). You can find the SIDs for the channels in the RMAN message log... in the line where you see RMAN allocating channels; eg: allocated channel: t1 channel t1: sid=909 instance=web1 devtype=SBT_TAPE channel t1: VERITAS NetBackup for Oracle - Release 5.1 (2004122520) Likewise you can use a query like: SELECT p.SPID, s.sid, s.serial#, sw.EVENT, sw.SECONDS_IN_WAIT AS SEC_WAIT, sw.STATE, CLIENT_INFO FROM V$SESSION_WAIT sw, V$SESSION s, V$PROCESS p --WHERE sw.EVENT LIKE 'sbt%' WHERE s.client_info LIKE 'rman%' AND s.SID=sw.SID AND s.PADDR=p.ADDR ;

MS Dynamics CRM 3.0

Oracle Server

Abort / Stop backup operation using RMAN