Home / Oracle DBA (page 10)

Oracle DBA

ORACLE RMAN RECOVERY SCENARIOS WITH EXAMPLES

RECOVERY MANAGER (RMAN) ARCHITECTURE

ORACLE RMAN RECOVERY SCENARIOS STEPS to recover a datafile RMAN>run{sql ‘alter tablespace mydata offline’;restore tablespace mydata;recover tablespace mydata;sql ‘alter tablespace mydata online’;} STEPS to recover a system datafile RMAN>run{shutdown immediate;startup mount;restore datafile 1;recover datafile 1;sql ‘alter database open’;} STEPS to recover a redolog files RMAN>run{shutdown immediate;startup mount;set until scn 1234; …

Read More »

RECOVERY MANAGER (RMAN) ARCHITECTURE

RECOVERY MANAGER (RMAN) ARCHITECTURE

 RECOVERY MANAGER (RMAN) ARCHITECTURE RECOVERY MANAGER It is the backup methodology introduced in 8.0 which performs block level backup i.e RMAN will take the backup of only used blocks RMAN will take the information from bitmap block about used blocks and while performing this RMAN will make sure DBWRn is …

Read More »

STEPS FOR ORACLE CONTROFILE COMPLETE RECOVERY

control file complete recovery

STEPS FOR ORACLE  CONTROFILE   COMPLETE RECOVERY SQL> alter database backup controlfile to trace; The above command may not work sometimes, in which case we need to use already taken trace file during backup. This command will generate a controlfile script in udump in the form of trace file. SQL> …

Read More »

ORACLE BACKUP DATABASE RECOVERY

ORACLE BACKUP DATABASE RECOVERY

BACKUP DATABASE RECOVERY Recover is of 2 types Complete recovery – recovering database till the point of failure. No data loss Incomplete recovery – recovering to a certain time or scn. Has data loss We will perform complete recovery if we lost only data files. We will perform incomplete recovery …

Read More »

ORACLE BACKUP & RECOVERY

ORACLE BACKUP & RECOVERY

ORACLE 11G BACKUP & RECOVERY COLD BACKUP Backup is a copy of original data which will be used to recover databases. If the data is reproducable and backup not existing, still we can recover the data. But it is a tedious and time consuming task. Taking backup after shutting down …

Read More »

ORACLE DATAPUMP

DATA PUMP

ORACLE DATAPUMP Datapump is an extension to traditional exp/imp which provides more advantages like security, fastness etc. During  datapump export, oracle will create master table in the corresponding schema and data will be transferred parallely from tables to dumpfile. During datapump import this will happen in reverse order i.e from …

Read More »

ORACLE EXPORT & IMPORT

ORACLE EXPORT & IMPORT

ORACLE EXPORT & IMPORT It is the utility to transfer the data between two oracle databases. The following levels of export/import are possible Database level Schema level Table level Row level Apart from database level, we can perform other levels of export and import within the same database. Whenever session …

Read More »

about ORACLE UTILITIES ( SQL * Loader )

ORACLE UTILITIES

ORACLE UTILITIES SQL * LOADER It is a utility to load the data from a textfile to oracle table The textfile is called as flat file. It can be in .txt, .csv, etc format SQL *LOADER contains following components CONTROL FILE – this will define the configuration parameters which tell …

Read More »

Oracle Materialized Views

Oracle dba training in hyderabad

Oracle Materialized Views It is an object used to pull remote database’s data frequently in specified time which is called as refreshing the data using materialized views Snapshot is the object which used to do the same till 8i, but the disadvantage is time constraint in pulling huge no.of rows …

Read More »

Oracle Database Links

Oracle Database Links

Database Links It is the object which will pull remote database data to local database. While creating dblink, we need to know username and password of remote database. Apart from username and password of remote db, we need to have tns entry in tnsnames.ora of local db and tnsping command …

Read More »
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe