Brian Peasland Database administrator - SearchOracle SearchOracle Performing backups with Oracle RAC and ASM 24 May 2007 SearchOracle Syntax for export utility in Oracle 9i 24 May 2007 SearchOracle Interview questions about managing an Oracle database 24 May 2007 SearchOracle Is my database using SPFILE or PFILE? 16 May 2007 SearchOracle Running out of space for backups, archive logs 19 Apr 2007 SearchOracle No such file or directory error 11 Apr 2007 SearchOracle "Delete from emp" without "where" condition 11 Apr 2007 SearchOracle How to attach Oracle database backup files to existing server 11 Apr 2007 SearchOracle Recover database using backup controlfile until cancel 22 Mar 2007 SearchOracle Check current SCN in control file 22 Mar 2007 SearchOracle Backup and recovery strategy for very large databases 22 Mar 2007 SearchOracle Redo log file filled up 22 Mar 2007 SearchOracle IMP-00009 and IMP-00028 errors during import 22 Mar 2007 SearchOracle Definitions of checkpoint, PMON and SMON 27 Feb 2007 SearchOracle Backup strategy for 1TB database 27 Feb 2007 SearchOracle Difference between migration and upgrade 27 Feb 2007 SearchOracle Migrating database from Solaris to Linux 12 Feb 2007 SearchOracle Levels for incremental backups in RMAN 12 Feb 2007 SearchOracle Creation of lksid file in Linux 30 Jan 2007 SearchOracle Reading SPFILE 30 Jan 2007 SearchOracle Importing .dmp file to database 30 Jan 2007 SearchOracle Copying database structure without data 12 Jan 2007 SearchOracle ORA-00980: synonym translation is no longer valid 15 Dec 2006 SearchOracle Error with RMAN cold backup 06 Dec 2006 SearchOracle SP2-0734 error during import 06 Dec 2006 SearchOracle ORA-01116 error 06 Dec 2006 SearchOracle Hardware requirements for RMAN 13 Nov 2006 SearchOracle Can't start up database without error ORA-01110 13 Nov 2006 SearchOracle Forcing a user to reset password 03 Nov 2006 SearchOracle "Only a DBA can import a file exported by another DBA" error 23 Oct 2006 SearchOracle Recovering system datafile without backup 23 Oct 2006 SearchOracle Taking full backup with Toad 02 Oct 2006 SearchOracle Error with VERITAS NetBackup for Oracle 15 Sep 2006 SearchOracle Fixing internal error code without much downtime 07 Sep 2006 SearchOracle ORA-00942: table or view does not exist 07 Sep 2006 SearchOracle Recovering crashed database with corrupted undo tablespace 07 Sep 2006 SearchOracle Exporting selected procedures and functions in Oracle 28 Aug 2006 SearchOracle Unwrapping encrypted procedure in Oracle 28 Aug 2006 SearchOracle Unix script to create database export via crontab 28 Aug 2006 SearchOracle Opening recovered database with UPGRADE option 28 Aug 2006 SearchOracle Command to open database with missing datafile 28 Aug 2006 SearchOracle Restoring an Oracle backup to a new Windows server 09 Aug 2006 SearchOracle ORA-12528 error 09 Aug 2006 SearchOracle Moving Oracle folder to external hard drive 31 Jul 2006 SearchOracle Ratio for SGA and database size 19 Jul 2006 SearchOracle Command to increase size of datafile 19 Jul 2006 SearchOracle Errors with select query on dblink 19 Jul 2006 SearchOracle Importing table structure only to new schema 19 Jul 2006 SearchOracle Copying selected tables from one user to another 10 Jul 2006 SearchOracle How does SMON know to perform a crash recovery? 10 Jul 2006 SearchOracle Importing Oracle data from Unix to Windows 03 Jul 2006 SearchOracle Necessary to back up UNDO tablespace? 03 Jul 2006 SearchOracle ORA-01078: failure in processing system parameters 16 Jun 2006 SearchOracle Consistent vs. inconsistent backup 16 Jun 2006 SearchOracle Recovering .dbf files without .dmp files 06 Jun 2006 SearchOracle Where is the SCN number written? 15 May 2006 SearchOracle ORA-2264 error when importing data 15 May 2006 SearchOracle Steps to recover with cold backup 08 May 2006 SearchOracle How do DML transactions affect redo log buffer? 08 May 2006 SearchOracle Import terminated successfully with warnings 19 Apr 2006 SearchOracle Comparison of RMAN and SQL-BackTrack 19 Apr 2006 SearchOracle RMAN-10038 error 19 Apr 2006 SearchOracle Where to write the imp command? 05 Apr 2006 SearchOracle Copying stored procedures to another database 20 Mar 2006 SearchOracle Recovering schema(user) using RMAN level 0 backup 20 Mar 2006 SearchOracle Memory leak with open cursor 14 Mar 2006 SearchOracle Copying all objects to another user 08 Mar 2006 SearchOracle Taking backup on Unix and restoring to Windows or Linux 09 Feb 2006 SearchOracle Difference between RMAN and traditional backup methods 09 Feb 2006 SearchOracle Export/import on table with clob datatype column 31 Jan 2006 SearchOracle Possible to recover datafile without backup? 31 Jan 2006 SearchOracle "Resource busy" error when truncating table 31 Jan 2006 SearchOracle Can we restore archive logs to a cold backup? 31 Jan 2006 SearchOracle Backing up online redo log files? 31 Jan 2006 SearchOracle Third-party tools for RMAN backups 31 Jan 2006 SearchOracle Necessary to take a cold backup of a temporary tablespace? 09 Jan 2006 SearchOracle Easy way to import public synonyms? 09 Jan 2006 SearchOracle How many types of backups are there? 09 Jan 2006 SearchOracle Query for locally managed vs. dictionary-managed tablespace 09 Jan 2006 SearchOracle Difference between RBO and CBO 02 Dec 2005 SearchOracle Moving archive log files from primary to standby database 02 Dec 2005 SearchOracle Extracting dump files into text format 19 Oct 2005 SearchOracle Using dblink to access a different server 19 Oct 2005 SearchOracle Importing a trigger from another schema 19 Oct 2005 SearchOracle Cloning a database without changing DBID 19 Oct 2005 SearchOracle Creating a database clone from a cold backup 05 Oct 2005 SearchOracle Cause of ORA-06550 error 26 Sep 2005 SearchOracle Exporting a column from a table for later import 22 Sep 2005 SearchOracle User session blocking other sessions 22 Sep 2005 SearchOracle Deleting expired backups on tape 07 Sep 2005 SearchOracle Errors during import of a dump file 07 Sep 2005 SearchOracle Performing a hot backup with RMAN 07 Sep 2005 SearchOracle Database crash during hot backup 22 Aug 2005 SearchOracle Installing 32-bit and 64-bit Oracle on same machine 22 Aug 2005 SearchOracle Receiving ORA-313 and ORA-312 errors when trying to open database 08 Aug 2005 SearchOracle Removing blank lines from a text file 08 Aug 2005 SearchOracle Finding the SCN in the Alert Log 08 Aug 2005 SearchOracle Clearing the rollback segment from a tablespace 26 Jul 2005 SearchOracle Minimizing archive log generation 24 Jun 2005 SearchOracle Importing from split export files 24 Jun 2005 1 2 3