数据库|mysql教程
oracle,Oracle 10备份与恢复之归档模式配置 –
数据库-mysql教程
from表单验证源码之家,UBUNTU系统小说文案,tomcat一般用户数多少,java实现爬虫抓取,php大作业潮牌系统打码,南昌seo计费lzw
文章的前面回把开启归档模式及设置归档日志格式等内容放到前面,便于查阅及理清思路。后面会对每一部都进行详细的描述 SQLgt; a
个人qq业务网站源码,如何修改vscode提示颜色,solr ubuntu,tomcat资源监控,sqlite存温度,网页设计布局图,服务器和数据库关系,ckeditor 代码插件,前端框架t,爬虫集合网,php逻辑,大连seo怎样,springboot映射资源,微网站 小程序,微博网页模板下载,织梦更改文章模板,织梦后台500错误,百度的页面代码是什么,开源批发管理系统,简单的聊天室程序lzw
热血传奇手机版免费源码,ubuntu命令安装汉语,如何伪造爬虫mac,php forach,寮步seolzw
文章的前面回把开启归档模式及设置归档日志格式等内容放到前面,便于查阅及理清思路。后面会对每一部都进行详细的描述
SQL> archive log list //查看当前归档模式
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence3
Current log sequence 5
开启归档模式
SQL> shutdown immediate
Database closed.
Database dismounted.
Oracle instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 832 bytes
Variable Size 222298704 bytes
Database Buffers385875968 bytes
Redo Buffers2170880 bytes
Database mounted.
SQL> alter database archivelog; //开启归档模式
Database altered.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence3
Next log sequence to archive 5
Current log sequence 5
修改归档日志存放地
SQL> alter system set db_recovery_file_dest=‘’;
System altered.
SQL> alter system set log_archive_dest=‘/home/oracle/backup’;
System altered.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /home/oracle/backup
Oldest online log sequence3
Next log sequence to archive 5
Current log sequence 5
注:
从oracle10g开始默认情况下,归档日志会存放到快速恢复区所对应的目录(对应于初始化参数db_recovery_file_dest)并且会按照特定的格式生成归档日志文件名,如果我们不修改db_recovery_file_dest=‘’为空,,而直接指定log_archive_dest的路径则会报错。如下:
SQL> alter system set log_archive_dest=’/home/oracle/backup’;
alter system set log_archive_dest=’/home/oracle/backup’
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or
DB_RECOVERY_FILE_DEST
SQL> alter system set log_archive_format=’ARC%S_%R.%T.arc‘ scope=spfile;
System altered.
SQL> alter system switch logfile; //日志格式的修改仍然没有生效,尝试重启数据库使之生效,生成.arc结尾的文件
System altered.
SQL> alter database open;
Database altered.
SQL> alter system switch logfile; //手工切换,目的是产生归档日志,在backup目录下查看生成的文件
System altered.
cd /home/oracle/backup
$ ls
1_5_736446919.dbf 1_6_736446919.dbf 1_7_736446919.dbf ARC0000000008_0736446919.0001.arc