DBGUIDE
49 FOLLOWERS
DBGUIDE delivers simply easy learning with clear, crisp, and to-the-point content on a wide range of technical and non-technical subjects without any preconditions and impediments. Follow DBGUIDE to learn everything you need to know about Oracle.
DBGUIDE
3y ago
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 target database.
RMAN uses a media manager API to work with backup hardware. A user can log ..read more
DBGUIDE
3y ago
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 comm ..read more
DBGUIDE
3y ago
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 the client request, it selects one of the registered service handlers. Depending on the type of handler selected, the communication protocol used, and the operating system of the database server, the listener performs one of the following actions:
Hands the connect r ..read more
DBGUIDE
3y ago
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:
GRANT SELECT ON table_name TO {user | role};
The following example illustrates how to grant the SELECT object privilege on a table to a user.
First, create a new user called DW and grant the CREATE SESSION to the user:
CREATE U ..read more
DBGUIDE
3y ago
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 the database at the time of backup. Full backups of all data files are created. The results may be stored as image copies or as backup sets, but in either case, the complete contents of all datafiles of the database are represented in the ..read more
DBGUIDE
3y ago
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 target database.
RMAN uses a media manager API to work with backup hardware. A user can log ..read more
DBGUIDE
3y ago
Follows These Steps Which Is Given Below:-
Create a Script file i.e backup.sql
2. Now by This Script File You Can take backup by Directly run Script File Or You Can Scheduled a Job in Enterprise Manager .
a) Take Backup Directly By Run Script File .
b) To Schedule Backup Through Enterprise Manager
Give All Permission To rman.sh file
Open Enterprise Manager And Schedule the Job
.
Follow These Shese Steps By Given Video :- Click Here ..read more
DBGUIDE
3y ago
Follow These Steps :-
Firstly Check Your Database is In Archive log Or Not If Not CLICK HERE
2. Now Take Full Backup Of Database
3. After Taken Full Backup Now I am Going to Create a Situation .
a) Non-Critical Situation(By Deleting Users01.dbf File)
Then You Will Get This Error
For Recover Users01.dbf File .
b) Critical Situation( By Deleting System01.dbf And Undotbs01.dbf )
Then You Will Get This Error.
For Recover System01.dbf And Undotbs01.dbf File
4. Now Issue Has Been Resolved .
For Follow These Steps See this Video :- Click Here
For More Learn About Oracle :- Click Here
The ..read more
DBGUIDE
3y ago
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 comm ..read more
DBGUIDE
3y ago
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 In Emp Table
Now For Follow These Steps Given In Video :- Click Here
For Learn More About Oracle :- Click Here
Visit My Blog :- Click Here
The post SQL* LOADER In Oracle appeared first on DBGUIDE ..read more