Oracle archiving and Flash back switches

First, the archived switch

1. Check if the archive is open:

sql> archive log list;

2. Set the archive path

Sql> alter system set log_archive_dest_1= ' LOCATION=D:\ARCH2 ';

3. Open Archive

sql> shutdown immediate; --Close the database

sql> startup Mount; --Boot to Mount state

sql> ALTER DATABASE Archivelog; --Open Archive

sql> ALTER DATABASE open; --Open Database

4. Close the Database archive

sql> shutdown immediate;

sql> startup Mount;

sql> ALTER DATABASE Noarchivelog;

sql> ALTER DATABASE open;

Second, the flash back area of the switch

1. Check if the Flash back zone is open

Sql> select flashback_on from V$database;

2, set the size of the flash recovery area

Sql> alter system set db_recovery_file_dest_size=30g Scope=both;

3. Set the Flash Recovery zone path

Sql> alter system set db_recovery_file_dest= '/u01/flashback ' Scope=both;

4. Turn on flash back

sql> shutdown immediate;

sql> startup Mount;

Sql> ALTER DATABASE flashback on; --Turn on flash back

sql> ALTER DATABASE open;

5. Turn off flash back

Sql> ALTER DATABASE flashback off;

This article is from the "Luoyangzhigui" blog, make sure to keep this source http://luoyangzhigui.blog.51cto.com/9207064/1793622

Oracle archiving and Flash back switches