Oracle-RAC
srvctl stop database -d test -o immediate; srvctl start database -d test -o mount;sqlplus
sys/oracle as sysdba
select name,log_mode from v$database;
alter database archivelog;
alter database open;(两个节点都要)
select * from all_users; (两个节点都要)
archive log list;(两个节点都要)
select name from v$archived_log;
desc v$archive_log;
alter system switch logfile;
select name,sequence# v$archive_log; (默认在闪回去)
alter system set log_archive_dest_1='location=c:\oracle\archive1' scope=both(各个节
页:
[1]