| | Adding new datafiles to standby database
If parameter STANDBY_FILE_MANAGEMENT is set to MANUAL in Oracle standby database you may get this error when rolling forward:
Media Recovery Log logfile.arc
File #416 added to control file as 'UNNAMED00416' because
the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL
The file should be manually created to continue.
Errors with log logfile.arc
Some recovered datafiles maybe left ... | |  
More...
06/22/06 | | | | | | | | |
|
|
| | Script to view URLs through HTTP proxy server
This PHP function allows to view / download contents from websites on the Internet through a proxy server, with or without proxy authentication. If no username / password supplied to the function it will assume that proxy server does not require authentication.
| | More...
06/07/06 | | | | | | | | |
|
|
|
|
| | Generate drop schema indexes script
I use the below script to drop indexes before running complete refresh in Oracle database. Before dropping the indexes I run export without rows so that indexes can be re-created (get sql script from export dump) after snapshots have been refreshed.
--
-- Replace USERNAME with the actual username
--
set head off pagesize ... | | More...
05/10/06 | | | | | | | | |
|
| | Example exp parfile for Oracle full export
Here's an example of parfile for exporting the whole database without data (no rows):
FILE=DBNAME.dmp
COMPRESS=N
ROWS=N
LOG=DBNAMEexp.log
FULL=Y
Run from command line:
$ . oraenv
$ ORACLE_SID = [DBNAME] ?
$
$ exp parfile=DBNAMEexp.par
Export: Release 8.1.7.4.0 - Production on Wed May 10 10:20:48 2006
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Username: / as sysdba
| | 
More...
05/10/06 | | | | | | | | |
|
| | List all database links
Show all db links in Oracle database.
--
-- I'm sick and tired of typing this almost every day, so here we go, from now on
-- I will just copy and paste. Hope this may be useful for others too.
--
col OWNER format a12
col DB_LINK format a12
col USERNAME format a12
col HOST format a12
select ... | |
More...
05/10/06 | | | | | | | | |
|
| | Script to generate creation of snapshots
Generate Oracle snapshots using the script below. It will check tablespaces for materialized view logs and place the snapshots in the appropriate tablespaces (if you follow the Oracle's recommendation to use different tablespaces for differently sized segments). This script is to be run on spanshotlog site.
set head off verify off ... | | More...
05/04/06 | | | | | | | | |
|
<< 1 | 2 | 3 | 4 | 5 | 6 | 7 | Page 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 >>
|
