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 […]
Category: BACKUP AND RECOVERY
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 […]
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 […]