Changing archive location intergrating of OMF on ASM & RMAN

While I checked the file location of the archives, I discovered unneeded aliases
 
ASMCMD [+] > cd +DATA/nplprd
ASMCMD [+DATA/nplprd] > ls -l
Type           Redund  Striped  Time             Sys  Name
                                                      1_12_621591104.dbf => +DATA/nplprd/archivelog/2007_05_10/thread_1_seq_12.295.622220233
                                                 Y    ARCHIVELOG/
                                                 Y    CHANGETRACKING/
                                                 Y    CONTROLFILE/
                                                 Y    DATAFILE/
                                                 Y    ONLINELOG/
                                                 Y    PARAMETERFILE/
                                                 Y    TEMPFILE/
                                                 N    spfilenplprd.ora => +DATA/NPLPRD/PARAMETERFILE/spfile.272.621591209
 
Looking at the initialization parameter I figured the source of the problem
 
SQL> show parameter log_archive_dest_1
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1                   string      LOCATION=+DATA/nplprd/
 
I changed the location to let oracle manage it by using Oracle Managed Files (OMF)
 
SQL> alter system set log_archive_dest_1 = 'LOCATION=+DATA' scope=both;
 
Now I had to catalog these file in their new location
 
RMAN> CATALOG START WITH '+data/nplprd/ARCHIVELOG/';
 
File Name: +data/nplprd/ARCHIVELOG/2007_05_10/thread_1_seq_12.295.622220233
 
Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
cataloging done
 
List of Cataloged Files
=======================
File Name: +data/nplprd/ARCHIVELOG/2007_05_10/thread_1_seq_12.295.622220233
 
The file is registered twice in the catalog
 
RMAN> list archivelog all;
 

List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
364     1    12      A 09-MAY-07 +DATA/nplprd/archivelog/2007_05_10/thread_1_seq_12.295.622220233
159     1    12      A 09-MAY-07 +DATA/nplprd/1_12_621591104.dbf
 
Removed the unwanted alias
 
ASMCMD [+DATA/nplprd] > rmalias +DATA/nplprd/1_12_621591104.dbf
 
Let RMAN catalog "know" about the new status
RMAN> crosscheck archivelog all;
 
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=125 instance=nplprd1 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=135 instance=nplprd2 devtype=DISK
validation succeeded for archived log
archive log filename=+DATA/nplprd/archivelog/2007_05_10/thread_1_seq_12.295.622220233 recid=35 stamp=622465635
validation succeeded for archived log
Crosschecked 1 objects
 
validation failed for archived log
archive log filename=+DATA/nplprd/1_12_621591104.dbf recid=20 stamp=622220233
validation failed for archived log
Crosschecked 1 objects
 
Now the alias is marked as expired.

RMAN> list archivelog all;
 
List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
364     1    12      A 09-MAY-07 +DATA/nplprd/archivelog/2007_05_10/thread_1_seq_12.295.622220233
159     1    12      X 09-MAY-07 +DATA/nplprd/1_12_621591104.dbf
 
The final step is just to delete this record from the RMAN
 
RMAN>  delete expired archivelog all;
 
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=125 instance=nplprd1 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=135 instance=nplprd2 devtype=DISK
 
List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
159     1    12      X 09-MAY-07 +DATA/nplprd/1_12_621591104.dbf
 
Do you really want to delete the above objects (enter YES or NO)? YES
deleted archive log
archive log filename=+DATA/nplprd/1_12_621591104.dbf recid=20 stamp=622220233
deleted archive log
 
Deleted 1 EXPIRED objects
 
Looking at the results
 
RMAN>  list archivelog all;
 
List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
364     1    12      A 09-MAY-07 +DATA/nplprd/archivelog/2007_05_10/thread_1_seq_12.295.622220233

Comments

Post a Comment

Popular posts from this blog

Data Guard - Changing IP Addresses

Image
When changing IP of a host we should update/recheck the following places: /etc/hosts or DNS listener.ora tnsnames.ora Database parameters (local_listener, remote_listener) Data Guard configuration This document is also relevant when changing the IP address of the connection between the hosts, other than the original IP addresses we used during the installation. When installation is done using the hostname and not the IP address, most of the changes are not relevant except for /etc/hosts. In this document, I will describe how to change the Data Guard Broker configuration. Dataguard configuration Show the environment DGMGRL> show configuration Configuration - dr   Protection Mode: MaxAvailability   Members:   pdb7 - Primary database     fdb7 - Far sync instance       sdb7 - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS   (status updated 351 seconds ago) Show detailed information of the Primary
Read more

Install Oracle Internet Directory (OID) in Standalone mode

Image
Oracle Internet Directory (OID) is an LDAP server which uses an Oracle database as a datastore. Client machines can use the OID for all TNS lookups. With OID. Once all client machines are configured correctly any modifications to the TNS lookups can be done from a central location reducing the amount of client machine administration. This guide is about installing and using Oracle Internet Directory in Standalone mode, no need for Oracle Fusion Middleware Infrastructure. Step-by-step guide Download Oracle Internet Directory (Part of identity management) from http://www.oracle.com/technetwork/middleware/id-mgmt/downloads/index.html Install OID, follow instructions: https://docs.oracle.com/en/middleware/lifecycle/12.2.1.3/inoim/installing-product-software.html#GUID-5D47117E-3983-4BED-BADB-CB7DDD63DB34 Starting the Installation Program: ./fmw_12.2.1.3.0_oid_linux64.bin Configure the Domain: $ORACLE_HOME/oracle_common/common/bin/config.sh Start the Servers for Standal
Read more

Fixing & Registering ORACLE_HOMES in Central Inventory

Central Inventory location is determined by oraInst.loc located in: HP/Solaris /var/opt/oracle/oraInst.loc Linux /etc/oraInst.loc Windows \\HKEY_LOCAL_MACHINE\Software\Oracle\inst_loc To check if all oracle homes are registered within the Central Inventory run the following command: ${ORACLE_HOME}/oui/bin/opatch lsinventory -all Invoking OPatch 10.2.0.3.0 Oracle interim Patch Installer version 10.2.0.3.0 Copyright (c) 2005, Oracle Corporation. All rights reserved.. Oracle Home : /software/oracle/OEM10gR2/agent10g Central Inventory : /software/oracle/oraInventory from : /var/opt/oracle/oraInst.loc OPatch version : 10.2.0.3.0 OUI version : 10.2.0.3.0 OUI location : /software/oracle/OEM10gR2/agent10g/oui Log file location : /software/oracle/OEM10gR2/agent10g/cfgtoollogs/opatch/opatch....log Lsinventory Output file location : /software/oracle/OEM10gR2/agent10g/cfgtoollogs/....lsinventory.....txt ----------------------------------... List of Oracle Homes:
Read more