Thursday 2 May 2013

Oracle Rman Datafile Summary

RMAN> list backup of datafile 1 Summary;


List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
247183  B  F  A SBT_TAPE    11-APR-13       1       1       NO         TAG20133122111T020943

Wednesday 1 May 2013

sysasm ORA-01031: insufficient privileges error...


Cause:
ora@orac1>sqlplus / as sysasm

QL*Plus: Release 11.2.0.1.0 Production on Wed May 1 23:55:05 2013

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

SQL> connect sys as sysasm
Enter password:
ERROR:
ORA-01031: insufficient privileges

Solution:

ora@orac1> echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/dbhome_1
ora@orac1> export ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid 
ora@orac1> sqlplus / as sysasm



SQL*Plus: Release 11.2.0.1.0 Production on Thu May 2 00:01:07 2013

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option

SQL>