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;
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