Scenerio: After restring and recovering database got ORA-01152 while opening the database with resetlogs. Backup was taken without taking the archive logs. Perform the following:
Tuesday, February 26, 2013
Monday, February 25, 2013
RMAN: Taking Cold backup using RMAN and restore it
Cold backup is particular useful when you plan to test some changes on the database and in case something goes wrong you can always fall back to this Cold backup.
Cold backup is a consistent backup when the database has been shutdown immediate or Shutdown Normal.If the database is shutdown with abort option then its not a consistent backup.
Cold backup can be taken by RMAN in mount stage after database has been shutdown immediate.RMAN: Recovery of missing datafile that is never backed up
Environment:
Oracle Database 11gR2 on Windows 7
DB in archivelog mode
Example:
Assuming that already a tablespace "TS1" is existing with one datafile, if not you can use the statements below.
create tablespace ts1 datafile 'C:\app\Inam\oradata\orcl\ts01.dbf' size 10m reuse;
Sunday, February 24, 2013
Using Transportable Tablespaces
Oracle transportable tablespaces are the fastest way for moving large volumes of data between two Oracle databases. Using transportable tablespaces, Oracle data files (containing table data, indexes, and almost every other Oracle database object) can be directly transported from one database to another. Furthermore, like import and export, transportable tablespaces provide a mechanism for transporting metadata in addition to transporting data.
RMAN: Recover A Dropped Tablespace Using TSPITR (11gR2)
RMAN automatic Tablespace Point-In-Time Recovery ( TSPITR) enables you to quickly recover one or more tablespaces in an Oracle database to an earlier time, without affecting the state of the rest of the tablespaces and other objects in the database.
Saturday, February 23, 2013
ORA-00245 control file backup failed
Environment: Two node Oracle RAC 11gR2 on Windows 2008R2
Symptoms
RMAN backups report errors like :ORA-00245: control file backup operation failed
Wednesday, February 20, 2013
ORA-12528: TNS: listener: all appropriate instances are blocking new connections
Cause: All instances supporting the service requested by the client reported that they were blocking the new connections. This condition may be temporary, such as at instance startup.
Monday, February 18, 2013
Installing 11gR2 RAC on Solaris
Environment: OS Sun Solaris 10 update 10 x86 64bit on OVM, Oracle 11gR2 (11.2.0.1) 64bit
See the overview Note:
Read the overview above for Grid infrastructure concepts. As overview is related to Windows OS, difference is given below with respect to Solaris.
ADVM (ASM dynamic volume manager) and ACFS (ASM cluster file system) are currently not available forSolaris.
See the overview Note:
Read the overview above for Grid infrastructure concepts. As overview is related to Windows OS, difference is given below with respect to Solaris.
ADVM (ASM dynamic volume manager) and ACFS (ASM cluster file system) are currently not available forSolaris.
11gR2 on Solaris: RDBMS Software Install
Log out from "grid" user and enter as "oracle" and run installer
11gR2 on Solaris: Prepare the shared storage/Prereq
After installing the basic installation of Solaris there are certain requirements which need to be fulfilled for successful installation of RAC 11g.
11gR2 on Solaris: Installing/configuring vboxguestAddition tool
After installing the OS, you can install the "VBoxGuestAdditions" to get the additional benefits from Oracle Virtual Machine like resolution/full screen capabilities etc. VBoxGuestAdditions' .iso image is found in the installation folder of OVM eg; C:\Program Files\Oracle\VirtualBox.
11gR2 on Solaris: Installing OS (Solaris)
You can get the Solaris media from edelivery. After getting the media attach the .iso image as CDROM to OVM and start the virtual machine. Installation wizard will be started. Here are the images for your reference.
Subscribe to:
Posts (Atom)