MyNotes

Let us we discuss To recovery the database using Rman Datafiles,controlfiles and parameter files, How to  loss all files (control,data and parameter files)  and recover using Rman? Requirements Backup type - Full Backup Loss -  All the Parameter ,Controlfiles, and Data files including system and sysaux For more details click here http://ampersandacademy.com/tutorials/rman-recovery-for-parameterfile-controlfile-datafile/

Let we discuss Database Migration From Windows to Linux in Oracle11g platform, Here we 'll see step by step For More details Click here http://ampersandacademy.com/tutorials/migration-oracle-database-windows-linux-oracle11g/

Let us we discuss a topic flashback technology – flashback database in oracle11g in that flashback database, we had 3 methodologies 1)restore point 2)using  SCN 3)using Timestamp Here we can see how to Flashback the database using SCN ? For More Details Click Here http://ampersandacademy.com/tutorials/flashback-technology-flashback-database-using-scn-oracle11g/

Let us we discuss Flashback technology  Types "Flashback Table" and "Flashback drop" what is flashback table?   - Flashback table concept is to recover your drop table .it was introduced on oracle 10g    -If user drop the table accidentally we can recover the table using flashback command  i.e its recover from recycle bin not depends on undo tablespace or undo_retention For more details Click Here     http://ampersandacademy.com/tutorials/flashback-technology-flashback-table-oracle-11g/

Let us we discuss about Flashback technology one of the types "Flashback version query " and "Flashback Transaction query" what is flashback version query ?     -flashback version query is allows the versions of a specific row to be tracked during a specified time period using the VERSIONS BETWEEN clause For More details Click here   http://ampersandacademy.com/tutorials/flashback-technology-flashback-version-query-oracle-11g/

Let us we discuss Flashback Technology or Concept and their  types in Oracle11g 1) what is Flashback Technology ? -Flashback  technology / query feature  was introduced from oracle 9i onwards from  Oracle 10g has taken this technology a step further making it simpler to use and much more flexible -It is used to recover our database from accidental statement failures like suppose delete the row from table or drop table or wrongly inserted new  rows and gives  commits it also then, using flash back query can get 2)What are types of Flashback Technology?  There are 6  Types of Flashback Technology -Flashback Query -Flashback Version Query -Flashback Transaction Query -Flashback Table.... Click here http://ampersandacademy.com/tutorials/flashback-technology-flashback-query-in-oracle-11g/

In previous blog we discuss about backup and  recovery now we are going to see Types of Backup and recovery What are the types of backup and recovery? 1)Uman Backup 2)Rman Backup Now we are going to see by using Uman how to take cold or consistent or Offline backup and Hot or online or  inconsistent backup For more details Click Here     http://ampersandacademy.com/tutorials/backup-recovery-uman-online-offline-backup/

Let us we discuss Backup and Recovery in oracle11g what is backup and recovery in oracle? – Backup and recovery is to protect  the database against data loss and reconstruct the database after data loss. – Backup has been splitted   into two  methods *Physical backup *Logical backup for  more details click here  http://ampersandacademy.com/tutorials/backup-recovery/

 most of the times we wrongly created the database to avoid this confusion we just rename the database here i 'm showing  how to change the oracle database name using DBNEWID utility? Click Here http://ampersandacademy.com/tutorials/oracle-database-name-changing-oracle11g/

Let us discuss "Rman Parameter  configuration Part 1in oracle11g" this are basic steps before we take backup click here   http://ampersandacademy.com/tutorials/rman-parameter-configuration/

Let us discuss Rman introduction in oracle 11g, Rman is nothing but Recovery Manager . it’s an automated tool of oracle backup and recovery Click here https://ampersandacademy.com/tutorials/oracle-admin-2/rman-introduction-oracle-11g

Let us discuss "Tnsname.ora" Configuration in Oracle11g Why we need Tnsname.ora file? How to configure this file? What is the use ? click here http://ampersandacademy.com/tutorials/tnsname-configuration-oracle-11g/

Let us we discuss  Spfile or Pfile recovery technique without using rman or any backup click the link below http://ampersandacademy.com/tutorials/spfile-pfile-recovery-without-rman-backup/

