Using file /data/oracle/product/11.2.0/db_1/dbs/initdb1.ora
Start with command:
startup pfile='/data/oracle/product/11.2.0/db_1/dbs/initdb1.ora';
Startup error:
ORA-01506: missing or illegal database nam …
1.Solution 1
Active Data Guard (Oracle 11g Data Guard)
Prior to Oracle 11g, a primary-standby relationship typically consisting of two data mirror nodes was used to achieve rapid database switchover and disaster recovery, which we call Data Guard. Active Data Guard …
How to Build a High-Availability Oracle 11g Active Data Guard Environment
Oracle Data Guard provides three data protection modes. Here is a summary of the characteristics of each mode.
1. Maximum Protection Mode
1) This mode offers the highest level of data protection;
2) The primary database cannot commit a transaction until at least one physical standby database has received the redo log;
3) …
This error occurs because RAC is not linked to the RDBMS home.
You can check whether RAC is linked to the RDBMS home by following these steps:
(1) Navigate to $ORACLE_HOME/rdbms/lib cd $ORACLE_HOME/rdbms/lib(2) Run the following command: nm -r …
Export:
[root@localhost ~]# su oracle
[oracle@localhost root]$ exp loanadmin/123456@orcl file=/home/oracle/160926.dmp
loanadmin is the username, 123456 is the database password, orcl is the instance name (default is orcl), and file= specifies the export …
