Control file for Oracle Restore

[Former Member]

Hello All,

We are making use of only ABAP stack of SAP ECC 6.0 Sr3 version

Database version is Oracle 10.2

how can i generate control file for ABAP stack only for database restore?

Please Guide

Best Regards,

Amol Dounde

[Former Member]

Hi Amol,

We discussed the issue in my previous threads;

http://scn.sap.com/thread/3223223

Best regards,

Orkun Gedik

[Former Member]

hi Amol,

in addition to  Huseyin Bilgen

for trace file location

on sql prompt.

:>show parameter user;

check for *.trc file with latest time stamp

[HuseyinBilgen]

Hi,

Logon to your os with ora<sid> or <sid>adm if OS is Windows.

Open command prompt or shell and run the following commands:

1. sqlplus "/as sysdba"

2. alter database backup controlfile to trace;

Then check the Oracle Trace Location to get the script.

[Former Member]

follow http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5003.htm

good for you to know with detailed syntax.