Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • How to find the real execution plan and binds used in that explain plan in Oracle 10g?? Oracle
  • Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
  • grep multuple patterns Linux/Unix
  • How to find who is using which Rollback segment and how many rows or blocks in that rollback segments, Oracle
  • Logic to chech # of parameters command line parameters Linux/Unix
  • Vivek Tuning for Row Locks. Oracle
  • How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven) Oracle
  • How to find where datafile is created dbf_info.sql Oracle
  • DBA_HIST_SQLSTAT contents Oracle
  • Sending SQLPLUS output in HTML format Oracle
  • Specify the Rollback segment to use in Transaction Oracle
  • Free conference number from http://www.freeconference.com Oracle
  • Important Solaris Commands Linux/Unix
  • Validating ORACLE_SID againt oratab file. Linux/Unix
  • Giving Grant on v$DATABASE Oracle

Rman Notes -1

Posted on 12-May-2008 By Admin No Comments on 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 not force you to use it to store

all recovery-related files.

Backups moved to tape from the flash recovery area (via RMAN and media manager) are retained on disk until space

is needed for other required files, reducing the need to restore backups from tape. At the same time, obsolete

files no longer needed to meet your recoverability goals and files backed up to tape become eligible for deletion

and are deleted when space is needed. These deletions are managed by Oracle when space is required. The DBA no longer

has to manually delete old backups, and, it is less likely that a DBA accidentally deletes redundancy set files.

Note that if backups written to the FRA are not copied via RMAN and media manager to tape, the automatic deletion

of obsolete backups does not occur and pre-Oracle10g cleanup methods are required.

Oracle, rman-dataguard

Post navigation

Previous Post: find_log_switch.sql Find log switches in graphical manner
Next Post: V$ROLLSTAT status is Full

Related Posts

  • configUOCIOTTO.ora Oracle
  • Rename Tablespace Oracle
  • ORA-8031 issue and solution if it is occuring due to truncate. Oracle
  • Oracle10g – Using SQLAccess Advisor (DBMS_ADVISOR) with the Automatic Workload Repository Oracle
  • Changing unix system clock when Oracle database is running. Oracle
  • Finding Oracle Patches with opatch Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Convert multiple rows to single column Oracle
  • Linux CPU info. Linux/Unix
  • create database syntax Oracle
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
  • TRUNCATE table and disabling referential constraints. Oracle
  • Good link for LIO in Oracle ( Logical IOs) Oracle
  • pvmehta.com SQL scripts
    Find which sessions is accessing object that prevent your session to have exclusive locks in Oracle Oracle
  • AWR settings- MMON is not taking snapshot. Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme