Hello, everyone!
Today I will make a brief post about flashback data archive.
Flashback data archives it is like a repository composty by one or more areas, one of which can be the default, assign a default retention period for objects in the repository, and then mark the appropriate tables for tracking. Continue reading
Hello folks.
In many cases you probably need to restore a database to a point in the past.
Errors that won’t be reversed only with a flashback table or perhaps you do not have
the flashback feature configured for the database.
You can use restore point with a specific time in the past or using the SCN number.
To capture the SCN of the database you can the query below:
Hello, everyone!
Today, I will talk about a little of image copies. An image copy is an exact copy of a tablespace’s datafile, an archive redo log file or a control file.
This type of backup can be written only to disk. In case of recovery the time from restoration is less because the file is already on disk.
An image copy can be used like a full backup or a backup level 0, all used and an unused blocks are taken during this type of backup operation.
Also the command SWITCH will be used to perform fast recovery operation.
Let’s stat Continue reading
Hello folks,
Today I will show you how to create a recovery catalog. If you have more than one databases to manage, you want to keep the backup information of your databases for a long time the recovery catalog might be justified. You can register an unlimited numbers of databases into the recovery catalog.
Connect to SQLPLUS with SYSDBA:
Hello everyone, Welcome! I am starting my blog, here I will post some tips about Oracle Databases. I work with Oracle Databases since version 10g, I am a Oracle Certified Professional 11g. I work as an Oracle DBA about 6 years, during all this time I have work with a lot of types of Oracle Databases. I hope that you enjoy the tips that I will post here. Thank you!
Emiliano Fusaglia RAC DBA/Data Architect
Oracle: "eine unendliche Geschichte" / "the never-ending story"
so they say :)
Sharing free tools and ideas with the Oracle community
never stop learning because life never stops teaching
Knowledge is only valuable if shared!
Heli's thoughts on Database Designing, Oracle SQL Developer Data Modeler, User Groups etc.
Yury's blog
Sharing stuff (by Bertrand Drouvot)
Dominic Brooks on Oracle Performance, Tuning, Data Quality & Sensible Design ... (Now with added Sets Appeal)
Oracle performance, Oracle statistics and VLDBs
Platform, Database and Storage Topics
Ready-to-use virtual machines for open-source operating systems
Database performance in the cloud
Rick Miners
IT Technology; Oracle, linux, TCP/IP and other stuff I find interesting
Tools and Tips for Oracle Performance and SQL Tuning
Trying to explain complex things in simple terms
The good DBA is one who learns from his mistakes, the best DBA is one who learns from other DBA's mistakes
about Database Technology
...discussing the evolution of databases
Just another Oracle weblog
Oracle Tips, Tricks and Information
