Monthly Archives: January 2008

Sample routine for backing up FRA (Flash Recovery Area) to TAPE

Prerequisite:1. Agent for media library is installed & Media management layer is configured correctly2. Backup policy is configured on tape library #!/bin/sh## —————————————————————————# flash_backup.sh# —————————————————————————# This will backup FRA from disk to TAPE. This is oracle recommended approach for backups.# … Continue reading

Posted in Oracle Database Backup, Oracle Recovery Manager | Tagged | Leave a comment

“map : Permission Denied” for OS authenticated users

When an OS authentication user (not in dba group) try to connect using $ sqlplus / get messages like 9564236 : map : Permission Denied 9564236 : map : Permission Denied 9564236 : map : Permission Denied SQL*Plus: Release 10.2.0.3.0 … Continue reading

Posted in Oracle Connectivity | Tagged | Leave a comment

ora-15177: cannot operate on system aliases (dbd error: ocistmtexecute)

I tried removing the ASM diskgroup file manually in 10.2.0.3. But I always use to get following errors. ORA-15032: NOT ALL ALTERATIONS PERFORMED ORA-15173: ENTRY ‘NNNDF0_BACKUP_TESTDB_000_1211060624_0.5448.6214’ DOES NOT EXIST IN DIRECTORY ‘2006_12_11′ (DBD ERROR: OCISTMTEXECUTE) My ASM diskgroup settings SQL> … Continue reading

Posted in Oracle Automatic Storage Management | Tagged | 2 Comments

Parallel backup using RMAN in RAC environment

For configuring the number of parallel channel, we can use following command RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 4; After allocating the channels, if we execute RMAN backup script, we’ll see channel allocation like allocated … Continue reading

Posted in Oracle Database Backup, Oracle Recovery Manager | Tagged | 12 Comments