Manually start the database archive

Source: Internet
Author: User

-View the instance process to see if there is an archived process [[email protected] ~]$ ps -ef | grep prod4sql>  archive log list;database log mode       no  archive modeautomatic archival       disabledarchive  Destination      /u01/app/oracle/product/11.2.0/db_1/dbs/archoldest online  log sequence     6Current log sequence        8sql> show parameter log_archive--in Mount state-close database Sql> shutdown  immediate        ---must be immediate  one to close the database sql>  startup mountsql> alter system set log_archive_dest_1= ' Location=/home/oracle/arch ' ;  ---Directory to create sql> alter database archivelog;database altered in advance. Sql> alter database open;database&nBsp;altered. sql> archive log list;database log mode        archive modeautomatic archival       enabledarchive  destination       /home/oracle/archoldest online log  sequence     6next log sequence to archive    8current log sequence       8--Generate archive (need to cut redo log) QL> select  group#,member from v$logfile;    group#---------- MEMBER----------------------------------------------------------------------------- 3/u01/app/oracle/ oradata/prod4/prod4/redo03.log 2/u01/app/oracle/oradata/prod4/prod4/redo02.log 1/u01/app/oracle/ oradata/prod4/prod4/redo01.logsql> select group#,status from v$log;     group# status---------- ---------------- 1 inactive 2 current 3 inactive --Cut Redosql> alter system  switch logfile; System altered. Sql> select group#,status from v$log;   group# status----------  ---------------- 1 inactive 2 inactive 3 current--of three states   current &NBSP: Current             active    : Status in the archive,             inactive: Archive complete, unused state  -- View archived files generated under the archive directory [[email protected] ~]$ ls /home/oracle/arch/1_8_861102502.dbf[[email  protected] ~]$ ps -ef | grep prod4oracle    8551      1  0 10:29 ?        00:00:00  ora_arc0_prod4oracle    8554     1 &nBsp;0 10:29 ?        00:00:00 ora_arc1_prod4oracle     8556     1  0 10:29 ?         00:00:00 ora_arc2_PROD4oracle    8558      1  0 10:29 ?        00:00:00 ora_ Arc3_prod4

This article is from the "Yangwang" blog, make sure to keep this source http://yangwang.blog.51cto.com/10855137/1943766

Manually start the database archive

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.