Oracle Database Security

Oracle provides the following way of managing database security.

• Alerts
• System Privileges
• Object Privileges
• Users and Roles
• User and Tablespace Quotas
• Profiles and Resource Limits
• Password Management
• Connect Internal and Password Files
• O/S Authentication
• Auditing
• Event Triggers
• Fine Grained Access Control
• Oracle Label Security
• Database Vault
• Audit Vault
• Data Encryption
• Security Server

ORA-16069: Archive Log standby database activation identifier mismatch

I was Testing "Using a standby database for Read/Write for testing and Convert back to standby mode using Flasback"

Step followed :
Standby database :
1) alter database recover managed standby database finish ;
2) create restore point Before_DR_Test;
3) alter database commit to switchover to primary;
4) Startup force;
5) Create table , select data, etc
6) Complete any testing for read/write operation

Convert back to Standby :

7) startup mount force;
8) flashback database to restore point Before_DR_Test;
9) alter database convert to physical standby;
10) startup mount force;
11) alter database recover managed standby database disconnect;

All succeed and managed to convert the database in standby mode, but its failing to accept any new archive log generated at primary database. I am getting following error in standby database alert.log

RFS[10]: Activation ID mismatch: found 0x99d06db8 expected 0x99d0b54

ORA-16069: Archive Log standby database activation identifier mismatch

Configure SSH for RAC

update will be soon

Modify VIP Configuration

Update will be soon

Oracle DBA Questions

1. Database size is 500GB, what will be best possible backup solution/stratagy and why ?
2. CRS and ASM is 10.2.0.4 and DB is 10.1.0.4. Do you think there will any issues , If yes/No , why
3. At What stage you think RMAN Backup stratagy won't be enough? why

Regards
Krishan

10g OCM – GOAL Achieved

Hello ,

I like to share the joyful moment of my life with internet community. I am glad to inform, that I am now member of an elite group of professional by successful competition of 10g OCM Certification.

I wrote my exam in New Delhi in August 2008, today after long wait of more then 7 months, I received my result by email saying
“
Dear Krishan
Congratulations! on the successful completion of the Oracle DBA 10g Certified Master practicum

”
Now I am waiting for my OCM ID card and denim OCM shirt, which I am going to receive very soon by post.

Regards,

Krishan Jaglan

11g New Features for DBA's

Oracle latest database features

In this multipart series, learn how important new features such as Database Replay, Flashback Data Archive, and SecureFiles work via simple, actionable how-to's and sample code.
Change, although constantly present, is seldom risk-free. Even if the change is relatively minor (creating an index for example), your goal is probably to predict its precise impact as accurately as possible and then take appropriate action
Many new change assurance (or "Real Application Testing," as Oracle calls it) features in Oracle Database 11g bring that dream closer to reality. The Database Replay tool, for example, allows you to capture production database workload and replay it in a test (or even the same) database to assess the impact of change. Or consider SQL Performance Analyzer, which predicts the performance impact of changes to SQL before they are made. In my opinion, this Real Application Testing functionality alone justifies the upgrade.
Overall, Oracle Database 11g makes database infrastructure far more efficient, resilient, and manageable. For example, very compelling new features in the realm of partitioning ease the design and management of partitioned tables immensely.
In this series (as in the previous series focusing on Oracle Database 10g), you will learn how these new features work via simple, actionable how-to's and sample code.
by arup nanda