You can demand stop one instance in Oracle Rac System. This stop process have to perform step by step. Firstly, stop instance after asm and finally stop applications. The first step is to stop the Oracle instance. When the instance (and related services) is down, then bring down the ASM instance. Finally, shut down the…
Tag: Oracle
Create Fast Refresh for Materialized Views in Oracle
You can demand fast refresh for materialized views. Because refresh of tables which have large data are hard. The refresh time is long. Thus, you have to use fast refresh statement for this object. Firstly, You have to create materialized view log for table. If change a data, this changes will write this log. You…
Social Engineering Attacks
All social engineering techniques are based on specific attributes of human decision-making known as cognitive biases. These biases, sometimes called “bugs in the human hardware,” are exploited in various combinations to create attack techniques, some of which are listed here: Pretexting Pretexting is the act of creating and using an invented scenario (the pretext) to…
Show Last Refresh Time of Materialized Views in Oracle
You can demand last refresh time of materialized views. You can use all_mviews view for show refresh times. Example SQL> select last_refresh_date , mview_name from all_mviews;
Export and Import Data in Oracle
Oracle’s export (exp) and import (imp) utilities are used to perform logical database backup and recovery. When exporting, database objects are dumped to a binary file which can then be imported into another Oracle database. These utilities can be used to move data between different machines, databases or schema. However, as they use a proprietary…
Alter Profile in Oracle
If you want to change profile parameters, you have to use alter command. Default User Life Time coming limited as 180 in Oracle 11g. You can change of this limit. Because this parameter cause of expired password. If you do not want to expired password, You have to change this parameter. Show Profile Parameters SQL>…
Drop User With Own Schema in Oracle
If you use cascade statement, delete user with own schema. Example SQL> Drop User username Cascade;
Delete Archivelog Using RMAN in Oracle
If your storage is about full, you must either delete old backup and archivelog or move to tape. If you want to delete archivelog from FRA(ASM Storage-Flash Revovery Area) or filesystem for win space, you can use below commands. You can delete archivelog safely, because archivelog deleting does not harm to database. Archivelog List Commands…
Use LogMiner with TOAD in Oracle
Oracle LogMiner, which is part of Oracle Database, enables you to query online and archived redo log files through a SQL interface. Redo log files contain information about the history of activity on a database. Using Log Miner utility, you can query the contents of online redo log files and archived log files. Because LogMiner…
Archivelog Mode Open and Close in Oracle
Most of the High Availability features of Oracle require you to enable ARCHIVELOG mode for your database. When you enable this mode redo logs will be archived instead of overwritten. The archivelogs are stored in a seperate place usually can backed up regularly by your standard filesystem backup system. Archive logs are utilized by RMAN,…