Oracle-L: RE: RMAN recovery stuck

From: Freeman, Robert <Robert_Freeman_at_csx.com>
Date: Wed, 14 Aug 2002 13:33:22 -0800
Message-ID: <F001.004B534F.20020814133322@fatcity.com>

There is a bug in 8.1.6 that is fixed in 8.1.7:

1164440 The RMAN command "release channel" reports RMAN-20020 if there are "set until" and "alter database open reset logs" commands in the same "run" block.

While this isn't exactly like your problem, it might be related. So, I'd remove the last
alter database command, run the rest, and then manually do the alter database and see if it works.

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press)
Mastering Oracle8i (Sybex)

The avalanche has begun, It is too late for the pebbles to vote.

-----Original Message-----
Sent: Wednesday, August 14, 2002 4:28 PM To: Multiple recipients of list ORACLE-L

I am trying to perform an RMAN disaster recovery task. While I use an RMAN catalog to make backups, I am trying to recover using just the control file information.
Oracle 8.1.6, Compaq/HP Tru64

I start RMAN with

rman target sys/password nocatalog
then,

startup mount

run {
set until time "to_date('08/11/2002 01:00:00','MM/DD/YYYY HH24:MI:SS')"; allocate channel d1 type disk;
restore database;
recover database;
alter database open resetlogs;
}

Everything appears normal for awhile. In the alert log RMAN tries to find each file, doesn't find them. Then it successfully recovers 5 data files (including system and rollback) and reports success in the alert log. Then . . . nothing for hours. RMAN doesn't return an error. The RMAN shadow processes are still present but with no CPU consumption. Nothing is written to the alert log.

I check V$SESSION_WAIT, and the only entry for the RMAN shadow processes is one is SQL*Net message to client with seconds_in_wait = 0, state = waited unknown time.

In V$SYSTEM_EVENT, time_waited and average_wait are zero for all events. The following events have values of total_waits that are increasing:

                                   Increase in total_waits in 10-minutes
   rdbms ipc message               401
   pmon timer                       57
   control file parallel write      56
   SQL*Net message to client        24
   SQL*Net message from client      24
   virtual circuit status            5
   dispatch timer                    3
   smon timer                        1

Archiving is turned off.

I have attempted this recovery many times using different RMAN backup sets, but the system always hangs at this point. Any ideas would be appreciated.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Freeman, Robert
INET: Robert_Freeman_at_csx.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------