ORACLE DATABASE PROBLEM AND SOLUTIONS

Monday, July 22, 2013

CHECK WHETHER DATABASE RUNNING USING SPFILE OR PFILE

SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type"
FROM v$parameter WHERE name = 'spfile';

Contact me for all kind of database support >>>>>>>>>>>>>>>>>>>>>>>>>>>>>> I am Anurag Pandey, working as Cloud Database Architect | Migration & Modernization Expert . Database Administration and Implementation. Provide technical guidance and work with global team. Extensive Experience in Database Installation and Configuration, Real Application Cluster (RAC), ASM, Dataguard , Patching, Upgrade, RMAN, Performance Tuning, Backup and Recovery, Azure, Google, AWS Cloud, AWS RDS, MySQL, Database Migration Service(DMS),CloudEndure - MGN, Azure Site Recovery, Azure Migrate, Datapump, terraform automation, Ansible

Tuesday, July 16, 2013

ORACLE ASM INSTALLATION ON LINUX ,VMVARE,ORACLE10g

[oracle@localhost ~]$ uname -r

2.6.18-92.el5

[oracle@localhost ~]$

[oracle@localhost ~]$ su - root

Password:

[root@localhost ~]#

[root@localhost ~]# cd /media/RHEL_5.2\ i386\ DV/Server/

[root@localhost Server]#

[root@localhost Server]# rpm -ivh kernel-debug-2.6.18-92.el5.i686.rpm

warning: kernel-debug-2.6.18-92.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 37017186

Preparing... ########################################### [100%]

1:kernel-debug ########################################### [100%]

[root@localhost Server]# rpm -ivh kernel-PAE-2.6.18-92.el5.i686.rpm

warning: kernel-PAE-2.6.18-92.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 37017186

Preparing... ########################################### [100%]

1:kernel-PAE ########################################### [100%]

[root@localhost Server]# rpm -ivh kernel-xen-2.6.18-92.el5.i686.rpm

warning: kernel-xen-2.6.18-92.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 37017186

Preparing... ########################################### [100%]

1:kernel-xen ########################################### [100%]

[root@localhost Server]#

[root@localhost Server]# cde

-bash: cde: command not found

[root@localhost Server]# cd

[root@localhost ~]#

[root@localhost ~]# cd /home/oracle/asmrpm/

[root@localhost asmrpm]#

[root@localhost asmrpm]# rpm -ivh oracleasm-support-2.1.7-1.el5.i386.rpm

error: open of oracleasm-support-2.1.7-1.el5.i386.rpm failed: No such file or directory

[root@localhost asmrpm]# ll

total 632

-rwxrw-rw- 1 oracle oinstall 128654 Apr 8 11:54 oracleasm-2.6.18-92.el5-2.0.5-1.el5.i686.rpm

-rwxrw-rw- 1 oracle oinstall 130366 Apr 8 11:54 oracleasm-2.6.18-92.el5debug-2.0.5-1.el5.i686.rpm

-rwxrw-rw- 1 oracle oinstall 2836 Apr 8 11:54 oracleasm-2.6.18-92.el5-debuginfo-2.0.5-1.el5.i686.rpm

-rwxrw-rw- 1 oracle oinstall 129257 Apr 8 11:55 oracleasm-2.6.18-92.el5PAE-2.0.5-1.el5.i686.rpm

-rwxrw-rw- 1 oracle oinstall 126270 Apr 8 11:55 oracleasm-2.6.18-92.el5xen-2.0.5-1.el5.i686.rpm

-rwxrw-rw- 1 oracle oinstall 13929 Apr 8 12:14 oracleasmlib-2.0.4-1.el5.i386.rpm

-rwxrw-rw- 1 oracle oinstall 85303 Apr 8 11:53 oracleasm-support-2.1.8-1.el5.i386.rpm

[root@localhost asmrpm]# chmod 777 /home/oracle/asmrpm/

[root@localhost asmrpm]#

[root@localhost asmrpm]# rpm -ivh oracleasm-support-2.1.7-1.el5.i386.rpm

error: open of oracleasm-support-2.1.7-1.el5.i386.rpm failed: No such file or directory

