| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN recovery stuck
Robert - Thanks a million. I'll get started on that tomorrow. Yep, I figured
I'd made some type of novice error which is why I posted the commands I'm
using.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Wednesday, August 14, 2002 4:33 PM
To: Multiple recipients of list ORACLE-L
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.
RF
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).
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).
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). Received on Wed Aug 14 2002 - 17:18:27 CDT
 |
 |