Difference Between OBSOLETE AND EXPIRED Backup
RMAN considers backups of datafiles and control files as obsolete, that is, no longer needed for recovery, according to criteria that we specify in the CONFIGURE command. We can then use the REPORT OBSOLETE command to view obsolete files and DELETE OBSOLETE to delete them .
For ex : we set our retention policy to redundancy 2. this means we always want to keep at least 2 backup, after 2 backup, if we take an another backup oldest one become obsolete because there is 3 backup and we want to keep 2. if our flash recovery area is full then obsolete backups can be overwrite.
A status of "expired" means that the backup piece or backup set is not found in the backup destination or missing .Since backup info is hold in our controlfile and catalog . Our controlfile thinks that there is a backup under a directory with a name but someone delete this file from operating system. We can run crosscheck command to check if these files are exist and if rman found a file is missing then mark that backup record as expired which means is no more exists.
One Can Succeed at Almost Anything For Which He Has Enthusiasm...
RMAN crosscheck command compares the RMAN catalog entries or controlfiles with the actual OS files and reports to locate "expired" or "obsolete" RMAN catalog entries.
CATALOG.SQL - Creates the views of the data dictionary tables, the dynamic performance views, and public synonyms for many of the views. Grants PUBLIC access to the synonyms.
CATPROC.SQL - catproc.sql creates all structures required for PL/SQL.
One Can Succeed at Almost Anything For Which He Has Enthusiasm...
RMAN crosscheck command compares the RMAN catalog entries or controlfiles with the actual OS files and reports to locate "expired" or "obsolete" RMAN catalog entries.
CATALOG.SQL - Creates the views of the data dictionary tables, the dynamic performance views, and public synonyms for many of the views. Grants PUBLIC access to the synonyms.
CATPROC.SQL - catproc.sql creates all structures required for PL/SQL.
Backup details
V$RMAN_BACKUP_JOB_DETAILS , V$BACKUP_SET_DETAILS , V$BACKUP_SET
what is cache fusion ?
Cache Fusion is a new technology that uses a high speed interprocess communication (IPC) interconnect
that provides copies of blocks directly from the holding instance's memory cache to the requesting instance's memory cache
cache coherency or cache consistency
The synchronization of data in multiple caches so that reading a memory location through any cache will return the most recent data .Sometimes also called cache consistency.
Cache Fusion addresses these types of concurrency between instances,
•Concurrent Reads on Multiple Nodes
•Concurrent Reads and Writes on Different Nodes
•Concurrent Writes on Different Nodes
high water mark
The high water mark is the boundary between used and unused space in a segment.
password file
A file created by the ORAPWD command. A database must use password files if you want to connect as SYSDBA over a network.
past image (PI)
A past image is a copy of dirty block that is used by the Global Cache Service (GCS). Past images of blocks are maintained until writes covering those versions are recorded. Past images are used in failure recovery.
PCTFREE
A storage parameter file that defines the percentage of space to leave in an extent.
The database stores undo data in undo extents, and there are three distinct types of undo extents:
Active: Transactions are currently using these extents.
Unexpired: These are extents that contain undo that's required to satisfy the undo retention time specified by the UNDO_RETENTION initialization parameter.
Expired: These are extents with undo that's been retained longer than the duration specified by the UNDO_RETENTION parameter.
Concurrent Reads on Multiple Nodes :
Concurrent reads occur when two instances need to read the same data block. Real Application Clusters easily resolves this situation because multiple instances
can share the same blocks for read access without cache coherency conflicts.
Concurrent Reads and Writes on Different Nodes
A read of a data block that was recently modified can be either for the current version of the block or for a read-consistent previous version.
In both cases, the block will be transferred from one cache to the other.
Enthusiasm : Zeal , passion , interest ,intense , eager.
One Can Succeed at Almost Anything For Which He Has Enthusiasm .
dba_advisor_findings af, dba_advisor_objects ao, dba_advisor_log al
select * from PSAPMSGPUBHDR;
Rakesh, setup conf call with myself only as these are end user questions which with my help you should be able to answer.
setup a call only with me...(there is some difference using "with me" and "with myself")
set define off if prompt should not trigger for input values
if you are installing sofware then definately you need ram , disk space to store softwares , temp and swap required for every software , it's not standalone its cluster
database so network required, now-a-days Oracle using it's own filesystem ASM which requires shared storage space.
Oracle critical files are there O
One Can Succeed at Almost Anything For Which He Has Enthusiasm...
RMAN crosscheck command compares the RMAN catalog entries or controlfiles with the actual OS files and reports to locate "expired" or "obsolete" RMAN catalog entries.
CATALOG.SQL - Creates the views of the data dictionary tables, the dynamic performance views, and public synonyms for many of the views. Grants PUBLIC access to the synonyms.
CATPROC.SQL - catproc.sql creates all structures required for PL/SQL.
One Can Succeed at Almost Anything For Which He Has Enthusiasm...
RMAN crosscheck command compares the RMAN catalog entries or controlfiles with the actual OS files and reports to locate "expired" or "obsolete" RMAN catalog entries.
CATALOG.SQL - Creates the views of the data dictionary tables, the dynamic performance views, and public synonyms for many of the views. Grants PUBLIC access to the synonyms.
CATPROC.SQL - catproc.sql creates all structures required for PL/SQL.
Backup details
V$RMAN_BACKUP_JOB_DETAILS , V$BACKUP_SET_DETAILS , V$BACKUP_SET
what is cache fusion ?
Cache Fusion is a new technology that uses a high speed interprocess communication (IPC) interconnect
that provides copies of blocks directly from the holding instance's memory cache to the requesting instance's memory cache
cache coherency or cache consistency
The synchronization of data in multiple caches so that reading a memory location through any cache will return the most recent data .Sometimes also called cache consistency.
Cache Fusion addresses these types of concurrency between instances,
•Concurrent Reads on Multiple Nodes
•Concurrent Reads and Writes on Different Nodes
•Concurrent Writes on Different Nodes
high water mark
The high water mark is the boundary between used and unused space in a segment.
password file
A file created by the ORAPWD command. A database must use password files if you want to connect as SYSDBA over a network.
past image (PI)
A past image is a copy of dirty block that is used by the Global Cache Service (GCS). Past images of blocks are maintained until writes covering those versions are recorded. Past images are used in failure recovery.
PCTFREE
A storage parameter file that defines the percentage of space to leave in an extent.
The database stores undo data in undo extents, and there are three distinct types of undo extents:
Active: Transactions are currently using these extents.
Unexpired: These are extents that contain undo that's required to satisfy the undo retention time specified by the UNDO_RETENTION initialization parameter.
Expired: These are extents with undo that's been retained longer than the duration specified by the UNDO_RETENTION parameter.
Concurrent Reads on Multiple Nodes :
Concurrent reads occur when two instances need to read the same data block. Real Application Clusters easily resolves this situation because multiple instances
can share the same blocks for read access without cache coherency conflicts.
Concurrent Reads and Writes on Different Nodes
A read of a data block that was recently modified can be either for the current version of the block or for a read-consistent previous version.
In both cases, the block will be transferred from one cache to the other.
Enthusiasm : Zeal , passion , interest ,intense , eager.
One Can Succeed at Almost Anything For Which He Has Enthusiasm .
dba_advisor_findings af, dba_advisor_objects ao, dba_advisor_log al
select * from PSAPMSGPUBHDR;
Rakesh, setup conf call with myself only as these are end user questions which with my help you should be able to answer.
setup a call only with me...(there is some difference using "with me" and "with myself")
set define off if prompt should not trigger for input values
if you are installing sofware then definately you need ram , disk space to store softwares , temp and swap required for every software , it's not standalone its cluster
database so network required, now-a-days Oracle using it's own filesystem ASM which requires shared storage space.
Oracle critical files are there O
No comments:
Post a Comment