| Recommend this on Google |
To enable ARCHIVELOG on ASM and configure FLASHBACK (without enabling it) you need to set up the appropriate initialization parameters (db_recovery_file_dest_size, db_recovery_file_dest, db_flashback_retention_target).
SQL>alter system set db_recovery_file_dest_size = '400G' scope=both sid='*'; SQL>alter system set db_recovery_file_dest = '+DATA_RAC3' scope=both sid='*'; SQL> alter system set db_flashback_retention_target = 60 scope=both sid='*'; !1756814646244-a751f918-56ce-410a-bd6b-884e1ce67139.jpg
Then you need to put the database in MOUNT mode; ARCHIVELOG and FLASHBACK mode can be changed only when the database is in the MOUNT state. srvctl stop database -d RAC3 -o immediate srvctl start database -d RAC3 -o mount !1756814646335-2c949278-f2c9-488e-903b-18317c192acc.jpg
To enable ARCHIVELOG and FLASHBACK mode you should issue the following command sql> ALTER DATABASE ARCHIVELOG; sql> ALTER DATABASE FLASHBACK ON; (I didn't issue for my installation)
Then you can open your database and check its status. sql> SELECT LOG_MODE,FLASHBACK_ON FROM V$DATABASE; LOG_MODE FLASHBACK_ON ———— —————— ARCHIVELOG NO (You should see YES) !1756814646413-d906fe60-dee7-4df2-9ed6-1d9ade48aca6.jpg
Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest
| Recommend this on Google |
Etichette: SCHEMA MANAGEMENT