DBA CENTRALS

Administration

Home
Installation »
- Mssql
- Oracle
Architecture »
- Mssql
- Oracle
Administration »
- Mssql
- Oracle
Backup & Recovery »
- Mssql
- Oracle
High Availability »
- Mssql »
- Oracle »
  - RAC
SQL Commands »
- Mssql
- Oracle
Emerging DBA's

SQL Architecture

➤ Physical Architecture of Sql Server

➤ SQL Server transaction log architecture

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

No comments:

Post a Comment

Subscribe to: Posts (Atom)

Pages

SQL Architecture
Oracle Administration
MSSQL Administration
MS SQL BACKUP & RECOVERY
SQL Commands
Oracle Commands

Search This Blog

Blog Archive

March 2018 (1)
December 2017 (2)
November 2017 (4)
September 2017 (2)
August 2017 (7)
July 2017 (35)

Popular Posts

ORA-17503: ksfdopn:2 Failed to open file +DATA/dbname/spfiledb.ora

Issue: PRCR-1013 : Failed to start resource ora.DBname.db PRCR-1064 : Failed to start resource ora.DBname.db on node servername CRS-501...
Oracle RAC Error: CRS-2805: Unable to start 'ora.LISTENER.lsnr' because it has a 'hard' dependency on resource type 'ora.cluster_vip_net2.type' and no resource of that type can satisfy the dependency_part1

Issue :- LISTENER is not running on one of RAC node. After attempting to restart throws below error. [ora12c@RAC2 ~]$ srvctl start list...
ORA-01565: error in identifying file '+DATA/DB_NAME/spfileDB_NAME.ora'

ISSUE :- SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DATA/DB_NAME/spf...
The listener supports no services

ISSUE:- Many times we encountered an issue where the database listener was unable to connect to DB service although the associated databa...
OPATCHAUTO-72050 :- The result of cluvfy command contain EFAIL NODE_STATUS::server2:EFAIL

ISSUE:- Failed: Verifying shared storage accessibility Version of exectask could not be retrieved from node "server2" Check...
How to take export backup or create multiple dump file on multiple file system

Oracle's Export utility (expdp) is a useful part of an overall backup strategy. Consider 300GB as database size , if we do not have F...
[SRVM(1337)]CRS-10051: CVU found following errors with Clusterware setup : PRVF-5301 : Failed to locate CRS home

Error:- I was working on issue where cluster is not coming up on node 1 but it is running on node 2. Following error has been recorded. ...
ORA-00600: internal error code, arguments: [pesldl03_MMap: errno 1 errmsg Operation not permitted

Issue : ORA-39014: One or more workers have prematurely exited. ORA-39029: worker 1 with process name "DW00" prematurely ter...
Mirrored databases are disconnected after you restart the database mirror in SQL Server

Issue:- Mirrored databases are disconnected after restart of SQL instance due to Server Hang , You end the process of the SQL Serve...
CRS-6706: Oracle Clusterware Release patch level ('mmmmm') does not match Software patch level ('nnnnn'). Oracle Clusterware cannot be started

Error:- [ora12c@Server1~]$ sudo /rdbms/app/12.1.0.2/grid/bin/crsctl start crs CRS-6706: Oracle Clusterware Release patch level ('100...

Picture Window theme. Powered by Blogger.