Pages

▼
Showing posts with label RMAN. Show all posts
Showing posts with label RMAN. Show all posts
Thursday, 23 November 2017

Time Based Archivelog Backup in Oracle 11gR2 RMAN

›
Scenario: Sometimes we need to take archive log backup for specific time, so we can use the following steps for this purpose Solution: ...
1 comment:
Sunday, 2 April 2017

RMAN Active Duplicate on RAC fails with ORA-17629 and ORA-17627: ORA-12154

›
RMAN active duplication of RAC database fails on restart operation with the following error messages: oracle@said$ rman target sys@orcl ...
1 comment:
Monday, 2 February 2015

ora-01547 ora-01152 ora-01110 ---ORA-01152: file 1 was not restored from a sufficiently old backup

›
ORA-01152: file 1 was not restored from a sufficiently old backup RMAN> recover database; starting media recovery Oracle Error...
1 comment:
Monday, 29 December 2014

Step by Step Duplicate a Database Using RMAN in Oracle Database 11g Release 2

›
Step 1: start Database in nomount mode using parameter file SQL>startup nomount pfile='/tmp/stldb.ora'; Step 2: Restore cont...
1 comment:
Tuesday, 8 April 2014

Restore Controlfile to specific location using RMAN

›
Restore Controlfile to specific location using RMAN 1. Restore controlfile to a location RMAN> restore controlfile to '/u01/ap...
1 comment:
Wednesday, 2 April 2014

ORA-00349 ORA-27041 Linux-x86_64 Error: 2: No such file or directory

›
Scenario : We want to restore Oracle 11g RMAN backup into different host with different mount point.We have restore database and recover ...
1 comment:
Tuesday, 4 February 2014

Restore and Recover with latest controlfile backup but Database/Archivelog backup five days earlier

›
Problem: Here we have five days earlier Database/Archivelog backup without control controlfile but we have last night controlfile backup,no...
1 comment:
Wednesday, 22 January 2014

RMAN-06059: expected archived log not found, lost of archived log compromises recoverability

›
Error:   RMAN-03002: failure of backup command at 01/13/2014 07:02:54 RMAN-06059: expected archived log not found, lost of archived log c...
1 comment:
Sunday, 24 November 2013

Backup Archivelog to specific location using RMAN

›
Goal: Following script will take archive log backup in a specific location using RMAN run { allocate channel ch1 type disk format ...
1 comment:

RMAN backup (Control File, Data File) to specific location

›
Goal: Following script will use to take RMAN backup in a specific location run{ backup current controlfile format 'D:\RMAN\full_%s...
Saturday, 23 November 2013

12 steps to build report server like production using RMAN (Oracle) backup in Windows

›
Goal: The following procedure will be used to build a report server as like production    1. Create a service  oradim -new -sid itbl ...
1 comment:

Recover when one or all control files deleted in Oracle

›
RMAN> RESTORE CONTROLFILE from 'F:\oracle\product\10.2.0\Backup\Controlfile\CF_C-1331185808-20130207-01'; Starting restore at 07...
1 comment:

Cataloging backup piece in RMAN

›
Applies to:   Oracle Server – Enterprise Edition any Version  9 to 12 Information in this document applies to any platform. Goal: ...
1 comment:

Configure RMAN to purge archivelogs after applied on standby

›
Applicable: Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.5 GOAL: We need RMAN to automatically purge archivelogs from ...
1 comment:
Saturday, 21 September 2013

Maintenance of archivelogs which are already applied on standby database in Oracle 10g

›
Maintenance Of Archivelogs On Standby Databases Applies to: Oracle Server – Enterprise Edition – Version: 10.1.0.0 to 11.1 Inform...
1 comment:

Error RMAN-06023 but there are backups available

›
Error RMAN-06023 but there are backups available Demo case: Environment : Oracle 10.2.0.1 on Linux 64bit I have backup files of the...
1 comment: