Tags » 11g

Archive Logs in $ORACLE_HOME/dbs

This has been happening over the years but I couldn’t figure out why….finally found this article on My Oracle Support (MOS):  Setup Local archiving on standby to Prevent Logs sent to $ORACLE_HOME/dbs (on both GRID and SQLPLUS) (Doc ID 1271095.1) 204 more words

Data Pump or Data Pain Part03 – user/db object

You might be thinking, why is it necessary to specify schemas versus perform full import or why create SQL file?

$ cat impdp_full02_user.par

directory=DATA_PUMP_DIR
userid="/ as sysdba"
metrics=Y
dumpfile=full.dmp
logfile=impdp_full_user.log
schemas=GGS_ADMIN,DEMO
include=USER
sqlfile=user.sql
…
1,192 more words
11g

Data Pump or Data Pain Part02 - tablespace/user

This is still all WIP and if you stay with me, I will provide all the sequences for export and import.

Too much info put in one post. 776 more words

11g

Data Pump or Data Pain

WARNING: Rants ahead.

Simple request migrate schema from one database to another, right?

Create new database, perform schema export and import; this only works if objects are self contained. 3,290 more words

11g

Renew BAM demodata

Recently I did a POC with BAM 12c at the customer. In a series of post’s I will describe my findings/experiences.
In the first post of this series I described the initial situation ( 450 more words

11g

Dataguard

1.Introduction
Oracle Dataguard provides data protection,high availability ad distater recovery solutions.in this setup u can have more that one standby database for a primary database.The standby database can be working as primary database if primary database is in planned or unplanned outage. 280 more words
11G