backup restore

[selvakumar_p]

Dear All,

I have installed new system SAP ECC 6.0. I want to restore other system backup.

Anybody know the restore backup .

regards

kiruba

[selvakumar_p]

Thanks to all

[Former Member]

this issue resolved by myself. 
solution :
I restored archive also and afterwards I have another message when i gave the command startup, message is ORA-01589:must use RESETLOGS and NORESETLOGS option for database open


for this message need to give command ALTER DATABASE OPEN RESETLOGS;

Then after shutdown databse and startup again.

This is not an issue or bug as you haven't followed the normal recovery process after restore, so you might struggled.

If you are running on Windows just follow Sap note 50088

If your OS is *NIX, then follow 400241

Delete all the OPS$ users which are showing with source SID and recreate new OPS$ users based on new SID

Regards

Nick Loy

[selvakumar_p]

Hi Nick Loy,

I have followed this note and your instruct but still same problem.

and one thing how to change dbs_ora_schema.

Regards

kiruba

[peter_dzurov]

Execute

R3trans -dv

as <sid>adm and post trans.log afterwards.

[selvakumar_p]

Dear All,

Thank you very much for your guidence.

Solution :

I hava execute the following command and after start the sap, its working fine.

brconnect -u system/<system passwd> -f chpass -o SAPPRD -p <sapser passwd >

Regards

kiruba.

[Former Member]

Hi,

Did you restore from an online backup or offline backup ? If it is an online backup, please restore the archivelogs and recover the database using the same, before opening.

Regards,

Sanujit

[selvakumar_p]

Dear All,

Thanks to all

*****************************

SQL> startup

ORACLE instance started.

Total System Global Area 608174080 bytes

Fixed Size 1262272 bytes

Variable Size 314576192 bytes

Database Buffers 289406976 bytes

Redo Buffers 2928640 bytes

Database mounted.

ORA-01122: database file 1 failed verification check

ORA-01110: data file 1: '/oracle/PRD/sapdata1/system_1/system.data1'

ORA-01203: wrong incarnation of this file - wrong creation SCN

****************************************

this issue resolved by myself.

solution :

I restored archive also and afterwards I have another message when i gave the command startup, message is ORA-01589:must use RESETLOGS and NORESETLOGS option for database open

for this message need to give command ALTER DATABASE OPEN RESETLOGS;

Then after shutdown databse and startup again.

________________

Now I am facing an error in startsap.

the error is

/usr/sap/PRD/SYS/exe/run/startdb: Terminating with error code 12

DB startup failed

Regarding this issue I have followed belos SAP notes.

SAP notes : 50088 and 400241

still I am not able to resolve, Kindly guide me ..

Regards

kiruba.

[Former Member]

Have you recovered your database using archivelogs before starting DB(if you restored online backup)?

Regards

Nick Loy

[Former Member]

Go through www.service.sap.com/systemcopy (using backup restore method).

Regards

Nick Loy

[Former Member]

Hello,

Check the below link..

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/97a4f439-0d01-0010-d488-d29b45e2f...

Regards,

Yoganand.V

[selvakumar_p]

hi Yoganand Vedagiri ,

Thanks for your help...

I have done the backup restore afterwards i tried startup oracle, its showing the error.

The error is

SQL> startup

ORACLE instance started.

Total System Global Area 608174080 bytes

Fixed Size 1262272 bytes

Variable Size 314576192 bytes

Database Buffers 289406976 bytes

Redo Buffers 2928640 bytes

Database mounted.

ORA-01122: database file 1 failed verification check

ORA-01110: data file 1: '/oracle/PRD/sapdata1/system_1/system.data1'

ORA-01203: wrong incarnation of this file - wrong creation SCN

any solution kindly guide me

Regards

kiruba

[Former Member]

Hello,

I guess the restore done has some problems or your Backup has some problems.

Please check all the logs file such as alertlog,recovery,backup,etc.,

Regards,

Yoganand.V