- Connect under SVRMGRL.
- connect internal
- Startup your instance in mount mode.
=> Startup mount
- make a backup of your controlfile.
=> ALTERR DATABASE BACKUP CONTROLFILE TO TRACE
- This command build an SQL file in the "user_dump_dest" directory
like this :
Dump file /home/oracle/traces/ora_era1_9625.trc
Oracle8 Enterprise Edition Release 8.0.5.1.0 - Production
With the Partitioning and Objects options
PL/SQL Release 8.0.5.1.0 - Production
ORACLE_HOME = /oracle
System name: Linux
Node name:
Release: 2.0.36
Version: #1 Tue Oct 13 22:17:11 EDT 1998
Machine: i586
Instance name: ERA1
Redo thread mounted by this instance: 1
Oracle process number: 9
Unix process pid: 9625, image: oracle
- SESSION ID:(8.1) 1999.07.05.11.52.19.759
- 1999.07.05.11.52.19.759
# The following commands will create a new control file and use it
# to open the database.
# Data used by the recovery manager will be lost. Additional logs may
# be required for media recovery of offline data files. Use this
# only if the current version of all online logs are available.
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "ERA1" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 30
MAXINSTANCES 1
MAXLOGHISTORY 506
LOGFILE
GROUP 1 '/home/oracle/base/LOG1ERA1.DBF' SIZE 1M,
GROUP 2 '/home/oracle/base/LOG2ERA1.DBF' SIZE 1M,
GROUP 3 '/home/oracle/base/LOG3ERA1.DBF' SIZE 1M
DATAFILE
'/home/oracle/base/SYS1ERA1.DBF',
'/home/oracle/base/SYS2ERA1.DBF',
'/home/oracle/base/SYS3ERA1.DBF',
'/home/oracle/base/DES2TMP1.DBF',
'/home/oracle/base/INDX1ERA1.DBF',
'/home/oracle/base/RAW_DATA1.DBF',
'/home/oracle/base/RBS1ERA1.DBF',
'/home/oracle/base/USR1ERA1.DBF',
'/home/oracle/base/TMP1ERA1.DBF',
'/home/oracle/base/USR2ERA1.DBF'
;
# Recovery is required if any of the datafiles are restored backups,
# or if the last shutdown was not normal or immediate.
RECOVER DATABASE
# Database can now be opened normally.
ALTER DATABASE OPEN;
- You must delete all comments before "STARTUP NOMOUNT"
and Delete all the files which have been deleted by your unfortunate
user.
- Save these changes.
- Type RECOVER DATABASE USING BACKUP CONTROLFILE;
And now, you should be abble to startyour database.
Hope this helps...
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Mon Jul 05 1999 - 06:13:23 CDT
