SAP datarestore with differnt SID and drive letter

[Former Member]

Dear  GURUs,

                   I wated to restore our prd  data our QAS system.source(PRD) and target QAS) system are database drive are different.I have created control file.

below is source system file.

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE "PRD" RESETLOGS  ARCHIVELOG

    MAXLOGFILES 255

    MAXLOGMEMBERS 3

    MAXDATAFILES 254

    MAXINSTANCES 50

    MAXLOGHISTORY 11680

LOGFILE

  GROUP 1 (

    'G:\ORACLE\PRD\ORIGLOGA\LOG_G11M1.DBF',

    'G:\ORACLE\PRD\MIRRLOGA\LOG_G11M2.DBF'

  ) SIZE 50M,

  GROUP 2 (

    'G:\ORACLE\PRD\ORIGLOGB\LOG_G12M1.DBF',

    'G:\ORACLE\PRD\MIRRLOGB\LOG_G12M2.DBF'

  ) SIZE 50M,

  GROUP 3 (

    'G:\ORACLE\PRD\ORIGLOGA\LOG_G13M1.DBF',

    'G:\ORACLE\PRD\MIRRLOGA\LOG_G13M2.DBF'

  ) SIZE 50M,

  GROUP 4 (

    'G:\ORACLE\PRD\ORIGLOGB\LOG_G14M1.DBF',

    'G:\ORACLE\PRD\MIRRLOGB\LOG_G14M2.DBF'

  ) SIZE 50M

-- STANDBY LOGFILE

DATAFILE

  'G:\ORACLE\PRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1',

  'G:\ORACLE\PRD\SAPDATA1\UNDO_1\UNDO.DATA1',

  'G:\ORACLE\PRD\SAPDATA1\SYSAUX_1\SYSAUX.DATA1',

  'G:\ORACLE\PRD\SAPDATA3\SR3_1\SR3.DATA1',

  'G:\ORACLE\PRD\SAPDATA3\SR3_2\SR3.DATA2',

  'G:\ORACLE\PRD\SAPDATA3\SR3_3\SR3.DATA3',

  'G:\ORACLE\PRD\SAPDATA3\SR3_4\SR3.DATA4',

  'G:\ORACLE\PRD\SAPDATA3\SR3_5\SR3.DATA5',

  'G:\ORACLE\PRD\SAPDATA3\SR3_6\SR3.DATA6',

  'G:\ORACLE\PRD\SAPDATA3\SR3_7\SR3.DATA7',

  'G:\ORACLE\PRD\SAPDATA3\SR3_8\SR3.DATA8',

  'G:\ORACLE\PRD\SAPDATA3\SR3_9\SR3.DATA9',

  'G:\ORACLE\PRD\SAPDATA3\SR3_10\SR3.DATA10',

  'G:\ORACLE\PRD\SAPDATA3\SR3_11\SR3.DATA11',

  'G:\ORACLE\PRD\SAPDATA3\SR3_12\SR3.DATA12',

  'G:\ORACLE\PRD\SAPDATA3\SR3_13\SR3.DATA13',

  'G:\ORACLE\PRD\SAPDATA3\SR3_14\SR3.DATA14',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_1\SR3700.DATA1',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_2\SR3700.DATA2',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_3\SR3700.DATA3',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_4\SR3700.DATA4',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_5\SR3700.DATA5',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_6\SR3700.DATA6',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_7\SR3700.DATA7',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_8\SR3700.DATA8',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_9\SR3700.DATA9',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_10\SR3700.DATA10',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_11\SR3700.DATA11',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_12\SR3700.DATA12',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_13\SR3700.DATA13',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_14\SR3700.DATA14',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_15\SR3700.DATA15',

  'G:\ORACLE\PRD\SAPDATA4\SR3USR_1\SR3USR.DATA1'

CHARACTER SET UTF8

;

For my target QAS system system drive letter is C: instead of g: so i had change it c: and change SID . Please check that below control file. ok or not

