admin

Performing and Scheduling Backups with Enterprise Manager Enterprise Manager lets you perform all of the different backup types supported by RMAN, and schedule the different backup jobs required by your backup strategy. Performing a Whole Database Backup with Oracle Enterprise Manager Whole backups of a database are based on backing up the entire contents of … Read more Scheduling Backup In Oracle

Oracle RMAN (Oracle Recovery Manager) is a utility built into Oracle databases to automate backup and recovery; it includes features not available in third-party backup tools. RMAN was introduced in Oracle release 8.0. How RMAN works The RMAN environment must include a target database and the RMAN client. RMAN performs backups on the target database, and the client is the application that manages backup and recovery for the … Read more Rman Backup In Oracle

1. Check Database is In Archive Log Mode Or Not SQL > select name,log_mode from v$database; NAME LOG_MODE ———————- —————————– MYDB NOARCHIVELOG 2. To enable ARCHIVELOG mode status, enter the following SQL commands: SQL> Shutdown immediate SQL> Startup mount SQL> Alter database archivelog; SQL> alter database open; 3. To check the ARCHIVELOG mode status, enter the following SQL command: … Read more How To Change Database In ArchiveLog Mode

Firstly Download Emp Text File :- Click Here For Download Emp Control File :- Click Here Now Follow These Steps 1.Open The Emp.txt in VI Editor. 2. Create a Emp table in Database . 3. Now Open Emp.ctl File In VI Editor And Upload The text data In Emp Table. 4. Now Check The Data … Read more SQL* LOADER In Oracle

1.First Create a Logical And Physical Directory In Linux 2. For Export Table 3. For Export Schema 4. Now Create a situation by Deleting The Scott and Hr Table 5. Now Restore the table By Import Through Backup 6. If You Want to Import these tables(Scott ,Hr) In Other Schema The You Must Create Same … Read more Export Import In Oracle

In This We Learn About How To Communicate RedHat Linux Databae With Windows OS Database There are two ways to connect with Linux OS database from with Windows database. Easy Connect Local Naming Steps:- Firstly Windows And Linux IP Must be of Same Class And From Both OS it Must Be that Each And Every … Read more Network Configuration In Oracle

What is a Listener? The listener is used to listen to network requests to connect and pass them on to the instance. Any Remote connection to the database instance is made by the listener.The single listener can connect to multiple instances, and a single instance can be connected by multiple listeners. When the listener receives … Read more Static and Dynamic Listener Concepts in Oracle Database

1. Open The Terminal  2. Write Command “dbca” 3. Now Follow The Further Steps By this Video :- Click Here 4. To Study More Click Here