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
Search This Blog
Total Pageviews
Monday, 7 November 2011
Subscribe to:
Post Comments (Atom)
Oracle DBA
anuj blog Archive
- ▼ 2011 (362)
No comments:
Post a Comment