MyNotes

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/