on 10-23-2007 3:56 AM
Dear ALL
I have a question about restore Oracle on-line backup using Data Protector 6.0.
We install SAP R3 ERP 4.7 as Production on HPUX , and use HP Data Protector 6.0 as backup tools to online backup Oracle data.
Recently we need to test disaster recovery process to see if it can work or not , so we decide to use the tape backup by DP6 to restore to another HPUX host ( This HPUX host is use to be our SAP Production and it still contain all the old SAP data inside it . Since it was replaced by a new one , so we can use it to restore all the data backup by DP6 )
After we use DP6.0 to restore the newest Oracle online backup data from the tape , and login HPUX use account "ora<SID>" then copy /var/opt/omni/tmp/cntrl.dbf to replace three files at
/oracle/<SID>/sapdata1/cntrl/cntrl<SID>.dbf
/oracle/<SID>/origlogA/cntrl/cntrl<SID>.dbf
/oracle/<SID>/saparch/cntrl/cntrl<SID>.dbf
and use sqlplus below
==================
1. sqlplus "/ as sysdba"
2. startup mount;
3. alter tablespace xxxx end backup; ( alter all the tablespace end backup)
4. recover database using backup controlfile until cancel;
ORA-00279: change 1898028763 generated at 10/19/2007 02:01:07 needed for thread 1
ORA-00289: suggestion : /oracle/TP1/oraarch/TP1arch1_42847.dbf
ORA-00280: change 1898028763 for thread 1 is in sequence #42847
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/TP1/sapdata1/system_1/system.data1'
ORA-01112: media recovery not started
after step 4 , some error happen , and what can i do next ??
Thanks.
All the steps are descript in the thread !
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Finally , recover database succeed.
The step i do below....
1. After restore all file from DP6.0 , I copy controlfile from /oracle/<SID>/sapbackup to /oracle/<SID>/sapdata1/cntrl/ , /oracle<SID>/origlogA/cntrl/ and /oracle/<SID>/saparch/cntrl/ .
2. sqlplus "/ as sysdba"
SQL> startup mount;
SQL> recover database using backup controlfile until cancel;
SQL> alter database open RESETLOGS;
After do that , need to assign PSAPTEMP datafile again .
Thanks for all of you. .y
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi , supriyo choudhury
After I use
SQL>Alter database backup controlfile to trace;
to generate a trace file , and modify this file to rebuild control file , but it still error.
Trace file was modify like below:
============================================================
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "TP1" NORESETLOGS ARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 255
MAXLOGMEMBERS 3
MAXDATAFILES 254
MAXINSTANCES 50
MAXLOGHISTORY 2495
LOGFILE
GROUP 1 (
'/oracle/TP1/origlogA/log_g11m1.dbf',
'/oracle/TP1/mirrlogA/log_g11m2.dbf'
) SIZE 50M,
GROUP 2 (
'/oracle/TP1/origlogB/log_g12m1.dbf',
'/oracle/TP1/mirrlogB/log_g12m2.dbf'
) SIZE 50M,
GROUP 3 (
'/oracle/TP1/origlogA/log_g13m1.dbf',
'/oracle/TP1/mirrlogA/log_g13m2.dbf'
) SIZE 50M,
GROUP 4 (
'/oracle/TP1/origlogB/log_g14m1.dbf',
'/oracle/TP1/mirrlogB/log_g14m2.dbf'
) SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'/oracle/TP1/sapdata1/system_1/system.data1',
'/oracle/TP1/sapdata2/roll_1/roll.data1',
'/oracle/TP1/sapdata3/tp1_1/tp1.data1',
'/oracle/TP1/sapdata3/tp1_2/tp1.data2',
'/oracle/TP1/sapdata3/tp1_3/tp1.data3',
'/oracle/TP1/sapdata3/tp1_4/tp1.data4',
'/oracle/TP1/sapdata4/tp1_5/tp1.data5',
'/oracle/TP1/sapdata4/tp1_6/tp1.data6',
'/oracle/TP1/sapdata4/tp1_7/tp1.data7',
'/oracle/TP1/sapdata4/tp1_8/tp1.data8',
'/oracle/TP1/sapdata4/tp1_9/tp1.data9',
'/oracle/TP1/sapdata1/tp1620_1/tp1620.data1',
'/oracle/TP1/sapdata1/tp1620_2/tp1620.data2',
'/oracle/TP1/sapdata1/tp1620_3/tp1620.data3',
'/oracle/TP1/sapdata1/tp1620_4/tp1620.data4',
'/oracle/TP1/sapdata2/tp1620_5/tp1620.data5',
'/oracle/TP1/sapdata2/tp1620_6/tp1620.data6',
'/oracle/TP1/sapdata2/tp1620_7/tp1620.data7',
'/oracle/TP1/sapdata2/tp1620_8/tp1620.data8',
'/oracle/TP1/sapdata2/tp1620_9/tp1620.data9',
'/oracle/TP1/sapdata3/tp1620_10/tp1620.data10',
'/oracle/TP1/sapdata4/tp1620_11/tp1620.data11',
'/oracle/TP1/sapdata1/tp1usr_1/tp1usr.data1',
'/oracle/TP1/sapdata4/tp1_10/tp1.data10',
'/oracle/TP1/sapdata4/tp1_11/tp1.data11',
'/oracle/TP1/sapdata4/tp1_12/tp1.data12',
'/oracle/TP1/sapdata4/tp1_13/tp1.data13',
'/oracle/TP1/sapdata4/tp1_14/tp1.data14',
'/oracle/TP1/sapdata5/tp1_15/tp1.data15',
'/oracle/TP1/sapdata5/tp1_16/tp1.data16',
'/oracle/TP1/sapdata5/tp1_17/tp1.data17',
'/oracle/TP1/sapdata5/tp1_18/tp1.data18',
'/oracle/TP1/sapdata5/tp1_19/tp1.data19',
'/oracle/TP1/sapdata5/tp1_20/tp1.data20',
'/oracle/TP1/sapdata5/tp1_21/tp1.data21',
'/oracle/TP1/sapdata5/tp1_22/tp1.data22',
'/oracle/TP1/sapdata5/tp1_23/tp1.data23',
'/oracle/TP1/sapdata5/tp1_24/tp1.data24',
'/oracle/TP1/sapdata5/tp1_25/tp1.data25',
'/oracle/TP1/sapdata5/tp1_26/tp1.data26',
'/oracle/TP1/sapdata5/tp1_27/tp1.data27',
'/oracle/TP1/sapdata5/tp1_28/tp1.data28',
'/oracle/TP1/sapdata5/tp1_29/tp1.data29',
'/oracle/TP1/sapdata5/tp1_30/tp1.data30',
'/oracle/TP1/sapdata5/tp1_31/tp1.data31',
'/oracle/TP1/sapdata6/undo_1/undo.data1',
'/oracle/TP1/sapdata6/undo_2/undo.data2',
'/oracle/TP1/sapdata6/undo_3/undo.data3',
'/oracle/TP1/sapdata6/undo_4/undo.data4',
'/oracle/TP1/sapdata6/undo_5/undo.data5',
'/oracle/TP1/sapdata5/tp1_32/tp1.data32',
'/oracle/TP1/sapdata5/tp1_33/tp1.data33',
'/oracle/TP1/sapdata5/tp1_34/tp1.data34',
'/oracle/TP1/sapdata5/tp1_35/tp1.data35',
'/oracle/TP1/sapdata5/tp1_36/tp1.data36',
'/oracle/TP1/sapdata5/tp1_37/tp1.data37',
'/oracle/TP1/sapdata5/tp1_38/tp1.data38',
'/oracle/TP1/sapdata5/tp1_39/tp1.data39',
'/oracle/TP1/sapdata5/tp1_40/tp1.data40'
CHARACTER SET WE8DEC
;
RECOVER DATABASE
ALTER SYSTEM ARCHIVE LOG ALL;
ALTER DATABASE OPEN;
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/TP1/sapdata3/temp_3/temp.data3' REUSE;
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/TP1/sapdata3/temp_2/temp.data2' REUSE;
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/TP1/sapdata3/temp_1/temp.data1' REUSE;
============================================================
and below is the error message
***********************************************************************
SQL> @tracefile
ORACLE instance started.
Total System Global Area 4210183104 bytes
Fixed Size 728000 bytes
Variable Size 939524096 bytes
Database Buffers 3268608000 bytes
Redo Buffers 1323008 bytes
CREATE CONTROLFILE REUSE DATABASE "TP1" NORESETLOGS ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01229: data file 59 is inconsistent with logs
ORA-01110: data file 59: '/oracle/TP1/sapdata5/tp1_40/tp1.data40'
SP2-0734: unknown command beginning "Recovery i..." - rest of line ignored.
SP2-0734: unknown command beginning "or if the ..." - rest of line ignored.
ORA-01507: database not mounted
SP2-0734: unknown command beginning "All logs n..." - rest of line ignored.
ALTER SYSTEM ARCHIVE LOG ALL
*
ERROR at line 1:
ORA-01507: database not mounted
SP2-0734: unknown command beginning "Database c..." - rest of line ignored.
ALTER DATABASE OPEN
*
ERROR at line 1:
ORA-01507: database not mounted
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.
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/TP1/sapdata3/temp_3/temp.data3' REUSE
*
ERROR at line 1:
ORA-01109: database not open
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/TP1/sapdata3/temp_2/temp.data2' REUSE
*
ERROR at line 1:
ORA-01109: database not open
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/TP1/sapdata3/temp_1/temp.data1' REUSE
*
ERROR at line 1:
ORA-01109: database not open
***********************************************************************
I still have no idea how to do next ??
Thanks~~~ ^^
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Pls remove lines before,
STARTUP NOMOUNT
Pls remove all the lines after CHARACTER SET WE8DEC;
-
Remove----
RECOVER DATABASE
ALTER SYSTEM ARCHIVE LOG ALL;
ALTER DATABASE OPEN;
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE
'/oracle/TP1/sapdata3/temp_3/temp.data3' REUSE;
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE
'/oracle/TP1/sapdata3/temp_2/temp.data2' REUSE;
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE
'/oracle/TP1/sapdata3/temp_1/temp.data1' REUSE;
-
then ,
Change all Source SID's to Target SID via following commands.
UNIX (VI): :%s/<SSID>/<TSID>/g
then,
Change the line
CREATE CONTROLFILE REUSE DATABASE SSID NORESETLOGS ARCHIVELOG;
as follow
CREATE CONTROLFILE REUSE SET DATABASE TSID RESETLOGS ARCHIVELOG;
then copy it to target system ,su - ora<sid>
run......
.....
SQL> @tracefile
this will successfully create the contol files....in 3 locations as required.
Message was edited by:
supriyo choudhury
Hi , supriyo choudhury
Thanks for your help .
I modify the script file like below:
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE SET DATABASE "TP1" RESETLOGS ARCHIVELOG;
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 255
MAXLOGMEMBERS 3
MAXDATAFILES 254
MAXINSTANCES 50
MAXLOGHISTORY 2495
LOGFILE
GROUP 1 (
'/oracle/TP1/origlogA/log_g11m1.dbf',
'/oracle/TP1/mirrlogA/log_g11m2.dbf'
) SIZE 50M,
GROUP 2 (
'/oracle/TP1/origlogB/log_g12m1.dbf',
'/oracle/TP1/mirrlogB/log_g12m2.dbf'
) SIZE 50M,
GROUP 3 (
'/oracle/TP1/origlogA/log_g13m1.dbf',
'/oracle/TP1/mirrlogA/log_g13m2.dbf'
) SIZE 50M,
GROUP 4 (
'/oracle/TP1/origlogB/log_g14m1.dbf',
'/oracle/TP1/mirrlogB/log_g14m2.dbf'
) SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'/oracle/TP1/sapdata1/system_1/system.data1',
'/oracle/TP1/sapdata2/roll_1/roll.data1',
'/oracle/TP1/sapdata3/tp1_1/tp1.data1',
'/oracle/TP1/sapdata3/tp1_2/tp1.data2',
'/oracle/TP1/sapdata3/tp1_3/tp1.data3',
'/oracle/TP1/sapdata3/tp1_4/tp1.data4',
'/oracle/TP1/sapdata4/tp1_5/tp1.data5',
'/oracle/TP1/sapdata4/tp1_6/tp1.data6',
'/oracle/TP1/sapdata4/tp1_7/tp1.data7',
'/oracle/TP1/sapdata4/tp1_8/tp1.data8',
'/oracle/TP1/sapdata4/tp1_9/tp1.data9',
'/oracle/TP1/sapdata1/tp1620_1/tp1620.data1',
'/oracle/TP1/sapdata1/tp1620_2/tp1620.data2',
'/oracle/TP1/sapdata1/tp1620_3/tp1620.data3',
'/oracle/TP1/sapdata1/tp1620_4/tp1620.data4',
'/oracle/TP1/sapdata2/tp1620_5/tp1620.data5',
'/oracle/TP1/sapdata2/tp1620_6/tp1620.data6',
'/oracle/TP1/sapdata2/tp1620_7/tp1620.data7',
'/oracle/TP1/sapdata2/tp1620_8/tp1620.data8',
'/oracle/TP1/sapdata2/tp1620_9/tp1620.data9',
'/oracle/TP1/sapdata3/tp1620_10/tp1620.data10',
'/oracle/TP1/sapdata4/tp1620_11/tp1620.data11',
'/oracle/TP1/sapdata1/tp1usr_1/tp1usr.data1',
'/oracle/TP1/sapdata4/tp1_10/tp1.data10',
'/oracle/TP1/sapdata4/tp1_11/tp1.data11',
'/oracle/TP1/sapdata4/tp1_12/tp1.data12',
'/oracle/TP1/sapdata4/tp1_13/tp1.data13',
'/oracle/TP1/sapdata4/tp1_14/tp1.data14',
'/oracle/TP1/sapdata5/tp1_15/tp1.data15',
'/oracle/TP1/sapdata5/tp1_16/tp1.data16',
'/oracle/TP1/sapdata5/tp1_17/tp1.data17',
'/oracle/TP1/sapdata5/tp1_18/tp1.data18',
'/oracle/TP1/sapdata5/tp1_19/tp1.data19',
'/oracle/TP1/sapdata5/tp1_20/tp1.data20',
'/oracle/TP1/sapdata5/tp1_21/tp1.data21',
'/oracle/TP1/sapdata5/tp1_22/tp1.data22',
'/oracle/TP1/sapdata5/tp1_23/tp1.data23',
'/oracle/TP1/sapdata5/tp1_24/tp1.data24',
'/oracle/TP1/sapdata5/tp1_25/tp1.data25',
'/oracle/TP1/sapdata5/tp1_26/tp1.data26',
'/oracle/TP1/sapdata5/tp1_27/tp1.data27',
'/oracle/TP1/sapdata5/tp1_28/tp1.data28',
'/oracle/TP1/sapdata5/tp1_29/tp1.data29',
'/oracle/TP1/sapdata5/tp1_30/tp1.data30',
'/oracle/TP1/sapdata5/tp1_31/tp1.data31',
'/oracle/TP1/sapdata6/undo_1/undo.data1',
'/oracle/TP1/sapdata6/undo_2/undo.data2',
'/oracle/TP1/sapdata6/undo_3/undo.data3',
'/oracle/TP1/sapdata6/undo_4/undo.data4',
'/oracle/TP1/sapdata6/undo_5/undo.data5',
'/oracle/TP1/sapdata5/tp1_32/tp1.data32',
'/oracle/TP1/sapdata5/tp1_33/tp1.data33',
'/oracle/TP1/sapdata5/tp1_34/tp1.data34',
'/oracle/TP1/sapdata5/tp1_35/tp1.data35',
'/oracle/TP1/sapdata5/tp1_36/tp1.data36',
'/oracle/TP1/sapdata5/tp1_37/tp1.data37',
'/oracle/TP1/sapdata5/tp1_38/tp1.data38',
'/oracle/TP1/sapdata5/tp1_39/tp1.data39',
'/oracle/TP1/sapdata5/tp1_40/tp1.data40'
CHARACTER SET WE8DEC
;
Then I run this script , some error show below :
SQL> @rebuildfile
ORACLE instance started.
Total System Global Area 4210183104 bytes
Fixed Size 728000 bytes
Variable Size 939524096 bytes
Database Buffers 3268608000 bytes
Redo Buffers 1323008 bytes
CREATE CONTROLFILE REUSE SET DATABASE "TP1" RESETLOGS ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '?/dbs/dbs1@.dbf'
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
SP2-0734: unknown command beginning "MAXLOGFILE..." - rest of line ignored.
SP2-0734: unknown command beginning "MAXLOGMEMB..." - rest of line ignored.
SP2-0734: unknown command beginning "MAXDATAFIL..." - rest of line ignored.
SP2-0734: unknown command beginning "MAXINSTANC..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "MAXLOGHIST..." - rest of line ignored.
SP2-0042: unknown command "LOGFILE" - rest of line ignored.
SP2-0042: unknown command "GROUP 1 (" - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning ") SIZE 50M..." - rest of line ignored.
SP2-0042: unknown command "GROUP 2 (" - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning ") SIZE 50M..." - rest of line ignored.
SP2-0042: unknown command "GROUP 3 (" - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning ") SIZE 50M..." - rest of line ignored.
SP2-0042: unknown command "GROUP 4 (" - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0042: unknown command ") SIZE 50M" - rest of line ignored.
SP2-0042: unknown command "DATAFILE" - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0734: unknown command beginning "'/oracle/T..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "CHARACTER ..." - rest of line ignored.
1* CREATE CONTROLFILE REUSE SET DATABASE "TP1" RESETLOGS ARCHIVELOG
SQL>
No idea how to do next ^^"
Java.
Hi,
I am not sure, but by the looks of it, it appears when you are creating a controlfile, oracle checks the existence of files referenced, i.e. whether the files are actually existing or not. & this may be the cause for you getting this error....
do one thing ....pls rerun the script ones more and revert....
Message was edited by:
supriyo choudhury
Hi,
Pls give the output of the following commands
alter database open;
also,
alter database open resetlogs;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
After restoring datafiles and redolog files, a scripts must be prepared on source system to create CONTROLFILE of target system. I think you just manually copied the control file.It wont work......
use,
alter database backup controlfile to trace; to create a trace file and edit it to make the script for creating control file....
Have u done this??? Pls revert back....
Supriyo Choudhury
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.