Oracle Recovery [message #471494] |
Sun, 15 August 2010 17:12 |
sunnys_neil
Messages: 9 Registered: July 2010 Location: KY
|
Junior Member |
|
|
I need some support on older version of oracle. Its 7.1 and it runs on alpha 2100 with open vms 6.1 OS. I was looking at option of alpha virtualization in sometime soon. I have set of backup hdd and one set of alpha 2100 spare machine.
But lately, just the oracle processes keeps shutting down soon unexpectly. It was complaining about couple of bad block , SO i found that objects(tables) , dropped them and created them.
After few days, it does the same thing again...The log says 'File 2 at .....needs media recovery'.....I wanted to recovery that datafile but When I try to connect using 'sqlplus' , it says
'ora: 01034: oracle not available'
'0ra-0765:$msget :$mgblsc failure'
--- no such global section
Any help on these two errors would be apprecaited...How do one recovery database or datafile without connecting to SQLPLUS? Any ideas ?
|
|
|
|
Re: Oracle Recovery [message #471684 is a reply to message #471494] |
Mon, 16 August 2010 12:59 |
sunnys_neil
Messages: 9 Registered: July 2010 Location: KY
|
Junior Member |
|
|
True, I tried that but it says 'ora0-01034:oracle not available'
even with sqldba and svrmgrl. Not sure how to recover or make it up and running on the spare alpha.. I tried to restart several times but it wont help...
|
|
|
|
Re: Oracle Recovery [message #471694 is a reply to message #471494] |
Mon, 16 August 2010 14:28 |
sunnys_neil
Messages: 9 Registered: July 2010 Location: KY
|
Junior Member |
|
|
1. Here's the alert log: (FYI:'AB====' is the name of DB)
=========================
13-AUG-2010 09:48:43.85:
alter database AB===== mount exclusive
13-AUG-2010 09:48:44.24:
Completed: alter database AB===== mount exclusive
13-AUG-2010 09:48:44.39:
alter database AB===== open
ORA-1113 signalled during: alter database AB===== open...
13-AUG-2010 09:48:44.96:
alter database AB===== dismount
Completed: alter database AB===== dismount
Shutting down instance (abort)
License high water mark = 1
Starting up ORACLE RDBMS Version: 7.1.5.2.3.
System parameters with non-default values:
processes = 100
shared_pool_size = 5000000
control_files = ora_control1, ora_control2
db_block_buffers = 550
gc_segments = 50
gc_tablespaces = 50
gc_rollback_segments = 15
log_checkpoint_interval = 10000
gc_rollback_locks = 50
gc_save_rollback_locks = 50
rollback_segments = rollbk0, rollbk1
sequence_cache_entries = 30
sequence_cache_hash_buckets= 23
remote_login_passwordfile= NONE
mts_service = AB=====
mts_servers = 0
mts_max_servers = 0
mts_max_dispatchers = 0
audit_trail = NONE
sort_area_retained_size = 65536
db_name = AB=====
open_cursors = 150
ifile = ora_system:initps.ora
max_dump_file_size = 10240
PMON started
DBWR started
LGWR started
RECO started
16-AUG-2010 12:51:16.55:
alter database AB===== mount exclusive
=============================================
2. Here's the startup log :
============================================================
SQLDBA> connect internal
Connected.
SQLDBA> startup open "AB======"
ORACLE instance started.
Database mounted.
ORA-01113: file 2 needs media recovery
ORA-01110: data file 2: 'DKA100:[DB===]POST_DATA.DBF'
Attempting to dismount database........Database dismounted.
Attempting to shutdown instance........ORACLE instance shut down.
SQLDBA> remark - to keep in memory the following packages !
SQLDBA> EXECUTE DBMS_SHARED_POOL.KEEP('SYS.STANDARD');
DBA-00342: unable to complete internal login
ORA-01034: ORACLE not available
ORA-07625: smsget: $MGBLSC failure
%SYSTEM-W-NOSUCHSEC, no such (global) section
SQLDBA> EXECUTE DBMS_SHARED_POOL.KEEP('SYS.DBMS_STANDARD');
DBA-00342: unable to complete internal login
ORA-01034: ORACLE not available
ORA-07625: smsget: $MGBLSC failure
%SYSTEM-W-NOSUCHSEC, no such (global) section
SQLDBA> EXECUTE DBMS_SHARED_POOL.KEEP('SYS.DBMS_PIPE');
DBA-00342: unable to complete internal login
ORA-01034: ORACLE not available
ORA-07625: smsget: $MGBLSC failure
%SYSTEM-W-NOSUCHSEC, no such (global) section
SQLDBA> EXECUTE DBMS_SHARED_POOL.KEEP('SYS.DIUTIL');
DBA-00342: unable to complete internal login
ORA-01034: ORACLE not available
ORA-07625: smsget: $MGBLSC failure
%SYSTEM-W-NOSUCHSEC, no such (global) section
SQLDBA> EXECUTE DBMS_SHARED_POOL.KEEP('SYS.DIANA');
DBA-00342: unable to complete internal login
ORA-01034: ORACLE not available
ORA-07625: smsget: $MGBLSC failure
%SYSTEM-W-NOSUCHSEC, no such (global) section
SQLDBA> EXECUTE DBMS_SHARED_POOL.KEEP('SYS.DBMS_UTILITY');
DBA-00342: unable to complete internal login
ORA-01034: ORACLE not available
ORA-07625: smsget: $MGBLSC failure
%SYSTEM-W-NOSUCHSEC, no such (global) section
SQLDBA> EXECUTE DBMS_SHARED_POOL.KEEP('SYS.DBMS_SHARED_POOL');
DBA-00342: unable to complete internal login
ORA-01034: ORACLE not available
ORA-07625: smsget: $MGBLSC failure
%SYSTEM-W-NOSUCHSEC, no such (global) section
SQLDBA>
SQLDBA> exit
SQL*DBA complete.
============================================================
3.If I do a sqlplus or svrmgr
========================================
│DBA-00302: not connected to a database │
│>CONNECT SYS/**** │
│ORA-01034: ORACLE not available │
│ORA-07625: smsget: $MGBLSC failure │
│%SYSTEM-W-NOSUCHSEC, no such (global) section │
│
=================================================
[Updated on: Mon, 16 August 2010 14:30] Report message to a moderator
|
|
|
|
|
Re: Oracle Recovery [message #476359 is a reply to message #472521] |
Wed, 22 September 2010 14:54 |
sunnys_neil
Messages: 9 Registered: July 2010 Location: KY
|
Junior Member |
|
|
The db is in NOARCHIVELOG mode, So recovery is not possible. I have an RMAN dump file of the whole db but when I run 'imp' command on the spare it errors out saying oracle not available.
============================================
============================================
""""" ORA-01034: ORACLE not available │
│ORA-07625: smsget: $MGBLSC failure │
│%SYSTEM-W-NOSUCHSEC, no such (global) section │
│ """"
============================================
============================================
I tried few different things in the last few days but no luck. I can connect internal and mount the DB but when I tried to open the DB , it says 'ora-01589': must use resetlogs or noresetlogs option. When I typed 'alter db open resetlogs' , it comes up with 'ora-01194: and ora-01110:' errors. How can I drop a particular tablespace and recreate it ? Do I need to mount the db and drop tablespacees??
|
|
|
|
|
|
|
Re: Oracle Recovery [message #476498 is a reply to message #476494] |
Thu, 23 September 2010 10:30 |
|
Michel Cadot
Messages: 68728 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Michel Cadot wrote on Wed, 22 September 2010 22:04Quote: I have an RMAN dump file of the whole db but when I run 'imp' command
You are all wrong.
RMAN backup is restored by RMAN.
Export file can be imported by "imp".
Regards
Michel
|
|
|