STARTUP NOMOUNT

CREATE CONTROLFILE SET DATABASE "QAS" RESETLOGS  ARCHIVELOG

    MAXLOGFILES 255

    MAXLOGMEMBERS 3

    MAXDATAFILES 254

    MAXINSTANCES 50

    MAXLOGHISTORY 11680

LOGFILE

  GROUP 1 (

    'C:\ORACLE\PRD\ORIGLOGA\LOG_G11M1.DBF',

    'C:\ORACLE\PRD\MIRRLOGA\LOG_G11M2.DBF'

  ) SIZE 50M,

  GROUP 2 (

    'C:\ORACLE\PRD\ORIGLOGB\LOG_G12M1.DBF',

    'C:\ORACLE\PRD\MIRRLOGB\LOG_G12M2.DBF'

  ) SIZE 50M,

  GROUP 3 (

    'C:\ORACLE\PRD\ORIGLOGA\LOG_G13M1.DBF',

    'C:\ORACLE\PRD\MIRRLOGA\LOG_G13M2.DBF'

  ) SIZE 50M,

  GROUP 4 (

    'C:\ORACLE\PRD\ORIGLOGB\LOG_G14M1.DBF',

    'C:\ORACLE\PRD\MIRRLOGB\LOG_G14M2.DBF'

  ) SIZE 50M

-- STANDBY LOGFILE

DATAFILE

  'C:\ORACLE\PRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1',

  'C:\ORACLE\PRD\SAPDATA1\UNDO_1\UNDO.DATA1',

  'C:\ORACLE\PRD\SAPDATA1\SYSAUX_1\SYSAUX.DATA1',

  'C:\ORACLE\PRD\SAPDATA3\SR3_1\SR3.DATA1',

  'C:\ORACLE\PRD\SAPDATA3\SR3_2\SR3.DATA2',

  'C:\ORACLE\PRD\SAPDATA3\SR3_3\SR3.DATA3',

  'C:\ORACLE\PRD\SAPDATA3\SR3_4\SR3.DATA4',

  'C:\ORACLE\PRD\SAPDATA3\SR3_5\SR3.DATA5',

  'C:\ORACLE\PRD\SAPDATA3\SR3_6\SR3.DATA6',

  'C:\ORACLE\PRD\SAPDATA3\SR3_7\SR3.DATA7',

  'C:\ORACLE\PRD\SAPDATA3\SR3_8\SR3.DATA8',

  'C:\ORACLE\PRD\SAPDATA3\SR3_9\SR3.DATA9',

  'C:\ORACLE\PRD\SAPDATA3\SR3_10\SR3.DATA10',

  'C:\ORACLE\PRD\SAPDATA3\SR3_11\SR3.DATA11',

  'C:\ORACLE\PRD\SAPDATA3\SR3_12\SR3.DATA12',

  'C:\ORACLE\PRD\SAPDATA3\SR3_13\SR3.DATA13',

  'C:\ORACLE\PRD\SAPDATA3\SR3_14\SR3.DATA14',

  'C:\ORACLE\PRD\SAPDATA2\SR3700_1\SR3700.DATA1',

  'C:\ORACLE\PRD\SAPDATA2\SR3700_2\SR3700.DATA2',

  'C:\ORACLE\PRD\SAPDATA2\SR3700_3\SR3700.DATA3',

  'C:\ORACLE\PRD\SAPDATA2\SR3700_4\SR3700.DATA4',

  'C:\ORACLE\PRD\SAPDATA2\SR3700_5\SR3700.DATA5',

  'C:\ORACLE\PRD\SAPDATA2\SR3700_6\SR3700.DATA6',

  'C:\ORACLE\PRD\SAPDATA2\SR3700_7\SR3700.DATA7',

  'C:\ORACLE\PRD\SAPDATA2\SR3700_8\SR3700.DATA8',

  'C:\ORACLE\PRD\SAPDATA2\SR3700_9\SR3700.DATA9',

  'C:\ORACLE\PRD\SAPDATA2\SR3700_10\SR3700.DATA10',

  'C:\ORACLE\PRD\SAPDATA2\SR3700_11\SR3700.DATA11',

  'C:\ORACLE\PRD\SAPDATA2\SR3700_12\SR3700.DATA12',

  'C:\ORACLE\PRD\SAPDATA2\SR3700_13\SR3700.DATA13',

  'C:\ORACLE\PRD\SAPDATA2\SR3700_14\SR3700.DATA14',

  'C:\ORACLE\PRD\SAPDATA2\SR3700_15\SR3700.DATA15',

  'C:\ORACLE\PRD\SAPDATA4\SR3USR_1\SR3USR.DATA1'

