If your fra disk or archivelog directory full, your db can not process any transaction. When you increase disk size, database does not recover itself. You have to do some process. Error Solution
Oracle Control Files Content
A control file contains information about the associated database that is required for access by an instance, both at startup and during normal operation. Control file information can be modified only by Oracle Database; no database administrator or user can edit a control file. A control file contains The database name The timestamp of database…
Oracle Flashback Technology
When authorized people make mistakes, you need the tools to correct these errors. Oracle Database provides a family of human error correction technology called Flashback. Flashback revolutionizes data recovery. In the past, it might take minutes to damage a database but hours to recover it. With Flashback technology, the time to correct errors equals the…
Change Default Login Client in SAP
You can change default login client. When you run SAP GUI, Interface brings default client. Change Default Login Client RZ10 TCode for parameters Utilities > Import Profiles > Of Active Servers Back (F3) Select DEFAULT profile, Select Extended Maintenance, Click Change Button login/system_client parameter set your default client number for example 100 Copy button Back…
VMware Virtual Disk Provisioning Policies
When you perform certain virtual machine management operations, such as creating a virtual disk, cloning a virtual machine to a template, or migrating a virtual machine, you can specify a provisioning policy for the virtual disk file. NFS datastores with Hardware Acceleration and VMFS datastores support the following disk provisioning policies. On NFS datastores that…
Get Before Day Of Date With Windows Batch Script
You can use below script to get yeterday of date. Batch Script @echo off set yyyy= set $tok=1-3 for /f “tokens=1 delims=.:/-, ” %%u in (‘date /t’) do set $d1=%%u if “%$d1:~0,1%” GTR “9” set $tok=2-4 for /f “tokens=%$tok% delims=.:/-, ” %%u in (‘date /t’) do ( for /f “skip=1 tokens=2-4 delims=/-,().” %%x in (‘echo.^|date’)…
Oracle Cold-Offline Backup And Restore
You have to shutdown database to take offline backup. After shutdown database, you can take backup with two way that are rman backup database or copy Data Directory that is include datafiles, redo log files and control files. Offline-Cold Backup Database 1- Take Offline Backup With Rman SQL> shutdown immediate; SQL> startup mount; RMAN> backup…
Oracle Rman Backup Format String Clause
Rman Configure RMAN> configure channel device type disk format ‘/backup/backup_%d_s%s_p%p_%T’; %c The copy number of the backup piece within a set of duplexed backup pieces. If you did not duplex a backup, then this variable is 1 for backup sets and 0 for proxy copies. If one of these commands is enabled, then the variable…
Create Linked Server for Oracle in SQL Server 2008 R2
If you want to fetch data from Oracle to SQL Server, you can use Linked Servers features in SQL Server Database. Linked Server is like a database link (Dblink). Installation steps Install Oracle Client on SQL Server database server Restart SQL Server database service Configure OraOLEDB.Oracle provider in SQL Server database Create user for remote…
Fine Grained Auditing (FGA) in Oracle
Fine Grained Auditing (FGA), introduced with Oracle9i, can be understood as ‘policy-based auditing’. As opposed to the standard auditing functionality, FGA lets you specify the conditions necessary for an audit record. FGA policies are programatically bound to the object (table, view) by using the ‘dbms_fga’ package. You have to have a valid set of Fine-Grained…