Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed-east.nntpserver.com!nntpserver.com!news.glorb.com!postnews.google.com!not-for-mail From: DMina@laiki.com (Demetris) Newsgroups: comp.databases.oracle.server Subject: Re: RMAN fatal error Date: 8 Nov 2004 07:34:16 -0800 Organization: http://groups.google.com Lines: 27 Message-ID: References: NNTP-Posting-Host: 212.31.98.140 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1099928056 22206 127.0.0.1 (8 Nov 2004 15:34:16 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Mon, 8 Nov 2004 15:34:16 +0000 (UTC) Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:228890 Thanks for your reply! It is cold backup. But from what I have seen in the RMAN log the datafiles where being backed up at that time. Usually the backups starts at 18:35 and finishes at 19:10 (35 minutes). At 19:09 the error below occured. That is what is puzzleing me. After the cancel i rerun the backup and and completed sucessfully. "Pawel W" wrote in message news:... > >RMAN-10006: error running sql statement: select act from x$ksusex > >where sid=:1 and serial=:2 > >RMAN-10002: ORACLE error: ORA-01089: immediate shutdown in progress - > >no operations are permitted > >I found it quite strange because at that time nothing else was > >running. After the above error I rerun the backup and it went through > >ok. Any ideas on what might have happen? > > What kind of backup is it, "hot" or "cold" ? > > If "cold" then somewhere in your rman or shell scripts there are probably > commands to shutdown your instance and next start it in the "mount" mode. > Sometimes the "shutdown immediate" command is either not able to stop the > instance, or it takes quite a long time to do it, if such a situation occurs > then rman will not be able to cooperate with the database. > > Pawel Wozniczka