CHARACTER SET UTF8

;

Please check it this file. is it correct or now. is there any other change i need in this file.

[former_member188883 · Accepted solution]

Hi Sahil,

In your case you need to change the drive location in the backup file which shall be used for restoration. Once the restore is done you shall use the above mentioned contolfile to create new controlfiles and then recover your database.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Dear Sahil,

           Thanks for ur reply

Is this correct control file?should I use create control file before restore or after restore.

[Former Member · Accepted solution]

Hi,

  Perform the following actions.

1. First copy the data files from the source to Target location. ( Copy as per the control file).

2. Then create the control file.

3. If the datafile is not present as per the control file, you will face the error.

4. Create the control file.

5. Copy the archive logs from source to target and change the SID from PRD to QAS.

6. Recover the database  and apply the logs.

Please check and provide your feedback.

Thanks and Regards,

Vimal

[former_member188883 · Accepted solution]

Hi Sahil,

Once the restore is done you need to start the database in mount state. Then execute this control.sql script to generate new controlfiles. After this you may recover your database and open the system using resetlog option.

Regards,

Deepak Kori

[Former Member · Accepted solution]

when i m creating new control file.what I have change SID  PRD to QAS

CREATE CONTROLFILE REUSE DATABASE "PRD" RESETLOGS  ARCHIVELOG

and in below code tooo. should i change PRD to QAS for target system control file.?

LOGFILE

  GROUP 1 (

    'G:\ORACLE\PRD\ORIGLOGA\LOG_G11M1.DBF',

    'G:\ORACLE\PRD\MIRRLOGA\LOG_G11M2.DBF'

  ) SIZE 50M,

  GROUP 2 (

    'G:\ORACLE\PRD\ORIGLOGB\LOG_G12M1.DBF',

    'G:\ORACLE\PRD\MIRRLOGB\LOG_G12M2.DBF'

  ) SIZE 50M,

  GROUP 3 (

    'G:\ORACLE\PRD\ORIGLOGA\LOG_G13M1.DBF',

    'G:\ORACLE\PRD\MIRRLOGA\LOG_G13M2.DBF'

  ) SIZE 50M,

  GROUP 4 (

    'G:\ORACLE\PRD\ORIGLOGB\LOG_G14M1.DBF',

    'G:\ORACLE\PRD\MIRRLOGB\LOG_G14M2.DBF'

  ) SIZE 50M

-- STANDBY LOGFILE

