I've just found out that 12cR1 will not (in all likelihood) allow "flashback database" for pluggable DBs. Am I the only one disappointed by that ? I use flashback db (+replay) a lot to revert and replay automated tests and I had plans to consolidate tenths of test environments into PDBs.
We've all heard the news about the new 12c capability to have a container database hosting multiple pluggable database instances.
This obviously will provide significant reduction in overhead on systems (like Exadata) where we'd like to host multiple databases, but can't consolidate them due to conflicts that prevent them running under the same instance (public synonyms / dblinks, schema name collision, etc). Not to mention the effort required to get different application databases to co-exist on the same DB instance ... which in and of itself can be a major project.
My question - does the container database need to have the same character set as the pluggable databases?
If not, this still presents a limitation, as there are numerous vendors of COTS applications that don't (or won't) support ALT32UTF8, which is what we're building all our bespoke applications on.
I have the task to migrate the total databases(Exact copy to be moved to another server).The current server is going for format.After I did the following steps I am getting the tablespaces(databases)-4 sizes same ,but I am facing issue like some default tablespaces i.e temp,system are not matching.
temp tablespace *************** current server - 4.0(approximately) Migrating server - 160 MB
System tablespace ***************** current server - 580 MB Migrating server - 220 MB
Also I checked the tables are also matching for the 4 databases.Also Provide the solution or method which is correct.
steps done for migrating(By me) ******************************** EXPORTING DATA USING DATAPUMP *********************************
1 From command prompt MKDIR 'c:oraclexeapp mp';
2 From SQL prompt conn system/kotak;
3 create or replace directory dmpdir as 'c:oraclexeapp mp';
4 grant read,write on directory dmpdir to kotak;
5 From command prompt
expdp system/kotak@xe full=Y directory=dmpdir dumpfile=xe.dmp logfile=expdpxe.log; IMPORTING DATA USING DATAPUMP ***************************** in another server machine
1 From SQL prompt conn system/kotak;
2 create or replace directory dmpdir as 'c:oraclexeapp mp';
I would like to know about oracle 12c. In 12c, when i read documents,i understood that one container DB(CDB) can contain upto 253 pluggable DB and this pluggable DB(PDB) is similar to our traditional database(pre 12c).
1) whether my existing database (11.2.0.3) can be upgraded as pluggable DB and plugged it in CDB?
2)i read that we can move from local data center model to cloud in this version. Is that mean that once PDB is ready, whether we can plug it in CDB using private cloud or public also possible?
3)If public cloud is possible, are both CDB and PDB accessed through cloud client only?If so, whether our user data that is available under PDB also moved to external place?
Can I use flashback in application, especially DBMS_FLASHBACK.TRANSACTION_BACKOUT. I import some information (from files) in my database and after that I want to revert that transaction(delete imported data). I did some test I took xid of the transaction from v$transaction and then executed
DBMS_FLASHBACK.TRANSACTION_BACKOUT
with that XID for parameter. Everything is fine but that time there was only one transaction, when there are many transaction how can I get the exact XID. I can use dbms_transaction.local_transaction_id to get information for transaction which is running. And when i tried to use flashback that way a deadlock occur and db killed the other transaction.
13:02:08 SQL> drop table hello_world; Table dropped.;
then i have to connect with sys user
13:03:03 SQL> conn sys as sysdba Enter password: 13:08:21 SQL> select current_timestamp from dual; CURRENT_TIMESTAMP --------------------------------------------------------------------------- 13-MAY-11 01.10.21.691000 PM +05:30
[code].....
i flashback my this HELLO_WORLD table but why i cannot Flashback RAW of this table .what can i do if i want to flashback raw of this table which query i have to run,
I need store history for two tables in my system. I thought that Flashback Data Archive will be the best option. There is also another ways to do this but don't focus on this. I need to to this by FDA (Flashback Data Archive);
So my prerequisite was to create tablespace and flash back archive, and alter table to be archived.
alter table teta_admin.t_prac flashback archive audit_flash_archive;
and everything works fine but on sys user. i can query this table using "as of timestamp" clause
select prac_id, imie, imie_2, nazwisko, nr_ew from teta_admin.t_prac as of timestamp to_timestamp('2011-08-23 08:20:00','yyyy-mm-dd hh24:mi:ss')
but final construction of idea was to create additional user (interface), grant select on teta_admin.t_prac object and query archive data from interface user. and this is point of my failure. this don't work on new user.
interface user have such sys privs:
SQL> SELECT * FROM dba_sys_privs 2 WHERE grantee = 'INTERFACE'; GRANTEE PRIVILEGE ADM ------------------------------ ---------------------------------------- --- INTERFACE CREATE SESSION NO
and table privs:
SQL> SELECT * FROM dba_tab_privs 2 WHERE grantee = 'INTERFACE';
SYS@boston>select name, value, issys_modifiable from v$parameter where name='db _recovery_file_dest_size';
NAME -------------------------------------------------------------------------------- VALUE -------------------------------------------------------------------------------- ISSYS_MOD --------- db_recovery_file_dest_size 9663676416 IMMEDIATE
I have read it in books that flashback uses undo data to create the flashback data or to flashback the database to a time in the past.Then, what is the role of archive files in flashback operation. Why it is mandatory to turn on archiving before turning on flashback. Also, if you remove the latest archive files, you can NOT flashback the data to a time in past (Oracle complains of missing archive files).
My Data Guard 's Enviroment: Primary: 11.1.0.7 RAC 2 Nodes Standby: 11.1.0.7 Single Instance
I want to implement Fast-Start Failover at my enviroment. Reading requirements, I found that Oracle Flashback is needed (I don't use Flashback on my databases).
Best Practices recommends 60 min (1 hr) for DB_FLASHBACK_RETENTION_TARGET if I just want to use Flashback to fast-start failover.
My questions:
What 's better, setup up flash recovery area on ASM or O.S. filesystem? What is the recommended size for flash recovery area?
Is there anyway to backup Flashback Data Archive (FBDA) data and can be restore on new database. I cannot find Oracle's document or any document explain about backing up this data.
If flashback is enable in physical standby database 1. If we failover at 11AM can I flash back NEW primary database to 6 AM ? 2. if I convert physically standby database to snapshot standby database at 11AM , Can I flashback snapshot standby database to 6 AM and do some works on it (DML operations) then converting the snapshot standby database into physical standby database ?
The undo_retention is used for read consistency, to avoid snapshot too old.Flashback database is using files in the db_recovery_file_dest.But whether undo_retention has any influence on Flashback drop; Flashback table or Flashback query?Let's say we have set undo_retention = 3600 = 1 hour.And
db_flashback_retention_target = 1440 = 24 hours.
Will it work Flashback drop; Flashback table; Flashback query to get 12 hours back?Additional question. Why Oracle sets undo_retention in seconds and db_flashback_retention_target in minutes?To use the same measure would be more user-friendly to DBAs .
In my company we have few 10.2.0.2 databases and few 10.2.0.4 databases.Currently we are monitoring using OEM 10g (10.1.0.5.0) installed on a seperate server.
Planning to install OEM on a new server as part of server room renovation. let me know the process of installing OEM on a different server without loosing the historical data?Also wondering if the OEM 11g will support the current databases?
We are getting a consultant to upgrade an Oracle 9i installation to 11g R2. The current installation has 6 different databases installed on the same server. Each database is a different customer so for reasons of security we have requested that this be split into 6 virtual machines with one database per machine.
The consultant suggested that they could install the 11g database once and then just make copies (which would all have the same instance name. We are told that the TNS names can be configured so clients are directed to the right database.