My Learning

Scenario All database files got lost (controlfiles,redo,datafiles), server parameter files is also lost (spfile). The database has to be restored meeting the following conditions After restoring all database files(controlfiles, redolog, datafiles) should have new location Spfile will be residing at  same location. Environment Oracle database 11.2.0.1.0 OEL 5.7 Before Disaster Database files (datafiles,controlfiles,redo) /u01/app/oracle/oradata/orcl spfil $ORACLE_HOME/dbs archive log location /u01/oracle/arch backup controlfile location -/u01/app/oracle/ controlfile autobackup is turned on After recovery spfile same location ($ORACLE_HOME/dbs) databasfiles and controlfiles /u01/oracle/oradata/orcl archive log location /u01/oracle/arch There is a controlfile autobackup and database backup taken sometime before disaster. Restoring and recovering Create new directory structures           cd /u01/oracle           mkdir -p oradata/orcl start

Database Backup and Recovery User's Guide says 'The autobackup occurs whenever a backup record is added. If the database runs in ARCHIVELOG mode, then an autobackup is also taken whenever the database structure metadata in the control file changes " http://docs.oracle.com/cd/E25178_01/backup.1111/e10642/rcmconfb.htm#i1017907 Out of curiosity to see how exactly it works,  just added a tablespace and checked my control file autobackup location to see the auto generated backup of controlfile. When i did 'ls' it was not showing any recent controlfile autobackups. I rechecked all my configuration to make sure all setup is done right. After about 10 minutes i listed again  autobackup location, now i can see a new autobackup file is generated. I spent sometime searching on google to see how long it takes and if the time it takes is configurable. I did not get much on its time lag . Spending sometime on MOS searching for auto controlfile backup generation time

Database  - 11.2.0.1.0 I was wondering how 'archive log list' is showing an archive log destination  without setting any of relevant archive log destination or db recovery parameters. LOG_ARCHIVE_DEST LOG_ARCHIVE_DEST_n DB_RECOVERY_FILE_DEST SQL> archive log list ; Database log mode No Archive Mode Automatic archival Disabled Archive destination /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch Oldest online log sequence 8 Current log sequence 10 SQL> show parameter log_archive_dest; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest string log_archive_dest_1 string SQL> show parameter db_recovery NAME TYPE VALUE