Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Backup and Recovery Scenarios Oracle
  • CTAS with LONG Column for 9i and higher Oracle
  • Convert multiple rows to single column Oracle
  • TRUNCATE table and disabling referential constraints. Oracle
  • Running some SQL on multiple databases connecting using monitoring userid and password Linux/Unix
  • Export Oracle data and Compress at same time Oracle
  • For Perl DBI installation and testing program PHP/MYSQL/Wordpress
  • Removing Ctrl-M from end of line using vi Linux/Unix
  • tblwopk.sql /* Find Tables Without PK */ Oracle
  • get_vmstat_linux Oracle
  • Passing from Unix to PLSQL using bind variables Linux/Unix
  • find_log_switch.sql Find log switches in graphical manner Oracle
  • Composite Index creation tip from Vivek Oracle
  • This is im telling Kishore Oracle
  • move_arch_files.ksh Linux/Unix

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

  • 339939.1 Running Cluster Verification Utility to Diagnose Install Problems Oracle
  • Jai Shree Ram Oracle
  • lck.sql Oracle
  • Committing distributed transaction using commit force Oracle
  • How to set Processes Parameter Oracle
  • Index Range Scan 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 (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • 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

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Find sort details from Db find_sort.sql Oracle
  • How to find who is using which Rollback segment and how many rows or blocks in that rollback segments, Oracle
  • adding new line after specific pattern using sed Linux/Unix
  • Jai Shree Ram Oracle
  • Distributed Transaction Troubleshooting. Oracle
  • oracle tips… from http://www.bijoos.com/oracle/douknow.htm Oracle
  • Caching sequence in Memory Oracle
  • DBMS_JOB all example Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme