cancel
Showing results for 
Search instead for 
Did you mean: 

After Data protecter 6.0 restore Oracle on-line backup

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

All the steps are descript in the thread !

Former Member
0 Kudos

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

Former Member
0 Kudos

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~~~ ^^

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

Check the path for all the files in locations given by you in Executable file

ORA-01565: error in identifying file '?/dbs/dbs1@.dbf'

ORA-27037: unable to obtain file status

Its not finding the files in the specified path , Make sure you have right path

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi,

Pls give the output of the following commands

alter database open;

also,

alter database open resetlogs;

Former Member
0 Kudos

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