[root@localhost asmrpm]#

[root@localhost asmrpm]# rpm -Uvh oracleasm-support-2.1.7-1.el5.i386.rpm

error: open of oracleasm-support-2.1.7-1.el5.i386.rpm failed: No such file or directory

[root@localhost asmrpm]#

[root@localhost asmrpm]# ll

total 632

-rwxrw-rw- 1 oracle oinstall 128654 Apr 8 11:54 oracleasm-2.6.18-92.el5-2.0.5-1.el5.i686.rpm

-rwxrw-rw- 1 oracle oinstall 130366 Apr 8 11:54 oracleasm-2.6.18-92.el5debug-2.0.5-1.el5.i686.rpm

-rwxrw-rw- 1 oracle oinstall 2836 Apr 8 11:54 oracleasm-2.6.18-92.el5-debuginfo-2.0.5-1.el5.i686.rpm

-rwxrw-rw- 1 oracle oinstall 129257 Apr 8 11:55 oracleasm-2.6.18-92.el5PAE-2.0.5-1.el5.i686.rpm

-rwxrw-rw- 1 oracle oinstall 126270 Apr 8 11:55 oracleasm-2.6.18-92.el5xen-2.0.5-1.el5.i686.rpm

-rwxrw-rw- 1 oracle oinstall 13929 Apr 8 12:14 oracleasmlib-2.0.4-1.el5.i386.rpm

-rwxrw-rw- 1 oracle oinstall 85303 Apr 8 11:53 oracleasm-support-2.1.8-1.el5.i386.rpm

[root@localhost asmrpm]#

[root@localhost asmrpm]# rpm -Uvh oracleasm-support-2.1.8-1.el5.i386.rpm

warning: oracleasm-support-2.1.8-1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing... ########################################### [100%]

1:oracleasm-support ########################################### [100%]

[root@localhost asmrpm]#

[root@localhost asmrpm]# rpm -ivh oracleasm-2.6.18-92.el5-2.0.5-1.el5.i686.rpm

warning: oracleasm-2.6.18-92.el5-2.0.5-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing... ########################################### [100%]

1:oracleasm-2.6.18-92.el5########################################### [100%]

[root@localhost asmrpm]# rpm -ivh oracleasm-2.6.18-92.el5debug-2.0.5-1.el5.i686.rpm

warning: oracleasm-2.6.18-92.el5debug-2.0.5-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing... ########################################### [100%]

1:oracleasm-2.6.18-92.el5########################################### [100%]

[root@localhost asmrpm]#

[root@localhost asmrpm]# rpm -ivh oracleasm-2.6.18-92.el5-debuginfo-2.0.5-1.el5.i686.rpm

warning: oracleasm-2.6.18-92.el5-debuginfo-2.0.5-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing... ########################################### [100%]

1:oracleasm-2.6.18-92.el5########################################### [100%]

[root@localhost asmrpm]#

[root@localhost asmrpm]# rpm -ivh oracleasm-2.6.18-92.el5PAE-2.0.5-1.el5.i686.rpm

warning: oracleasm-2.6.18-92.el5PAE-2.0.5-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing... ########################################### [100%]

1:oracleasm-2.6.18-92.el5########################################### [100%]

[root@localhost asmrpm]#

[root@localhost asmrpm]# rpm -ivh oracleasm-2.6.18-92.el5xen-2.0.5-1.el5.i686.rpm

warning: oracleasm-2.6.18-92.el5xen-2.0.5-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing... ########################################### [100%]

1:oracleasm-2.6.18-92.el5########################################### [100%]

[root@localhost asmrpm]#

[root@localhost asmrpm]# rpm -ivh oracleasm-2.6.18-92.el5xen-2.0.5-1.el5.i686.rpm

warning: oracleasm-2.6.18-92.el5xen-2.0.5-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing... ########################################### [100%]

package oracleasm-2.6.18-92.el5xen-2.0.5-1.el5 is already installed

[root@localhost asmrpm]#

[root@localhost asmrpm]# rpm -ivh *.rpm

