Add Site or Add Page to Favorites
>   Computers > Databases > Oracle >

 RMAN 
 
Design Tuning Apache Derby IBM DB2 MySQL Oracle SQL Server
rman1b

Preview DRM-free music
Play clips of the most popular DRM-Free music in MP3 format
Legal Music .com

Get information on your favorite TV Shows at TV Series .com

Clarify the meaning of the acronyms on your web site.

Acronym Dictionary

Acronym Finder

Social Networking Web Sites

Register your own domain name at A to Z Domains.

or buy domains at Domain Names For Sale .net

Printer-friendly PDF* format:

RMAN

This Section

Recovery Manager (RMAN)

How to connect to an RMAN Catalog

export ORACLE_SID=targetsvc​
rman target / catalog username/password@catsvc​

export ORACLE_SID=catsvc​
rman target username/password@targetsvc catalog username/password​

targetsvc is the service name of the target database. catsvc is the service name for the database where the RMAN catalog resides.

list backup of database archivelog all;

RMAN-06059: expected archive log not found

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /archlogpath/archsid_nnnn.arc
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory

Compare archive logs in RMAN to ones on disk

list archivelog all;
list archivelog like '/archlogpath/archsid_n%.arc';
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
nnnnnn 1 nnnn A dd-MON-yy /archlogpath/archsid_nnnn.arc
...
host 'ls -l /archlogpath';

Delete all missing archive logs

DO NOT do crosscheck archivelog all with tape backups or archived logs, only disk backups or logs, where RMAN can successfully verify the existence of the files. Otherwise all backups or archived logs will become EXPIRED.

list expired archivelog all;
specification does not match any archive log in the recovery catalog

crosscheck archivelog like '/archlogpath/archsid_n%.arc';
crosscheck archivelog all;

list expired archivelog all;
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
nnnnnn 1 nnnn X dd-MON-yy /archlogpath/archsid_nnnn.arc
...

delete expired archivelog all;
Do you really want to delete the above objects (enter YES or NO)?

back to top

Last updated Tuesday April 24, 2007

You are currently viewing this page in HTML 5 XML* format (* see Clicklets for more infomation). This document is also available in XML* HTML 5 non-XML*XHTML 1 Style Sheet*HTML 5 Style Sheet* XHTML 1* HTML 4* XHTML 2* XHTML Mobile* WML Mobile* and printer-friendly PDF* formats. This is accomplished with Single Source Publishing, a content management system that uses templates in XSLT style sheets provided by XML Styles .com to transform the source content for various content delivery channels. There is also RDF* metadata that describes the content of this document.

Copyright © 2006 How To Guides .com. Alteration of content, including addition of any function such as hypertext links or pop-up advertising, or interference with the hypertext links or other functions of this site is expressly prohibited.

DISCLAIMER: All information, links, forms, applications and other items on this site or obtained from it are provided AS IS, WITHOUT WARRANTY OF ANY KIND EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.