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

PostgreSQL pgBadger

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

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 Installation On Linux

PostgreSQL Database startup / shutdown /restart