warning: oracleasm-2.6.18-92.el5-2.0.5-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing... ########################################### [100%]

package oracleasm-support-2.1.8-1.el5 is already installed

package oracleasm-2.6.18-92.el5xen-2.0.5-1.el5 is already installed

package oracleasm-2.6.18-92.el5-2.0.5-1.el5 is already installed

package oracleasm-2.6.18-92.el5debug-2.0.5-1.el5 is already installed

package oracleasm-2.6.18-92.el5-debuginfo-2.0.5-1.el5 is already installed

package oracleasm-2.6.18-92.el5PAE-2.0.5-1.el5 is already installed

[root@localhost asmrpm]#

[root@localhost asmrpm]# cd

[root@localhost ~]#

[root@localhost ~]# /oracle/product/10.2.0/db_1/bin/localconfig add

/etc/oracle does not exist. Creating it now.

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

Configuration for local CSS has been initialized

Adding to inittab

Startup will be queued to init within 90 seconds.

Checking the status of new Oracle init process...

Expecting the CRS daemons to be up within 600 seconds.

CSS is active on these nodes.

localhost

CSS is active on all nodes.

Oracle CSS service is installed and running under init(1M)

[root@localhost ~]#

/etc/init.d/oracleasm configure

Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library

driver. The following questions will determine whether the driver is

loaded on boot and what permissions it will have. The current values

will be shown in brackets ('[]'). Hitting <ENTER> without typing an

answer will keep that current value. Ctrl-C will abort.

Default user to own the driver interface []: oracle

Default group to own the driver interface []: dba

Start Oracle ASM library driver on boot (y/n) [n]: y

Scan for Oracle ASM disks on boot (y/n) [y]: y

Writing Oracle ASM library driver configuration: done

Initializing the Oracle ASMLib driver: [ OK ]

Scanning the system for Oracle ASMLib disks: [ OK ]

[root@localhost ~]# ll /etc/init.d/

total 912

-rwxr-xr-x 1 root root 1128 Oct 10 2006 acpid

-rwxr-xr-x 1 root root 1441 Dec 18 2006 anacron

-rwxr-xr-x 1 root root 1429 Aug 22 2006 apmd

-rwxr-xr-x 1 root root 1176 Aug 23 2006 atd

-rwxr-xr-x 1 root root 3114 Apr 21 2008 auditd

-rwxr-xr-x 1 root root 2461 Apr 4 2008 autofs

-rwxr-xr-x 1 root root 1848 Jan 8 2007 avahi-daemon

-rwxr-xr-x 1 root root 1789 Jan 8 2007 avahi-dnsconfd

-rwxr-xr-x 1 root root 1477 Oct 3 2006 bluetooth

-rwxr-xr-x 1 root root 1357 Nov 20 2007 capi

-rwxr-xr-x 1 root root 1470 Jun 28 2007 conman

-rwxr-xr-x 1 root root 7654 Mar 6 2008 cpuspeed

-rwxr-xr-x 1 root root 1904 Jun 22 2007 crond

-rwxr-xr-x 1 root root 1942 Mar 20 2008 cups

-rwxr-xr-x 1 root root 299 Apr 21 2008 cups-config-daemon

-rwxr-xr-x 1 root root 1505 Jul 12 2006 dc_client

-rwxr-xr-x 1 root root 1347 Jul 12 2006 dc_server

-rwxr-xr-x 1 root root 2785 Dec 7 2006 dhcdbd

-rwxr-xr-x 1 root root 917 Mar 13 2008 dovecot

-rwxr-xr-x 1 root root 996 Oct 3 2006 dund

-rwxr-xr-x 1 root root 1965 Jun 28 2007 firstboot

-rwxr-xr-x 1 root root 13980 Mar 3 2008 functions

-rwxr-xr-x 1 root root 1778 Jul 12 2006 gpm

-rwxr-xr-x 1 root root 1486 Apr 11 2008 haldaemon

-rwxr-xr-x 1 root root 5766 Mar 3 2008 halt

-rwxr-xr-x 1 root root 966 Oct 3 2006 hidd

