查看数据库现有模式
方法一:
SQL> select name,log_mode from v$database;
NAME LOG_MODE
--------- ------------
ORCL NOARCHIVELOG
方法二:
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 112
Current log sequence 114
开启归档模式先确定归档日志的路径
先用oracle创建目录
[oracle@oracle ~]$ mkdir arch1
[oracle@oracle ~]$ cd arch1/
[oracle@oracle arch]$ pwd
/home/oracle/arch1
查看下archive参数
SQL> show parameter archive
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
log_archive_config string
log_archive_dest string
log_archive_dest_1 string
.
.
.
指定一个归档路径
SQL> alter system set log_archive_dest_1='location=/home/oracle/arch1';
System altered.
也可以再指定一个归档路径
SQL> alter system set log_archive_dest_2='location=/home/oracle/arch2';
System altered.
切换当前归档日志
SQL> alter system archive log current;
方法一:
SQL> select name,log_mode from v$database;
NAME LOG_MODE
--------- ------------
ORCL NOARCHIVELOG
方法二:
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 112
Current log sequence 114
开启归档模式先确定归档日志的路径
先用oracle创建目录
[oracle@oracle ~]$ mkdir arch1
[oracle@oracle ~]$ cd arch1/
[oracle@oracle arch]$ pwd
/home/oracle/arch1
查看下archive参数
SQL> show parameter archive
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
log_archive_config string
log_archive_dest string
log_archive_dest_1 string
.
.
.
指定一个归档路径
SQL> alter system set log_archive_dest_1='location=/home/oracle/arch1';
System altered.
也可以再指定一个归档路径
SQL> alter system set log_archive_dest_2='location=/home/oracle/arch2';
System altered.
关闭数据库 并启动到mount状态:
SQL> shutdown immediate
SQL> startup mount;
修改数据库为归档模式:
SQL> alter database archivelog;
打开到open并查询
SQL> alter database open;
切换当前归档日志
SQL> alter system archive log current;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27500440/viewspace-1102641/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27500440/viewspace-1102641/