oracle如何切换模式

ORACLE如何切换到用户需要的数据库?

oracle数据库如何切换模式

oracle dg 三大模式切换

①.、最大性能模式MAXIMUM PERFORMANCE --默认模式,最大性能模式特点.

SQL?select?database_role,protection_mode,protection_level?from?v$database;

DATABASE_ROLE?PROTECTION_MODE?PROTECTION_LEVEL

----------------?--------------------?--------------------

PRIMARY??MAXIMUM?PERFORMANCE?MAXIMUM?PERFORMANCE

SQL?select?dest_name,status?from?v$archive_dest_status;

DEST_NAME??STATUS

-------------------------?---------

LOG_ARCHIVE_DEST_1?VALID

SQL?show?parameter?log_archive

NAME????TYPE?VALUE

------------------------------------?-----------?---------------------------

log_archive_config??string?dg_config=(orcl,db01)

log_archive_dest_1??string?location=/home/oracle/arch_orc

l?valid_for=(all_logfiles,all_

roles)?db_unique_name=orcl

id_for=(online_logfiles,primar

y_roles)?db_unique_name=db01

SQL?archive?log?list

Database?log?mode??Archive?Mode

Automatic?archival??Enabled

Archive?destination?/home/oracle/arch_orcl

PHYSICAL?STANDBY?MAXIMUM?PERFORMANCE?MAXIMUM?PERFORMANCE

log_archive_config??string?dg_config=(db01,orcl)

log_archive_dest_1??string?location=/home/oracle/arch_db0

①.?valid_for=(all_logfiles,all_

roles)?db_unique_name=db01

y_roles)?db_unique_name=orcl

SQL?alter?system?switch?logfile;

Archive?destination?/home/oracle/arch_db01

Next?log?sequence?to?archive?0

SQL?select?DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL?from?v$database;?

SQL?shutdown?immediate

SQL?alter?database?recover?managed?standby?database?cancel;

SQL?startup?mount;

SQL?alter?database?set?standby?database?to?maximize?availability;

SQL?startup?nomount

SQL?alter?database?mount?standby?database;

SQL?startup

d_for=(online_logfiles,primary

_roles)?db_unique_name=db01

SQL?select?database_role,protection_level,protection_mode?from?v$database;

DATABASE_ROLE?PROTECTION_LEVEL?PROTECTION_MODE

PRIMARY??MAXIMUM?AVAILABILITY?MAXIMUM?AVAILABILITY

_roles)?db_unique_name=orcl

PHYSICAL?STANDBY?MAXIMUM?AVAILABILITY?MAXIMUM?AVAILABILITY

SQL?alter?database?set?standby?database?to?maximize?protection;

PRIMARY??MAXIMUM?PROTECTION?MAXIMUM?PROTECTION

3ORACLE数据库日志有哪几种模式,如何在不同模式中切换?

有两种模式：

一：日志模式,日志模式的设置分为Archive

Mode和No

Archive

Mode.

二：自动归档模式：自动归档模式的设置分为：Enabled和Disabled

可用可用archive

log

list命令来查看数据库的现行日志和自动归档模式的设置.

希望对你有帮助.

以上就是土嘎嘎小编为大家整理的oracle如何切换模式相关主题介绍,如果您觉得小编更新的文章只要能对粉丝们有用,就是我们最大的鼓励和动力,不要忘记讲本站分享给您身边的朋友哦！！