This website is not affiliated with, sponsored by, or approved by SAP AG.

Recover the DB issue

Basis (Basis Technology Modules: Basis Component/System Administration, GUIs)

Moderators: Snowy, thx4allthefish

Recover the DB issue

Postby Sanjay_Mishra_007 » Sun Feb 24, 2013 1:52 pm


We are performing Online Restore & Recovery (Point-in-time) of PRD Server to another Mock PRD Server as a MOCK hardware migration exercise. Current Database is Oracle on Solaris 10.

Here is the steps which we performed on MOCK QA Server.

1) Install Oracle including opatch and Mopz patches (SBP)

2) Restore online Backup from disk of Feb 22nd 10.15 time.

Below is the steps as follows:

a.) Copy the backup ID bekpjxob.and to the /oracle/RP1/sapbackup

b.) Restore Backup command -

brrestore -b bekpjxob.and -d disk -p /oracle/RP1/112_64/dbs/ -m full -l E

BRRESTORE Completed successfully.

3) Copy the archive log files for point-in time recovery from the directory /brdump/BACKUPRP1 to the /oracle/RP1/oraarch directory. Point in time is Feb 23rd 10:15 time.

4) Login with SQL Plus:

sqlplus "/as sysdba"

SQL*Plus: Release Production on Sun Feb 24 18:23:25 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

SQL> startup mount
ORA-01012: not logged on

for performing recovery point-in time issue and control.sql.

Please advise...

Thanks & Regards

Posts: 113
Joined: Tue Mar 06, 2007 9:24 pm

Re: Recover the DB issue

Postby Zavaros » Mon Feb 25, 2013 4:07 am


We had similar issue: the database was started by orasid user. The sidadm was not able to connect.

In our case the solution was: set properly the setuids in the oracle bin directory.


Posts: 757
Joined: Thu Oct 24, 2002 10:50 pm
Location: Hungary

Re: Recover the DB issue

Postby blueteeth » Mon Feb 25, 2013 10:43 am

How was this control.sql generated? Please post your control.sql and one location of your datafile (entire path).

Posts: 499
Joined: Sat Apr 05, 2008 12:22 pm

Re: Recover the DB issue

Postby gvssud » Fri Apr 12, 2013 8:57 pm

Check whether you have copied archSID.log or not
Posts: 16
Joined: Tue Jul 05, 2011 6:55 am

Return to Basis

Who is online

Users browsing this forum: No registered users and 2 guests

This website is not affiliated with, sponsored by, or approved by SAP AG.