Shulou(Shulou.com)06/01 Report--

1. Check whether archiving is enabled in the database (check whether archiving logs are enabled on the two nodes rac1 and rac2)

SQL > archiveloglist

SP2-0734: unknown command beginning "archivelog..."-rest of line ignored.

SQL > archive log list

Database log mode No Archive Mode

Automatic archival Disabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 7

Current log sequence 8

SQL >

two。 Setting in Node 1 (rac1) modifies only the parameters of Node 1 and does not affect Node 2.

SQL > alter system set cluster_database=false scope=spfile sid='racdb1'

System altered.

SQL >

3. Use the srvctl command to shut down the database on node 1 (rac1)

[oracle@rac1] $srvctl stop database-d racdb

4. Mount the database and modify the log to archive

SQL > startup mount

SQL > alter database archivelog

SQL > alter system set cluster_database=true scope=spfile sid='racdb1'

SQL > shutdown immediate

5. Start the database

[oracle@rac1] $srvctl start database-d racdb

6. Check the modified archive information

SQL > archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 9

Next log sequence to archive 10

Current log sequence 10

SQL >

7. Check to see if flashback is enabled in the database

Node 1 (rac1):

SQL > select flashback_on from vault database;-- Archive must be enabled first.

FLASHBACK_ON

-

NO

SQL >

8. Set the path and size of the flashback

SQL > alter system set cluster_database=false scope=spfile sid='racdb1'

SQL > alter system set db_recovery_file_dest='+FALSE' scope=spfile

SQL > alter system set db_recovery_file_dest_size=5G scope=spfile

9. Shut down the database

[oracle@rac1] $srvctl stop database-d racdb

10. Enable flashback

SQL > startup mount

SQL > alter database flashback on

SQL > alter system set cluster_database=true scope=spfile sid='racdb1'

SQL > shutdown immediate

11. Start the database

[oracle@rac1] $srvctl start database-d racdb

twelve。 View flashback featur

SQL > select flashback_on from v$database

FLASHBACK_ON

-

YES

SQL >

13. Tablespace flashback can also be enabled

SQL > alter tablespace abc flashback on;-- enable tablespace flashback

SQL > alter tablespace abc flashback off;-- turn off tablespace flashback

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.