-rwxr-xr-x 1 root root 4777 Oct 10 2007 hplip

-rwxr-xr-x 1 root root 3200 Jan 11 2008 httpd

-r-xr-xr-x 1 root root 35394 Jul 11 12:06 init.cssd

-rwxr-xr-x 1 root root 3084 Aug 29 2006 innd

-rwxr-xr-x 1 root root 7543 Jan 14 2008 ip6tables

-rwxr-xr-x 1 root root 13864 Jan 15 2008 ipmi

-rwxr-xr-x 1 root root 7460 Jan 14 2008 iptables

-rwxr-xr-x 1 root root 1624 Aug 1 2006 irda

-rwxr-xr-x 1 root root 2256 Apr 10 2008 irqbalance

-rwxr-xr-x 1 root root 6229 Nov 20 2007 isdn

-rwxr-xr-x 1 root root 10034 Apr 11 2008 kdump

-rwxr-xr-x 1 root root 652 Mar 3 2008 killall

-rwxr-xr-x 1 root root 1331 Nov 10 2007 krb524

-rwxr-xr-x 1 root root 1406 Apr 4 2008 kudzu

-rwxr-xr-x 1 root root 1684 Sep 6 2006 lisa

-rwxr-xr-x 1 root root 3112 Jul 13 2006 lm_sensors

-rwxr-xr-x 1 root root 1932 Apr 4 2008 lvm2-monitor

-rwxr-xr-x 1 root root 1914 Dec 7 2007 mcstrans

-rwxr-xr-x 1 root root 2125 Jan 19 2008 mdmonitor

-rwxr-xr-x 1 root root 1613 Jan 19 2008 mdmpd

-rwxr-xr-x 1 root root 1819 Apr 16 2008 messagebus

-rwxr-xr-x 1 root root 1926 Apr 3 2008 microcode_ctl

-rwxr-xr-x 1 root root 1193 Apr 2 2008 multipathd

-rwxr-xr-- 1 root root 8542 Feb 29 2008 named

-rwxr-xr-x 1 root root 2985 Mar 3 2008 netconsole

-rwxr-xr-x 1 root root 5675 Mar 3 2008 netfs

-rwxr-xr-x 1 root root 1258 Apr 18 2008 netplugd

-rwxr-xr-x 1 root root 8001 Mar 3 2008 network

-rwxr-xr-x 1 root root 1598 Apr 2 2008 NetworkManager

-rwxr-xr-x 1 root root 1480 Apr 2 2008 NetworkManagerDispatcher

-rwxr-xr-x 1 root root 4386 Feb 28 2008 nfs

-rwxr-xr-x 1 root root 3243 Feb 28 2008 nfslock

-rwxr-xr-x 1 root root 2517 Apr 11 2008 nscd

-rwxr-xr-x 1 root root 3361 Jan 17 2008 ntpd

-rwxr-xr-x 1 root root 12865 Apr 11 2008 openibd

-rwxr-xr-x 1 root root 7124 Feb 6 08:37 oracleasm

-rwxr-xr-x 1 root root 1203 Oct 3 2006 pand

-rwxr-xr-x 1 root root 2020 Jan 17 2008 pcscd

-rwxr-xr-x 1 root root 1877 Jul 13 2006 portmap

-rwxr-xr-x 1 root root 1021 Jul 13 2006 psacct

-rwxr-xr-x 1 root root 1387 Dec 21 2006 rdisc

-rwxr-xr-x 1 root root 931 Feb 5 2007 readahead_early

-rwxr-xr-x 1 root root 930 Feb 5 2007 readahead_later

-rwxr-xr-x 1 root root 1793 Feb 1 2008 restorecond

-rwxr-xr-x 1 root root 1782 Dec 15 2006 rhnsd

-rwxr-xr-x 1 root root 2434 Feb 28 2008 rpcgssd

-rwxr-xr-x 1 root root 2021 Feb 28 2008 rpcidmapd

-rwxr-xr-x 1 root root 2480 Feb 28 2008 rpcsvcgssd

-rwxr-xr-x 1 root root 1010 Aug 15 2006 rwhod

