This is from Temi
Hello Buddy
Category: rman-dataguard
Rman Notes -1
############## RMAN CATALOG ############## The recovery catalog contains information about RMAN operations, including: + Datafile and archived redo log backup sets and backup pieces + Datafile copies + Archived redo logs and their copies + Tablespaces and datafiles on the target database + Stored scripts, which are named user-created sequences of RMAN commands + Persistent…
Rman Notes -1
#—-Flash Recovery Area (FRA)——#
Rman Notes -1
A flash recovery area is a disk location in which the database can store and manage files related to backup and recovery. Some features of Oracle database backup and recovery, such as Oracle Flashback Database and guaranteed restore points, require the use of an FRA. However, having an FRA for use by these features does…
Flowers Resize datafiles
In flowers we resize datafile using following command: alter database resize datafile ‘/path1/filename.dbf’ resize 500M; this will change that datafles ‘SIZE’ column and allocate that much space for that datafile. If you are having standby database pls make sure that enough space is available for that file expansion.
To check whether standby is recovering properly or not??
– Check Alert.log of standby server.
Adding or Dropping Online Redo Log Files When Physical Standby in place
Changing the size and number of the online redo log files is sometimes done to tune the database. You can add online redo log file groups or members to the primary database without affecting the standby database. Similarly, you can drop log file groups or members from the primary database without affecting your standby database….
Read More “Adding or Dropping Online Redo Log Files When Physical Standby in place” »
Example of How To Resize the Online Redo Logfiles Note:1035935.6
EXAMPLE OF HOW TO RESIZE THE ONLINE REDO LOGS: ============================================== Often times the online redo logs are sized too small causing database performance problems. The following is an example of how to resize the online log groups: 1. First see the size of the current logs: SVRMGR> connect internal (with 9i/10g use SQL> connect /…
Read More “Example of How To Resize the Online Redo Logfiles Note:1035935.6” »
Standby Database Behavior when a Datafile is Resized on the Primary Database Note:123883.1
Purpose: ======== The purpose of this article is to describe the behavior of the standby database when one or more datafiles on the primary database are resized. Standby Database Behavior When a Datafile is Resized on the Primary Database: ============================================================================= On the primary database the initial size of the datafile is 113246208. You decide to…
Resolving RMAN Hung Jobs
PURPOSE ======= This note discusses resolving an RMAN Hung Job SCOPE & APPLICATION =================== Anyone involved in running RMAN jobs Resolving an RMAN Hung Job ========================== Components of an RMAN Session The nature of an RMAN session depends on the operating system. In UNIX, an RMAN session has the following processes associated with it: –…