Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

oracle database into archive/noarchivelog mode in RAC environment:



1. Set cluster_database=false for the instance.

alter system set cluster_database=false scope=spfile sid='PROD1';

2. Shutdown all the instances accessing the database.

srvctl stop database -d prod

3. Mount the database using the local instance.

startup mount

4. Enabling archiving / noarchiving

alter database archivelog;

OR

alter database noarchivelog;

5. Change the parameter cluster_database=true for the instance prod1.

alter system set cluster_database=true scope=spfile sid='PROD1';

6. Shutdown the local database.

shutdown

7. Bring up all the instances.

srvctl start database -d prod



5.A) TO START AND STOP THE DATABASE AND INSTANCE IN RAC ENVIRONMENT:

srvctl status database -d prod

Comments

Popular posts from this blog

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

Free VPS Host

PostgreSQL Database startup / shutdown /restart

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory

PostgreSQL pgBadger