Home > Database > Mysql Tutorial > 归档日志

归档日志

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-07 16:05:22
Original
1514 people have browsed it

RAC sqlplus / as sysdba SQL alter system set cluster_database=false scope=spfile; --in node1 SQL create pfile='/opt/oracle/pfile_20120301' from spfile; --in node1 SQL alter system set log_archive_format='ora11g_%r_%t_%s.log' scope=spfile;

RAC
sqlplus / as sysdba
SQL> alter system set cluster_database=false scope=spfile; --in node1
SQL> create pfile='/opt/oracle/pfile_20120301' from spfile; --in node1
SQL> alter system set log_archive_format='ora11g_%r_%t_%s.log' scope=spfile; --in node1, using default value is ok
SQL> alter system set log_archive_start=TRUE scope=spfile; --in node1
SQL> alter system set log_archive_dest='' scope=spfile; --in node1
SQL> alter system set log_archive_dest_1='LOCATION=/oracle/ora_arch' scope=spfile; --in node1 using the specificated DIR
SQL> shutdown immediate; --two nodes
SQL> startup mount; --in node1
SQL> alter database archivelog; --in node1
SQL> alter database open; --in node1
SQL> alter system set cluster_database=true scope=spfile; --in node1
SQL> shutdown immediate; --in node1
SQL> startup; --in two nodes

NORAC
sqlplus / as sysdba
SQL> create pfile='/opt/oracle/pfile_20120301' from spfile;
SQL> alter system set log_archive_format='ora11g_%r_%t_%s.log' scope=spfile; --using default value is ok
SQL> alter system set log_archive_start=TRUE scope=spfile;
SQL> alter system set log_archive_dest='' scope=spfile;
SQL> alter system set log_archive_dest_1='LOCATION=/oracle/ora_arch' scope=spfile; --using the specificated DIR
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database archivelog;
SQL> alter database open;
SQL> archive log list;

Related labels:
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template