Amit Oracle DBA Blog

This blog is to share oracle concept and real time experience for Oracle beginner.....

Thursday, 23 July 2015

How to catalog backups / archivelogs / datafile copies / control file copies

›
RMAN Catalog: It is mainly used for following: Can store database backup scripts and backup information to safe place(RMAN Repositor...
Wednesday, 15 July 2015

Oracle Baseline/ SQL plan migration to its DEV/QA/Clone

›
In this article I have explained step by step how to copy/migrate SQL baseline from source database to target database. On Source data...
Thursday, 11 June 2015

Steps To Migrate a Database from Non-ASM to ASM

›
You can use these steps to migrate a NON-ASM database to ASM database in Oracle 11gR2. Prerequisite - ASM instance should be created a...
Monday, 1 June 2015

Recovery of database using RMAN backup when system datafile is lost

›
DB Name:  TESTDB [oracle@test dbf]$   ls redo01.log  redo02.log  redo03.log  sysaux01.dbf  system01.dbf  temp01.dbf  undotbs01.dbf...
1 comment:
Tuesday, 26 May 2015

Obtaining Execution Plan in Oracle

›
Obtaining Execution Plan in Oracle What is execution plan? An execution plan describes the list of operations which are performed by...
‹
›
Home
View web version
Powered by Blogger.