SAP Sql commands

-

SAP Sql Commands ..



ALTER DATABASE OPEN READ WRITE;
STARTUP MOUNTALTER DATABASE DATAFILE 1 ONLINERECOVER DATABASE
STARTUP MOUNTRECOVER DATABASE USING BACKUP CONTROLFILE recover database using backup controlfile until cancel;recover database using backup until cancel;
select name,status from v$datafile;recover datafile '/oracle/AEQ/sapdata1/system_1/system.data1';


=============================================================Backup Restore Command======================brrestore –m full –d disksqlplus /nologconnect /as sysdbashutdown;startup mount;recover database using backup controlfile until cancel;
Now type auto and press enter
===============================================================Disable archivelog in oracle:=============================stopsapsu - orabsmsqlplus "/as sysdba"shutdownstartup mountalter database noarchivelog;archive log listalter database open;startsap==============================================================Enable archivelog in oracle:============================stopsapsu - orabsmsqlplus "/as sysdba"shutdownstartup mountalter database archivelog;archive log listalter database open;startsap===============================================================







Comments

Post a Comment

Popular posts from this blog

SAP NWA: Net Weaver Administration Tool

-
SAP ERP NWA Tool    SAP NetWeaver Administrator  Use SAP NetWeaver Administrator is a Web-based tool for administration and monitoring that offers a single entry point to configure, administer, and monitor your SAP NetWeaver system, its components, and the applications running on top of it. Prerequisites The Application Server Java (AS Java) is running. Features The SAP NetWeaver Administrator unifies the most important administration, monitoring, and troubleshooting tools. Some of the main SAP NetWeaver Administrator features are:  ●  A single, central tool for administration, troubleshooting, and problem analysis of your SAP NetWeaver system. You can perform administration tasks, such as starting and stopping instances, checking and modifying configuration settings, analyzing logs and traces, ensuring the error-free functioning of all system components by continuous system monitoring.  ●  An easy-to-use, task-oriented interface.  ...
Read more

Advanced JAVA

-
Advance JAVA : IT Training : Scope n Overview : Content Advanced Java Training 1  About Advanced Java Training 2  Advanced Java Training Course Prerequisite 3  Advanced Java Training Course Objective 4  Advanced Java Training Course Duration 5  Advanced Java Training Course Content Overview 6  JDBC 7  Servlets 8  JSP 8.0.1  share training and course content with friends and students: 8.1  Share this: About Advanced Java Training  The course builds a strong understanding of JDBC Technology. It gives in to demonstrate why Servlets are the cornerstone of Java’s Web platform. It then shows how JSP is built on the Servlet architecture. Additionally, the class shows students how to use JSTL, custom tags and expression language to reduce Java code in Web pages while adding tremendous power and capability to those pages. The class culminates in an exploration of Java MVC frameworks like Struts at...
Read more

SAP BASIS SPOOLING : Printing problems and general issues

-
Image
SAP BASIS Printing problems : General Issues How to Resolve SAP Printing Problems Print request from SAP R/3 is not printing. Try to print something else from a different application (for instance an email message or a page from Netscape) via the network. If you cannot print at all then the problem is not SAP printing, but the network. If you can print a file from a different application but not from SAP, then the problem is SAP printing and probably not the network. If you have a local IT support provider , report the problem to this person. Tell your IT support provider the four-character printer name, e.g. "wtpr". Remember to give the four-character name of the printer and its location. You can find this information in SAP by looking at your User Profile or opening the Print Screen List screen. the SAP system from which you sent the print request the spool request number displa...
Read more