DATAFILE

  'G:\ORACLE\PRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1',

  'G:\ORACLE\PRD\SAPDATA1\UNDO_1\UNDO.DATA1',

  'G:\ORACLE\PRD\SAPDATA1\SYSAUX_1\SYSAUX.DATA1',

  'G:\ORACLE\PRD\SAPDATA3\SR3_1\SR3.DATA1',

  'G:\ORACLE\PRD\SAPDATA3\SR3_2\SR3.DATA2',

  'G:\ORACLE\PRD\SAPDATA3\SR3_3\SR3.DATA3',

  'G:\ORACLE\PRD\SAPDATA3\SR3_4\SR3.DATA4',

  'G:\ORACLE\PRD\SAPDATA3\SR3_5\SR3.DATA5',

  'G:\ORACLE\PRD\SAPDATA3\SR3_6\SR3.DATA6',

  'G:\ORACLE\PRD\SAPDATA3\SR3_7\SR3.DATA7',

  'G:\ORACLE\PRD\SAPDATA3\SR3_8\SR3.DATA8',

  'G:\ORACLE\PRD\SAPDATA3\SR3_9\SR3.DATA9',

  'G:\ORACLE\PRD\SAPDATA3\SR3_10\SR3.DATA10',

  'G:\ORACLE\PRD\SAPDATA3\SR3_11\SR3.DATA11',

  'G:\ORACLE\PRD\SAPDATA3\SR3_12\SR3.DATA12',

  'G:\ORACLE\PRD\SAPDATA3\SR3_13\SR3.DATA13',

  'G:\ORACLE\PRD\SAPDATA3\SR3_14\SR3.DATA14',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_1\SR3700.DATA1',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_2\SR3700.DATA2',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_3\SR3700.DATA3',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_4\SR3700.DATA4',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_5\SR3700.DATA5',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_6\SR3700.DATA6',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_7\SR3700.DATA7',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_8\SR3700.DATA8',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_9\SR3700.DATA9',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_10\SR3700.DATA10',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_11\SR3700.DATA11',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_12\SR3700.DATA12',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_13\SR3700.DATA13',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_14\SR3700.DATA14',

  'G:\ORACLE\PRD\SAPDATA2\SR3700_15\SR3700.DATA15',

  'G:\ORACLE\PRD\SAPDATA4\SR3USR_1\SR3USR.DA

[Former Member · Accepted solution]

Yes. You have to change it.

As well as for example, you have to create a folder 'G:\ORACLE\QAS\SAPDATA1\SYSTEM_1  and then try to copy the SYSTEM.DATA1 file to it.

Please do the same for the rest of the files.

G:\ORACLE\PRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1  , here PRD resembles the folder name....

Please check and provide your feedback.

[Reagan · Accepted solution]

Hello

Once the restore is done you need to start the database in mount state.

The database should be in nomount state.

Cheers

RB

[Former Member]

Hi,

Please find the steps

1) Take offline backup of both the server (source and target servers)

2) Verify the backup is successfully done.

3) Run the following command on source system.

a) Login as <sid>adm

b) Sqlplus /nolog

c) connect sys as sysdba

d) alter database backup controlfile to trace;

e) exit;

f) Above command will generate a .trc file in /oracle/P01/saptrace/usertrace

1. directory.

g) Copy the text from CREATE CONTROLFILE until the (;) and paste it in to any new.sql or controlfile.sql file.

h) Copy the controlfile.sql to target system.

i) Edit the file and replace the entire source SID to target SID.

j) Edit the reuse database command with the set database command

4) Copy the aft generated during the backup file from the source system to target

1. system. (/oracle/<SID>/sapbackup)

a) Change the entire source <SID> to target <SID>.

b) Only don't change the backup volume name it must be target system <SID>.

1. c. Copy the above aft file name line from the source back<SID>.log to

target<SID>.log file.

5) Shutdown the target server instance.

6) From this onwards all the command on the target system only.

a) Login as <SID>adm

b) run the SAPDBA

c) select J (Restore/Recovery)

d) select B (Full restore and recovery)

e) select A (Select backup of type)

f) Select the offline backup which you want to restore

g) It will take some time to restore.

h) Once the database is restored login as <SID>adm and run the

i) Sqlplus

j) connect sys as sysdba;

k) startup nomount (if the database is already mounted shutdown it using the

shutdown command)

l) run the following command

m) @controlfile.sql (file name of the control file contains the CREATE CONTROLFILEstatement)

n) After the run the above command it should give the "Statement Processed)

o) alter database open resetlogs p. shutdown

p) Start the database and SAP services using startup.

