Home » RDBMS Server » Server Utilities » Oracle Recovery (Oracle 7.1)
Oracle Recovery [message #471494] Sun, 15 August 2010 17:12 Go to next message
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 #471532 is a reply to message #471494] Mon, 16 August 2010 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As far as I remember, you have to use svrmgrl or sqldba (search which one you have in BIN directory) to connect and make the recovery.

Regards
Michel
Re: Oracle Recovery [message #471684 is a reply to message #471494] Mon, 16 August 2010 12:59 Go to previous messageGo to next message
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 #471685 is a reply to message #471684] Mon, 16 August 2010 13:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy and paste here your session.

Regards
Michel
Re: Oracle Recovery [message #471694 is a reply to message #471494] Mon, 16 August 2010 14:28 Go to previous messageGo to next message
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 #471696 is a reply to message #471694] Mon, 16 August 2010 14:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Recovery must be done when connected as internal in point 2.

Regards
Michel
Re: Oracle Recovery [message #472521 is a reply to message #471696] Sat, 21 August 2010 09:26 Go to previous messageGo to next message
crscottdba
Messages: 5
Registered: December 2008
Location: Cleveland, OH
Junior Member
As was mentioned

svrmgrl

connect internal

Then try.
Re: Oracle Recovery [message #476359 is a reply to message #472521] Wed, 22 September 2010 14:54 Go to previous messageGo to next message
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 #476361 is a reply to message #476359] Wed, 22 September 2010 15:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
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
Re: Oracle Recovery [message #476478 is a reply to message #476361] Thu, 23 September 2010 09:36 Go to previous messageGo to next message
sunnys_neil
Messages: 9
Registered: July 2010
Location: KY
Junior Member
Its Oracle 7.1 and runs on VMS operating system. I Can only get to RMAN utility by running 'exp' or 'imp' commands. I need to find out the commands on how to restore RMAN backup.

[Updated on: Thu, 23 September 2010 09:36]

Report message to a moderator

Re: Oracle Recovery [message #476484 is a reply to message #476478] Thu, 23 September 2010 10:13 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You cannot have an RMAN backup, because RMAN didn't exist in release 7.
Re: Oracle Recovery [message #476494 is a reply to message #471494] Thu, 23 September 2010 10:23 Go to previous messageGo to next message
sunnys_neil
Messages: 9
Registered: July 2010
Location: KY
Junior Member
We just have a dump file, created from 'exp' command. I thought that its a RMAN backup but its not. Not sure what else to try.
Re: Oracle Recovery [message #476498 is a reply to message #476494] Thu, 23 September 2010 10:30 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Wed, 22 September 2010 22:04
Quote:
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

Previous Topic: SQL Loader - Error
Next Topic: moving database using exp/imp
Goto Forum:
  


Current Time: Fri Mar 29 07:42:31 CDT 2024