Monthly Archive:: August 2013

Steps to manually switch over database roles

Login to the Primary Database and Switch the Logs SQL> alter system archive log current; ---- ---- (Issue this command few times) (In case of RAC database, shutdown all the nodes except the primary one. Perform log switch

RMAN Backup fails with ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

Issue Description: RMAN backup failed with ORA-27054 errors while NFS filesystem was used for backup destination RMAN> run 2> { 3> allocate channel c1 device type disk; 4> allocate channel c2 device type disk; 5> backup database

How to Un-Catalog Duplicate Backup piece

Use the RMAN,  CROSSCHECK command to find the duplicate entries for a backup file. RMAN> crosscheck backup [completed ] [after/before]  [time];   2.  If you use the backup piece name of the duplicate entries, you will get

Recreate AWR in Oracle 11g

1: Check and make a note of the following parameter values SQL> show parameter cluster_database SQL> show parameter statistics_level SQL> show parameter sga_target SQL> show parameter memory_target SQL> show parameter spfile   2: Disable AWR Snapshots by
Visit Us On LinkedinVisit Us On TwitterVisit Us On Google PlusCheck Our Feed