Amit Oracle DBA Blog

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

Showing posts with label RMAN. Show all posts
Showing posts with label RMAN. Show all posts
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, 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...
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, 25 February 2015

Recovery from complete loss of all online redo log files using RMAN

›
STEP 1: Check database details. SQL> select instance_name,version from v$instance; INSTANCE_NAME    VERSION ---------------...
Friday, 20 February 2015

Database Point-In-Time Recovery

›
  STEP 1: Note the current database clock time SQL> select to_char(sysdate,'DD-MON-YY:HH24:MI:SS') from dual; TO_CHAR...
›
Home
View web version
Powered by Blogger.