Posts

RECLAIM SPACE IN SAP HANA DATABASE /HANA/LOG IS 100% FULL.(SAP HANA DATABASE)

RECLAIM SPACE IN /HANA/LOG IS 100% FULL. Hi team, Initially we face an issue for filling /hana/log mount in sap hana database. But firstly let me know you guys that how to reclaim the space in server when your /hana/log mount point is getting full. Step1) Initially take full complete backup from hana studio and while backup is complete take system backup also. Step2) Open hana studio with system user database and also with your tenant database and run “ALTER SYSTEM RECLAIM LOG”. Step3) while running the same, you find space is get reclaimed on prod server. In case when /hana/log is get 100%   in this case, shutdown the database immediately and then move small archive log of alteast 2 GB to run the database. 1)      Move the archive logs to another location where space is available and make linking to start the database part. Use command ln -s to create linking and use unlink command to unlink the linking. 2)  ...

Windows 10 has a built-in free screen recorder that you might not know about

Image
Windows 10 has a built-in free screen recorder  You've very probably been using Windows 10 for a long time now, but that doesn't mean that you've discovered everything it has to offer. The operating system is packed with features, but there are some that are hidden away to the extent that they could be considered secrets. One such gem is the screen recording tool. What? You didn't know that Windows 10 could record videos of on-screen activity? You're not alone. The screen recorder is built into the Game bar and you may well not have seen it. If you've ever wondered how to make video of what you're doing in Windows, this is precisely the utility you need. Here's how to access and use it -- including details of a secret keyboard shortcut. The screen recorder is not a standalone utility, so if you take a browse through the Start menu, you won't find it. You will, however, be able to find the Game bar -- but if you're not a gamer, ...

Physical Standby Dataguard Setup in Oracle 11g database

  Physical Standby Dataguard Setup in Oracle 11g database --- Step1 --- create 2 virtual machine with minimum of 2 GB Ram . Steps2 – install Vmware tool on machine to enable the copy of files in virtual machine. Step3 – now on 1 virtual machine , create database installation of 11g and now on another machine create software only installation on another machine. Step4—make sure both machine ip should ping successfully in order to transfer archive log from one machine to another. Primary Server Setup Logging Check that the primary database is in archivelog mode. SELECT log_mode FROM v$database; LOG_MODE ------------ NOARCHIVELOG SQL> If it is noarchivelog mode, switch is to archivelog mode. SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER DATABASE ARCHIVELOG; ALTER DATABASE OPEN; Enabled forced logging by issuing the following command. ALTER DATABASE FORCE LOGGING; Note -- The  FORCE LOGGING  option is the safest method to ensu...