Amit Oracle DBA Blog
This blog is to share oracle concept and real time experience for Oracle beginner.....
Wednesday, 25 November 2015
Recovery scenarios involving loss of SPFILE
›
In this session we will see how to recover spfile from rman backup. Considering we have RMAN backup available that has a copy of the s...
3 comments:
Friday, 20 November 2015
Installing Oracle Multimedia Component on 11g
›
Installing Oracle Multimedia, which is required for Spatial and/or Locator is quite simple. All of the following must be carried o...
1 comment:
Friday, 23 October 2015
How to find the last RMAN backup’s log?
›
set pagesize 2000 set linesize 2000 select output from GV$RMAN_OUTPUT where session_recid = ( select session_reci...
Wednesday, 14 October 2015
oracle script to check the database growth
›
SET LINESIZE 200 SET PAGESIZE 200 COL "Database Size" FORMAT a13 COL "Used Space" FORMAT a11 COL "Used in...
20 comments:
Sunday, 4 October 2015
SHUTDOWN: waiting for active calls to complete.
›
Issue: Active call for process 1993 user ‘oraprod’ program ‘ oracleprod@prod ’ Active call for process 18672 user ‘oraprod’ program ‘o...
Wednesday, 30 September 2015
Move a datafile with RMAN
›
Using RMAN is the best way before 12c to relocate a datafile with a minimum downtime. The only downtime is for switching from the old data...
‹
›
Home
View web version