-rwxr-xr-x 1 root root 1547 Sep 30 2006 saslauthd

-rwxr-xr-x 1 root root 3349 Nov 28 2006 sendmail

-rwxr-xr-x 1 root root 3814 Apr 2 2008 setroubleshoot

-rwxr-xr-x 1 root root 647 Mar 3 2008 single

-rwxr-xr-x 1 root root 2537 Jan 4 2008 smartd

-rwxr-xr-x 1 root root 2145 Apr 3 2008 smb

-rwxr-xr-x 1 root root 1575 Jan 7 2008 spamassassin

-rwxr-xr-x 1 root root 3283 Apr 1 2008 squid

-rwxr-xr-x 1 root root 3340 Jan 15 2008 sshd

-rwxr-xr-x 1 root root 2043 Mar 25 2008 syslog

-rwxr-xr-x 1 root root 2796 Aug 23 2006 tux

-r-xr-xr-x 1 root root 36773 Jul 10 22:14 vmware-tools

-rwxr-xr-x 1 root root 2051 Jan 15 2007 vncserver

-rwxr-xr-x 1 root root 1778 Dec 13 2007 vsftpd

-rwxr-xr-x 1 root root 1645 Feb 2 2008 wdaemon

-rwxr-xr-x 1 root root 1559 Apr 3 2008 winbind

-rwxr-xr-x 1 root root 1650 Jan 17 2008 wpa_supplicant

-rwxr-xr-x 1 root root 3902 Jun 16 2007 xfs

-rwxr-xr-x 1 root root 2497 Dec 6 2006 xinetd

-rwxr-xr-x 1 root root 3465 Jul 14 2007 ypbind

-rwxr-xr-x 1 root root 1498 Jan 18 2008 yum-updatesd

[root@localhost ~]#

ANURAG PANDEY

STEP BY STEP RMAN RECOVERY CATALOG CREATION AND CONFIGURATION

create databse rman using dbca

SQL> create tablespace catalog datafile '/oracle/product/10.2.0/oradata/rman/catalog01.dbf' size 30m;

Tablespace created.

SQL>
SQL>
SQL> create user rman identified by rman;

User created.

SQL>
SQL>
SQL> alter user rman quota unlimited on catalog;

User altered.

SQL>
SQL>
SQL> grant recovery_catalog_owner to rman;
Grant succeeded.

SQL>
SQL>
SQL>
SQL> alter user rman default tablespace catalog;

User altered.

SQL> conn rman/rman
Connected.
SQL>

connect with rman

[oracle@localhost ~]$ rman catalog rman/rman@rman

create catalog;

[oracle@localhost ~]$ rman target sys/orcl@orcl catalog rman/rman@rman

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jul 16 14:58:14 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: ORCL (DBID=1348274388)
connected to recovery catalog database

RMAN>

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

RMAN>

RMAN> report schema;

Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 480 SYSTEM YES /oracle/product/10.2.0/oradata/orcl/system01.dbf
2 30 UNDOTBS1 YES /oracle/product/10.2.0/oradata/orcl/undotbs01.dbf
3 240 SYSAUX NO /oracle/product/10.2.0/oradata/orcl/sysaux01.dbf
4 5 USERS NO /oracle/product/10.2.0/oradata/orcl/users01.dbf
5 100 EXAMPLE NO /oracle/product/10.2.0/oradata/orcl/example01.dbf
6 20 RMAN_TEST NO /oracle/product/10.2.0/oradata/orcl/rman01.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMP 32767 /oracle/product/10.2.0/oradata/orcl/temp01.dbf

RMAN>

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

thease all tables are creating by create catalog statement in rman prompt

