Search This Blog

Total Pageviews

Monday 7 November 2011

ARCHIVE LOG START is DEPRECATED in Oracle 11g

ARCHIVE LOG START is not valid in Oracle 11g
ARCHIVE LOG START




SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /opt/app/oracle/admin/arch
Oldest online log sequence 79
Next log sequence to archive 81
Current log sequence 81

SQL>
SQL> !mkdir -p /opt/app/oracle/admin/arch1

SQL> !ls -ltr /opt/app/oracle/admin/arch1
total 0

SQL> ARCHIVE LOG START '/opt/app/oracle/admin/arch1' ; ----- will not do any thing in Oracle 11g
Statement processed.


SQL> !ls -ltr /opt/app/oracle/admin/arch1
total 0




SQL> ALTER SYSTEM SET log_archive_dest ='/opt/app/oracle/admin/arch1' ;

System altered.



SQL> !ls -ltr /opt/app/oracle/admin/arch1
total 4
-rw-r----- 1 oracle oinstall 2560 2011-11-07 14:19 1_83_757353423.dbf

No comments:

Oracle DBA

anuj blog Archive