Sanjay Forum

Questions and Answers What is a "Shared APPL_TOP"? Answer: A traditional multi-node installation requires the Applications file system on each node in the system. In a Shared APPL_TOP installation, the APPL_TOP and the COMMON_TOP file systems are installed on a shared disk resource mounted to each node in the system. These nodes can be used to provide standard application tier services, such as Forms, Web, and Concurrent processing. Any changes made in the shared APPL_TOP file system are immediately visible on all nodes. Note that each node continues to have a separate Applications techstack installation (see also question 2). What is a "shared application tier file system"? Answer: In a shared application tier file system installation, the APPL_TOP, the COMMON_TOP, and the Applications technology stack (ORACLE_HOMEs) are installed on a shared disk resource mounted to each node in the system. These nodes can be used to provide standard appl...

################################################################ ShutDown: Prod: ALTER SYSTEM SET log_archive_dest_state_2=DEFER; DR: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; SHUT IMMEDIATE; ################################################################ StartUp: DR: STARTUP NOMOUNT ALTER DATABASE MOUNT STANDBY DATABASE ; ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION; Prod: ALTER SYSTEM SET log_archive_dest_state_2=ENABLE; ################################################################

Activating the Standby Database - Failover Method In the event of a disaster on the primary machine, you need to make the standby database active as soon as possible. In this example, it is assumed that the primary database server is not available and that the standby database needs to be activated as the primary database immediately. The standby database will need to be activated in its current state - no other redo from the primary database will be applied as it is assumed to be down The steps involved are: 1. If the standby database is in a RAC environment, stop all but one instance. oracle $ srvctl stop instance -d database_name> -i instance_name 2. If the standby database is in managed recovery mode, it will need to be cancelled and the instance shutdown using the IMMEDIATE option: SQL> recover managed standby database cancel; Media recovery complete. SQL> shutdown immediate 3. Startup the instance and then MOUNT the DB in standby mode: SQL> connect / as sysdba Conn...

What is rconfig ? rconfig is a command line tool introduced in Oracle Database 10g R2 to convert Single-Instance 10g R2 Database to RAC(Real Application Cluster). The other option is to use Convert to RAC option on the single-instance database target of Oracle Enterprise Manager Grid Control. How does rconfig works ? rconfig is located at $ORACLE_HOME/bin/. rconfig takes in a xml input file and convert the Single Instance database whose information is provided in the xml.This tool is documented in the RAC Admin Guide and a sample xml can be found $ORACLE_HOME/assistants/rconfig/sampleXMLs/ConvertToRAC.xml. rconfig performs following steps : Migrate the database to ASM storage (Only if ASM is specified as storage option in the configuration xml file above) Create Database Instances on all nodes in the cluster Configure Listener and NetService entries Configure and register CRS resources Start the instances on all nodes in the cluster. What are the prerequisites befo...

alter cluster ALTER CLUSTER pub_cluster SIZE 4K; ALTER CLUSTER pub_cluster DEALLOCATE UNUSED KEEP 1M; alter database: Alter a Data File ALTER DATABASE DATAFILE 4 OFFLINE; ALTER DATABASE DATAFILE '/opt/oracle/datafile/users01.dbf' OFFLINE; ALTER DATABASE DATAFILE '/opt/oracle/datafile/users01.dbf' RESIZE 100m; ALTER DATABASE DATAFILE '/opt/oracle/datafile/users01.dbf' AUTOEXTEND ON NEXT 100M MAXSIZE 1000M; ALTER DATABASE DATAFILE 4 END BACKUP; alter database: Alter a Tempfile ALTER DATABASE TEMPFILE 4 RESIZE 100M; ALTER DATABASE TEMPFILE 4 AUTOEXTEND ON NEXT 100M MAXSIZE 1000M; ALTER DATABASE TEMPFILE 4 DROP INCLUDING DATAFILES; ALTER DATABASE TEMPFILE 4 OFFLINE; alter database: ARCHIVELOG Mode Commands ALTER DATABASE ARCHIVELOG; ALTER DATABASE NOARCHIVELOG; ALTER DATABASE FORCE LOGGING; ALTER DATABASE CLEAR LOGFILE '/opt/oracle/logfiles/redo01.rdo'; ALTER DATABASE CLEAR UNARCHIVED LOGFILE '/opt/oracle/l...