Checking for archive logs

In oracle 10g we can configure 10 archive log destinations and in 11g we can configure 31 archive log destinations.

In oracle 11g Flash Recovery Area is called as "Fast Recovery Area".

 

root> su - oracle

oracle> export ORACLE_SID=hrms

oracle> sqlplus / as sysdba

SQL> startup

SQL> select name,open_mode,log_mode from V$database;

                (or)

SQL> archive log list;

SQL> show parameter db_recovery_file_dest

 

root> su - oracle

oracle> cd /u01/app/fast_recovery/area/

oracle> ls

SQL> conn scott/tiger

scott> insert into salgrade select * from salgrade;

scott>/

                -execute the same many times

scott> commit;

scott> conn / as sysdba

SQL> archive log list;

SQL> show parameter spfile;

SQL> create pfile from spfile;

SQL> shut immediate;