In this Blog you can learn Oracle 11g, 10g, 9i Database Administration and Oracle Developer Suit 6i, 10g, 11g Forms, reports Software Development.
Sunday, 4 September 2016
How to Enable Archive in Oracle 11g Database
SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 4 12:00:26 2016
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 4
Current log sequence 6
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 535662592 bytes
Fixed Size 1375792 bytes
Variable Size 184549840 bytes
Database Buffers 343932928 bytes
Redo Buffers 5804032 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 4
Next log sequence to archive 6
Current log sequence 6
SQL>
Performance Tuning Interview Questions and Answers
performance tuning questions and solutions 1. A tablespace has a table with 30 extents in it. Is this bad? Why or why not? Expected answ...
-
performance tuning questions and solutions 1. A tablespace has a table with 30 extents in it. Is this bad? Why or why not? Expected answ...
-
1) How can you see the Current SCN number of the database? > Select current_scn from v$database; 2) How can you see the Current log...
-
SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 4 12:00:26 2016 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-n...