Thursday, 25 July 2019

Change No archivelog to Archive log in Rac

srvctl stop database -d TEST

srvctl start database -d TEST -o mount


SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            +RECO_DG01
Oldest online log sequence     9
Current log sequence           12
SQL>  select instance_name,status from gv$instance;

INSTANCE_NAME    STATUS
---------------- ------------
TEST1          MOUNTED
TEST2          MOUNTED

SQL> alter database archivelog;

Database altered.

[oracle@OMPR preupgrade]$ srvctl stop database -d TEST
[oracle@OMPR preupgrade]$ srvctl start database -d TEST

SELECT log_mode FROM gv$database;

No comments:

Post a Comment

Featured post

Restircted session due to sync filed with ora-65177

Application is unable to connect the database due to restricted session. sql> show pdbs; SQL> show con_name CON_NAME -----------------...