Regards

Mukunthan    

[chhotanbarua]

Hi,

Please explain step 4 in details:

"

4) Copy the aft generated during the backup file from the source system to target

1. system. (/oracle/<SID>/sapbackup)

a) Change the entire source <SID> to target <SID>.b) Only don't change the backup volume name it must be target system <SID>.

1. c. Copy the above aft file name line from the source back<SID>.log to

target<SID>.log file."

I am getting following errors:

BR0386E File '/oracle/PES/sapdata3/sr3700_13/sr3700.data13' reported as not found by backup utility

BR0386E File '/oracle/PES/sapdata2/sr3_17/sr3.data17' reported as not found by backup utility

BR0386E File '/oracle/PES/sapdata2/sr3_2/sr3.data2' reported as not found by backup utility

BR0386E File '/oracle/PES/sapdata1/sr3_24/sr3.data24' reported as not found by backup utility

BR0386E File '/oracle/PES/sapdata2/sr3_20/sr3.data20' reported as not found by backup utility

BR0386E File '/oracle/PES/sapdata2/sr3_6/sr3.data6' reported as not found by backup utility

BR0386E File '/oracle/PES/sapdata1/sr3_27/sr3.data27' reported as not found by backup utility

BR0386E File '/oracle/PES/sapdata2/sr3_16/sr3.data16' reported as not found by backup utility

BR0386E File '/oracle/PES/sapdata4/sr3700_26/sr3700.data26' reported as not found by backup utility

BR0386E File '/oracle/PES/sapdata2/sr3_13/sr3.data13' reported as not found by backup utility

BR0386E File '/oracle/PES/sapdata3/sr3700_16/sr3700.data16' reported as not found by backup utility

BR0386E File '/oracle/PES/sapdata2/sr3_7/sr3.data7' reported as not found by backup utility

BR0386E File '/oracle/PES/sapdata3/sr3700_12/sr3700.data12' reported as not found by backup utility

BKI1215I: Average transmission rate was 0.000 GB/h (0.000 MB/sec).

BKI0020I: End of program at: Thu 13 Jun 2013 10:50:23 AM BDT .

BKI0021I: Elapsed time: 01 sec .

BKI0024I: Return code is: 2.

BR0280I BRRESTORE time stamp: 2013-06-13 10.50.23

BR0279E Return code from '/usr/sap/PES/SYS/exe/run/backint -u PES -f restore -i /oracle/PES/sapbackup/.relkjszq.lst -t file -p /oracle/PES/112_64/dbs/initPES.utl -c': 2

BR0374E 0 of 61 files restored by backup utility

BR0280I BRRESTORE time stamp: 2013-06-13 10.50.23

BR0231E Backup utility call failed

BR0406I End of file restore: relkjszq.rsb 2013-06-13 10.50.23

BR0280I BRRESTORE time stamp: 2013-06-13 10.50.23

BR0404I BRRESTORE terminated with errors

regards,

[Reagan]

Hello

Create a file called control.sql in the home directory of qasadm and put the below contents is the file and save it:

CREATE CONTROLFILE SET DATABASE "QAS" RESETLOGS ARCHIVELOG

    MAXLOGFILES 255

    MAXLOGMEMBERS 3

    MAXDATAFILES 254

    MAXINSTANCES 50

    MAXLOGHISTORY 11680

LOGFILE

  GROUP 1 (

    'C:\ORACLE\QAS\ORIGLOGA\LOG_G11M1.DBF',

    'C:\ORACLE\QAS\MIRRLOGA\LOG_G11M2.DBF'

  ) SIZE 50M,

  GROUP 2 (

    'C:\ORACLE\QAS\ORIGLOGB\LOG_G12M1.DBF',

    'C:\ORACLE\QAS\MIRRLOGB\LOG_G12M2.DBF'

  ) SIZE 50M,

  GROUP 3 (

    'C:\ORACLE\QAS\ORIGLOGA\LOG_G13M1.DBF',

    'C:\ORACLE\QAS\MIRRLOGA\LOG_G13M2.DBF'

  ) SIZE 50M,

  GROUP 4 (

    'C:\ORACLE\QAS\ORIGLOGB\LOG_G14M1.DBF',

    'C:\ORACLE\QAS\MIRRLOGB\LOG_G14M2.DBF'

  ) SIZE 50M

