Scheduling Backup In Oracle

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

Rman 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

How To Change Database In ArchiveLog Mode

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

Static and Dynamic Listener Concepts in Oracle Database

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

Unlock a User in Oracle

Summary: in this tutorial, you will learn how to unlock a user in Oracle by using the ALTER USER ACCOUNT UNLOCK statement. To unlock a user in Oracle, you follow these steps: First, log in to the Oracle Database as a SYS user. Then, use ALTER USER statement to unlock the user as follows: Note that if you unlock an account … Read more Unlock a User in Oracle

Grant Object Privilege

Summary: in this tutorial, you will learn how to use the Oracle GRANT statement to grant SELECT object privilege on one or more tables to a user. Grant SELECT on a table to a user To grant the SELECT object privilege on a table to a user or role, you use the following statement: The following example illustrates how to grant the SELECT object privilege on a … Read more Grant Object Privilege