How to restore the control files
Hi!
I am practicing some recovery scenarios in oracle 9i on WIN 2000
I am restoring the datafiles from tape drive backup to different disk,and renaming the datafile
>alter datatbase rename file d:\a to e:\a
and to change the datafiles location the control file
>alter database backup controlfile to trace;
using the latest trace file from the user_dump destination ...i am not able to recreate the control files
The content of the control file:
--------------------------------
STARTUP NOMOUNT;
CREATE CONTROLFILE REUSE DATABASE "oracle_db" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 113
LOGFILE
GROUP 1 'C:\ORACLE\ORADATA\oracle_db\REDO01.LOG' SIZE 100M,
GROUP 2 'C:\ORACLE\ORADATA\oracle_db\REDO02.LOG' SIZE 100M,
GROUP 3 'C:\ORACLE\ORADATA\oracle_db\REDO03.LOG' SIZE 100M
# STANDBY LOGFILE
DATAFILE
'C:\ORACLE\ORADATA\oracle_db\SYSTEM01.DBF',
'C:\ORACLE\ORADATA\oracle_db\UNDOTBS01.DBF',
'C:\ORACLE\ORADATA\oracle_db\CWMLITE01.DBF',
'C:\ORACLE\ORADATA\oracle_db\DRSYS01.DBF',
'C:\ORACLE\ORADATA\oracle_db\EXAMPLE01.DBF',
'C:\ORACLE\ORADATA\oracle_db\INDX01.DBF',
'C:\ORACLE\ORADATA\oracle_db\TOOLS01.DBF',
'C:\ORACLE\ORADATA\oracle_db\USERS01.DBF'
CHARACTER SET WE8MSWIN1252
;
RECOVER DATABASE
ALTER DATABASE OPEN;
ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\oracle_db\TEMP01.DBF' REUSE;
When i try to run this i am getting error!
> @C:\oracle\admin\oracle_db\udump\ORA01420.TRC
ERROR:
SQL> @C:\oracle\admin\oracle_db\udump\ORA01420.TRC
ORA-01078: failure in processing system parameters
LRM-00111: no closing quote for value 'c:'
'
SP2-0734: unknown command beginning "STANDBY LO..." - rest of line ignored.
CREATE CONTROLFILE REUSE DATABASE "ORACLE_DB" NORESETLOGS NOARCHIVELOG
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
SP2-0734: unknown command beginning "Recovery i..." - rest of line ignored.
SP2-0734: unknown command beginning "or if the ..." - rest of line ignored.
ORA-03114: not connected to ORACLE
SP2-0734: unknown command beginning "Database c..." - rest of line ignored.
ALTER DATABASE OPEN
*
ERROR at line 1:
ORA-03114: not connected to ORACLE
SP2-0734: unknown command beginning "Files in n..." - rest of line ignored.
SP2-0734: unknown command beginning "TO 'C:\ORA..." - rest of line ignored.
SP2-0734: unknown command beginning "Commands t..." - rest of line ignored.
SP2-0734: unknown command beginning "Online tem..." - rest of line ignored.
SP2-0734: unknown command beginning "Other temp..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
ALTER DATABASE RENAME FILE 'MISSING00009'
*
ERROR at line 1:
ORA-03114: not connected to ORACLE
Can anyone help me ?
Many Thanks,