-- STANDBY LOGFILE

DATAFILE

  'C:\ORACLE\QAS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1',

  'C:\ORACLE\QAS\SAPDATA1\UNDO_1\UNDO.DATA1',

  'C:\ORACLE\QAS\SAPDATA1\SYSAUX_1\SYSAUX.DATA1',

  'C:\ORACLE\QAS\SAPDATA3\SR3_1\SR3.DATA1',

  'C:\ORACLE\QAS\SAPDATA3\SR3_2\SR3.DATA2',

  'C:\ORACLE\QAS\SAPDATA3\SR3_3\SR3.DATA3',

  'C:\ORACLE\QAS\SAPDATA3\SR3_4\SR3.DATA4',

  'C:\ORACLE\QAS\SAPDATA3\SR3_5\SR3.DATA5',

  'C:\ORACLE\QAS\SAPDATA3\SR3_6\SR3.DATA6',

  'C:\ORACLE\QAS\SAPDATA3\SR3_7\SR3.DATA7',

  'C:\ORACLE\QAS\SAPDATA3\SR3_8\SR3.DATA8',

  'C:\ORACLE\QAS\SAPDATA3\SR3_9\SR3.DATA9',

  'C:\ORACLE\QAS\SAPDATA3\SR3_10\SR3.DATA10',

  'C:\ORACLE\QAS\SAPDATA3\SR3_11\SR3.DATA11',

  'C:\ORACLE\QAS\SAPDATA3\SR3_12\SR3.DATA12',

  'C:\ORACLE\QAS\SAPDATA3\SR3_13\SR3.DATA13',

  'C:\ORACLE\QAS\SAPDATA3\SR3_14\SR3.DATA14',

  'C:\ORACLE\QAS\SAPDATA2\SR3700_1\SR3700.DATA1',

  'C:\ORACLE\QAS\SAPDATA2\SR3700_2\SR3700.DATA2',

  'C:\ORACLE\QAS\SAPDATA2\SR3700_3\SR3700.DATA3',

  'C:\ORACLE\QAS\SAPDATA2\SR3700_4\SR3700.DATA4',

  'C:\ORACLE\QAS\SAPDATA2\SR3700_5\SR3700.DATA5',

  'C:\ORACLE\QAS\SAPDATA2\SR3700_6\SR3700.DATA6',

  'C:\ORACLE\QAS\SAPDATA2\SR3700_7\SR3700.DATA7',

  'C:\ORACLE\QAS\SAPDATA2\SR3700_8\SR3700.DATA8',

  'C:\ORACLE\QAS\SAPDATA2\SR3700_9\SR3700.DATA9',

  'C:\ORACLE\QAS\SAPDATA2\SR3700_10\SR3700.DATA10',

  'C:\ORACLE\QAS\SAPDATA2\SR3700_11\SR3700.DATA11',

  'C:\ORACLE\QAS\SAPDATA2\SR3700_12\SR3700.DATA12',

  'C:\ORACLE\QAS\SAPDATA2\SR3700_13\SR3700.DATA13',

  'C:\ORACLE\QAS\SAPDATA2\SR3700_14\SR3700.DATA14',

  'C:\ORACLE\QAS\SAPDATA2\SR3700_15\SR3700.DATA15',

  'C:\ORACLE\QAS\SAPDATA4\SR3USR_1\SR3USR.DATA1'

CHARACTER SET UTF8

;

sqlplus "/as sysdba"

startup nomount

@control.sql

alter database open resetlogs;

Cheers

RB