Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Oracle Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Oracle Data Guard maintains these standby databases as copies of…
Tag: Oracle Backup and Restore
Oracle 11g R2 Open Data Guard Read Write Mode With Flashback Technology And Revert Restore Point
You can use flashback technology on standby side. If you want to make application test on database, you can use data guard as read write mode temporarily with flashback technology. You can create a restore point on standby side then you can do any transaction on standby side to test or any other purpose. After…
Oracle 11g Data Guard Failover With Python Script
I wrote a python script to perform failover steps and to take product database IP addresses when product database is down. If you dont use data guard broker or other application for failover operations, you can use this script for failover. My scenario is that I have Oracle 11gR2 2 nodes RAC product database and…
Move Datafiles Of Tablespaces With RMAN Set Newname in Oracle 11g
You can move datafiles of tablespaces. Scenarios can be asm to file system or file system to file system or file system to file system or asm to asm. Below operations show how to move datafiles. You have to take a backup and database has to be archivelog mode before this operations because of that…
How to Migrate Controlfile From File System to ASM Disk in Oracle 11g
You can migrate controlfile from file system to asm disk. You have to stop database and you can do that. Stop Database SQL> shutdown immediate; SQL> startup nomount; Migrate Controlfile RMAN> restore controlfile to ‘+DATA’ from ‘/tmp/controlfile_currentlocation.ctl’; RMAN> restore controlfile to ‘+FRA’ from ‘/tmp/controlfile_currentlocation.ctl’;
RMAN Encrypt Backup in Oracle
You can protect your backups with rman encryption. You have three ways to rman backup encryption. You can use wallet, password or dual mode. I will tell you password protection. Configure RMAN Backups With Password Protection rman target / RMAN> set encryption on identified by ‘yourpassword’ only; You can backup with backup database command. Do…
How to Move Datafile to Different Directory in Oracle
You can move datafiles to different directory. You have to make offline tablespace or take mount mode database to change datafiles location. System, temporary and rollback tablespace can move only when database is mount mode. Show Tablespaces And Datafiles With Locations SQL> select tablespace_name, file_name from dba_data_files; Change Location Of Normal Datafile SQL> alter tablespace…
How to Drop Oracle Database With RMAN
You can run the following commands to delete the target database files, as well as all backups, copies, and archived logs associated with the database. Drop Oracle Database oracle@oratest~ ]$ rman target / Note : If database is not started, you have to start database with mount mode. If database is started, you have to…
Restore And Recover Oracle 11g R2 Database on Windows 2008 R2 Server
You can restore and recover Oracle 11g R2 Database from RMAN backup on Windows 2008 R2 Server with below operations. You have to execute Command Prompt as Administrator for all operations. Restore and Recover Database Install Oracle software Install Patch Create ORACLE_HOME and ORACLE_SID in Server Environment Path. Copy backup files to C:\orabackup Create Oracle…
Oracle Flashback Technology
When authorized people make mistakes, you need the tools to correct these errors. Oracle Database provides a family of human error correction technology called Flashback. Flashback revolutionizes data recovery. In the past, it might take minutes to damage a database but hours to recover it. With Flashback technology, the time to correct errors equals the…