Oracle DBA | How to Use Of Flashback | Flashback | DBA2-10
To See More DBA part-01 Tutorial Click here • Oracle DBA (Part-01) Tutorial For Beginners
To See More DBA part-02 Tutorial Click here • Oracle DBA (Part-2) Tutorial For Beginners
To See More Reports Tutorial Click here • Introduction To Database & Out Line The Se...
To See More Forms Tutorial Click here • Oracle Forms: How to Install Oracle Databa...
Dear viewer, In this tutorial you will learn use of flashback and you also recover your lose data by using flashback.
Step1:
Must be confirm archivelog on Command-
sq-alter database archivelog;
Step2: Flashback Open:
Go Mount command-
SQL-shutdown immediate
SQL-startup mount
sql-alter database flashback on;
Step3: Open Database:
Command-
sql-alter database open;
Step4: Change in your schema. such as drop table
Step5: Flashback Database to Timestamp:
Go Mount command-
SQL-shutdown immediate
SQL-startup mount
sql- flashback database to timestamp to_timestamp('04-jul-16 05:59:00 pm','dd-mon-rr hh:mi:ss am');
Step6: Open Database:Command-
sql-alter database open resetlogs;
To Get more Tutorial Subscribe The Channel
click here / @oracledbsolutions2678
To Get All Post Like The Facebook Page
Click here / oracledbsolutions
Follow us:
Facebook: / oracledbsolutions
Youtube link: / @oracledbsolutions2678
Facebook Group: / 465557066961548
Contact us:
email: [email protected]
Skype: oracle26solutions
Mob: 01734557080, 01627422780