jueves, 30 de agosto de 2012

ARCHIVE ERROR

ALTER SYSTEM ARCHIVE LOG ALL TO '/u02/flash_recovery_area/CHICAGO/archivelog';
System altered.

SQL> archive log list;

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination ?/dbs/arch
Oldest online log sequence 33
Next log sequence to archive 35
Current log sequence 35
SQL> alter system switch logfile;

System altered.

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination ?/dbs/arch
Oldest online log sequence 34
Next log sequence to archive 35
Current log sequence 36
SQL>