查看归档模式
SQL> archive log list
SQL> archive log list
修改归档模式
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open;
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open;
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 130
Next log sequence to archive 132
Current log sequence 132
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 130
Next log sequence to archive 132
Current log sequence 132
SQL> alter system archive log current;
查看归档日志的存放位置
SQL> show parameter db_recovery_file_dest
查看归档日志的存放位置
SQL> show parameter db_recovery_file_dest
SQL> select name from v$archived_log;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24756186/viewspace-742660/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24756186/viewspace-742660/