What is a User-managed backup in oracle? User-managed backup is accomplished with whatever operating system facilities happen to be available and SQL*Plus commands. These may be as simple as the copy commands on windows or cp on Unix/Linux. The significance of archive log mode for the backup technique available is the same for user-managed backup as for server-managed […]
All posts by Anuradha Mudgal
Anuradha Mudgal
Physical Backup
What is physical Backup? The operating system saves the database files onto tape or some other media. This is useful to restire the system to an earlier point whenever needed. In its simplest form, a physical backup is the movement of all data from one raw device to another; in the context of file system […]
Logical Backup
What is a logical backup? Logical backups are backups in which the export utility (for example Exp) uses SQL to read database data and then export it into a binary file at the operating system level. You can then import the data back into a database using the import utility (Imp).The Oracle Export Utility can […]
Backup
In the 24/7 working environment, any organization requires database available all time. In business world, there are three type of users (Top Management(C.E.O, Board of Directors etc), Technical user(DBA, Developers etc.)/Non -Technical user(Hr , C.A, Market department etc.), End Users(Customers) )who interact with database any organization according to their roles and privileges. N number of activity done by them […]
Index (B-tree)
B-tree Index B-tree stands for Balanced Tree in RDBMS. It is commonly used in database and filesystem.The B-tree enables the database to find a leaf node quickly. It is a good example of a data structure for external memory. Telephone directory, library are the best example of B-tree index. Why do we use B-tree? keeps keys in […]
IOT
IOT Index IOT stands for Index Organised Table in oracle database.The idea behind an IOT is simple. You hold all the data for the table in the ordered structure of an index. Why do we use IOT? An IOT has the structure of an index and stores all the columns of the row, accesses via […]
Index In Oracle
We are living on the planet with the seven billion population.Each and every human being’s have some information. Data is an important factor in the business’s world. Every day in business’s operation we deal with data. It can be structure and un-structure data. All the report of business prepare with the help of data. We take a […]
Scenario 1 – Recover a Member of a Multiplexed Online Redo Log Group
Please follow the below steps. Steps : 1. Shutdown immediate; 2. Physically remove redo log member(no redo log group) by using OS level command. 3. Startup; 4. SELECT GROUP#, STATUS, MEMBER FROM v$LOGFILE WHERE STATUS=’INVALID’; 5. Check alert log file. Steps for Recovery : 1. Drop the damaged member ALTER DATABASE DROP LOGFILE MEMBER ‘D:\app\admin\oradata\orcl\REDO01.LOG’; […]
Catalog Database Configure
Description: RDB1 as TARGET SERVER RDB2 as CATALOG SERVER create a database using DBCA on catalog server as catalog database i.e. RDB create a service in target server for the catalog server connection. check service alias using TNSPING servicename(EX:TNSPING RDB2) in terminal […]