2010 January | dbazone

2010 January | dbazone

Clone production database

Posted on January 19th, 2010 in Installation clone oracle database, Database cloning

Database cloning is a procedure to create an exact copy of a database. As an oracle DBA,you have to update test or development environments from production database using database cloning procedure. Following is the steps to clone oracle database. 1. Take a copy of the production database’s initialization file . 2. Take a backup of [...]

Published by Paresh Sarma // Comment now »

Recover database using Flashback Tables

Posted on January 1st, 2010 in Database backup and Recovery, database recovery scenarios Different between Flashback Table and Flashback Drop, Flashback Table, Flashback Table recovery, table point-in-time recovery using flashback table

In some scenarios, if a user accidentally deleted rows of a table and as a DBA you have to recover the table to point in time . How you can recover the rows without using more time -consuming tablespace point-in-time recovery operation? Flashback Table allows us to recover one or more tables to specific point [...]

Published by Paresh Sarma // 1 Comment »

Home

- Archives
- Categories
- Tags
- About Oracle Database (1)
- AlertLogFile (1)
- Controlling database (5)
- Create Database (2)
- create database-dbca (1)
- Create Database-manually (1)
- Creating Tables (1)
- Database architecture (4)
- Database Backup (5)
- Database backup and Recovery (9)
- Database Constraints (1)
- Database Monitoring (2)
- Database Privileges (4)
- Database processes (1)
- Database Recovery (3)
- database recovery scenarios (5)
- Database Tuning (2)
- How Oracle Executes SQL statements (1)
- Installation (2)
- Interview question for Recover database (1)
- Introduction (8)
- Logical Structure (1)
- Managing Schema Objects (4)
- Miscellaneous (7)
- Ora Error (2)
- Oracle database Datatypes (2)
- Oracle Database metadata (1)
- Oracle DBA skills (1)
- Oracle Enterprise Manager (1)
- Oracle initialization parameters (1)
- Oracle Instance (1)
- Oracle Interview questions (1)
- Oracle naming methods (1)
- Oracle Net Configuration (5)
- Oracle Net Listener Configuration (1)
- Oracle Net Services (9)
- oracle network configuration (1)
- Oracle Networking-design consideration (1)
- Oracle on Linux (7)
- oracle startup and shutdown (1)
- Oracle utilities-iSQL*Plus (1)
- Physical Structure (1)
- Recover from user errors (2)
- Responsililities of Oracle DBA (1)
- Role Privileges (1)
- Schema Object-An Introduction (1)
- Structured Query Language (1)
- System Privileges (1)
- Tools & Utilities for Oracle (2)
- Undo management (2)
- undo tablespace (2)
- user management and security (2)
About Oracle Database database character set Database Constraints database recovery Data dictionary views data types in oracle DATE data types DROP CONSTRAINT Dynamic performance views Initialization Parameters Instance failure iSQL*Plus listener.ora oracle background processes Oracle database 10G Oracle database Constraints Oracle database Data types Oracle Database metadata Oracle Database Tools Oracle Database Utilities oracle dba Oracle DBA Responsibilities Oracle DBA Role Oracle DBA Skills Oracle Enterprise Manager Oracle initialization parameters Oracle Instance Oracle listener Oracle net Oracle net Manager Oracle Network Configuration File oracle parameter file Oracle Server Process primary key primary key constraint Recover database Recovery Manager RMAN SQL*Plus SQL Functions SQL statements Structured Query Language tnsnames.ora undo tablespace UNIX commands

Latest Articles

Pages

Archives

Follow dbazonein on Twitter

Increase Google Page Rank