SQL> select * from tab;

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
DB TABLE
NODE TABLE
CONF TABLE
DBINC TABLE
CKP TABLE
TS TABLE
TSATT TABLE
DF TABLE
DFATT TABLE
TF TABLE
TFATT TABLE

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
OFFR TABLE
RR TABLE
RT TABLE
ORL TABLE
RLH TABLE
AL TABLE
BS TABLE
BP TABLE
BCF TABLE
CCF TABLE
XCF TABLE

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
BSF TABLE
BDF TABLE
CDF TABLE
XDF TABLE
BRL TABLE
BCB TABLE
CCB TABLE
SCR TABLE
SCRL TABLE
CONFIG TABLE
XAL TABLE

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
RSR TABLE
FB TABLE
RC_DATABASE VIEW
RC_DATABASE_INCARNATION VIEW
RC_RESYNC VIEW
RC_CHECKPOINT VIEW
RC_TABLESPACE VIEW
RC_DATAFILE VIEW
RC_TEMPFILE VIEW
RC_REDO_THREAD VIEW
RC_REDO_LOG VIEW

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
RC_LOG_HISTORY VIEW
RC_ARCHIVED_LOG VIEW
RC_BACKUP_SET VIEW
RC_BACKUP_PIECE VIEW
RC_BACKUP_DATAFILE VIEW
RC_BACKUP_CONTROLFILE VIEW
RC_BACKUP_SPFILE VIEW
RC_DATAFILE_COPY VIEW
RC_CONTROLFILE_COPY VIEW
RC_BACKUP_REDOLOG VIEW
RC_BACKUP_CORRUPTION VIEW

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
RC_COPY_CORRUPTION VIEW
RC_OFFLINE_RANGE VIEW
RC_STORED_SCRIPT VIEW
RC_STORED_SCRIPT_LINE VIEW
RC_PROXY_DATAFILE VIEW
RC_PROXY_CONTROLFILE VIEW
RC_RMAN_CONFIGURATION VIEW
RC_DATABASE_BLOCK_CORRUPTION VIEW
RC_PROXY_ARCHIVEDLOG VIEW
RC_RMAN_STATUS VIEW
ROUT TABLE

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
RC_RMAN_OUTPUT VIEW
RCVER TABLE
RC_BACKUP_FILES VIEW
RC_RMAN_BACKUP_SUBJOB_DETAILS VIEW
RC_RMAN_BACKUP_JOB_DETAILS VIEW
RC_BACKUP_SET_DETAILS VIEW
RC_BACKUP_PIECE_DETAILS VIEW
RC_BACKUP_COPY_DETAILS VIEW
RC_PROXY_COPY_DETAILS VIEW
RC_PROXY_ARCHIVELOG_DETAILS VIEW
RC_BACKUP_DATAFILE_DETAILS VIEW

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
RC_BACKUP_CONTROLFILE_DETAILS VIEW
RC_BACKUP_ARCHIVELOG_DETAILS VIEW
RC_BACKUP_SPFILE_DETAILS VIEW
RC_BACKUP_SET_SUMMARY VIEW
RC_BACKUP_DATAFILE_SUMMARY VIEW
RC_BACKUP_CONTROLFILE_SUMMARY VIEW
RC_BACKUP_ARCHIVELOG_SUMMARY VIEW
RC_BACKUP_SPFILE_SUMMARY VIEW
RC_BACKUP_COPY_SUMMARY VIEW
RC_PROXY_COPY_SUMMARY VIEW
RC_PROXY_ARCHIVELOG_SUMMARY VIEW

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
RC_UNUSABLE_BACKUPFILE_DETAILS VIEW
RC_RMAN_BACKUP_TYPE VIEW

90 rows selected.

SQL>

RESYNC CATALOG

Updates the recovery catalog with RMAN metadata in the current control file of the target database (default).

RMAN creates a snapshot control file in order to obtain a read-consistent view of the control file, then updates the recovery catalog with any new information from the snapshot. The RESYNC CATALOG command updates the following classes or records:

Log history records, which are created when a log switch occurs. Note that log history records describe an online log switch, not a log archival.
Archived redo log records, which are associated with archived logs created by archiving an online redo log, copying an existing archived log, or restoring backups of archived logs.
Backup records, which are records of backup sets, backup pieces, proxy copies, and image copies.
Physical schema records, which are associated with datafiles and tablespaces. If the target database is open, then rollback segment information is also updated.

ANURAG PANDEY

Tuesday, June 25, 2013

ORACLE 10g INSTALLATION ON LINUX

ANURAG PANDEY