Let us see today what is the difference between sga_max_size & sga_target ? or what is the difference between memory_target & memory_max_target?  click here   http://ampersandacademy.com/tutorials/sga_target-and-sga_max_size-memory_taregt-and-memory_max_target-in-oracle-11g/

Let us see the session about how to  configure the listener in oracle11g? click here http://ampersandacademy.com/tutorials/listener-configuration-oracle11g/

Let us we discuss Flashback technology and their types in oracle11g click here http://ampersandacademy.com/tutorials/flashback-technology-flashback-query-in-oracle-11g/

Let  us see we discuss logical backup methodologies datapump - export utilities  in oracle 11g click here  http://ampersandacademy.com/tutorials/datapump-export-expdp-oracle-11g/

Let  us see we discuss logical backup methodologies datapump - import utilities  in oracle 11g click here http://ampersandacademy.com/tutorials/datapump-impdp-in-oracle-11g/

Let  us see we discuss managing privileges at user management concept in oracle 11g click here  http://ampersandacademy.com/tutorials/user-management-managing-privileges-oracle-11g/

Let  us see we discuss managing roles at user management concept in oracle 11g click here http://ampersandacademy.com/tutorials/user-management-managing-roles-oracle-11g/

Let  us see we discuss flashback table and fashback drop  in flashback technology  concept of oracle 11g http://ampersandacademy.com/tutorials/flashback-technology-flashback-table-oracle-11g/

Let  us see we discuss flashback version query & Flashback transaction query in flashback technology  concept of oracle 11g click here http://ampersandacademy.com/tutorials/flashback-technology-flashback-version-query-oracle-11g/

Let us we discuss about what is tablespace? what is datafile? how can we manage it click the link below https://ampersandacademy.com/tutorials/oracle-admin-1/managing-tablespaces-datafiles-oracle-11g

Let us  we see about managing profiles in user management in oracle 11g for details http://ampersandacademy.com/tutorials/user-management-managing-profiles-oracle-11g-part-3/

Let we discuss about what  is segments ?  how the segment space can be managed in tablespace in manual  and auto methods ? click the link  below  http://ampersandacademy.com/tutorials/automatic-space-segment-management-oracle-11g/

Let us we discuss about  what is performance tuning ? types of performance tuning,diagnostic tools,methodology click  the link below http://ampersandacademy.com/tutorials/performance-tunning-oracle-11g-part-1/

Let us we discuss about undo tablespace management click the link below http://ampersandacademy.com/tutorials/undo-management-undo-tablespace-oracle-11g/

Let us we discuss  about how to we relocate tablespace in offline method click  the link belwo http://ampersandacademy.com/tutorials/relocating-tablespace-offline-oralce-11g/

Let us how to  relocate tablespace file while database is running up? check the below link http://ampersandacademy.com/tutorials/relocating-tablespace-online-oracle-11g/

Today we discuss about how to configure Ip address between two servers? click the link below http://ampersandacademy.com/tutorials/networking-oracle-11g/

Today  we discuss about what is  user management ? What is user management? User management is to create and manage login credentials for each user. we can also limit their access functionality Types of user management 1)Managing Users 2)Managing Privileges 3)Managing Roles 4)Managing Profiles Let us see  Managing Users click the below link   http://ampersandacademy.com/tutorials/user-management-manage-user-oracle-11g-part-1/

Lee us see how to delete the database using DBCA tools? check the below link http://ampersandacademy.com/tutorials/delete-database-using-dbca/

Today we can see how to create database in manual method in oracle 11g click below http://ampersandacademy.com/tutorials/manual-database-creation-oracle-11g/

Let us we discuss about  how to install oracle linux 5.5 installation on Vmware for beginners check the link below http://ampersandacademy.com/tutorials/oracle-linux-installation-in-vmware/

Simple Methods to create Database using DBCA tools http://ampersandacademy.com/tutorials/database-creation-using-dbca-tool-oracle-11g/

Let us  we discuss about oracle 11g software installation in linux environment using  vmware press the link below  http://ampersandacademy.com/tutorials/oracle-11g-installation-linux/