|
||||
|
Originally posted here, http://hemantoracledba.blogspot.in/2013/02/backup-and-recovery-with-intermediate.html Asked why the incremental backup fails oracle@linux64 ~]$ rman target / Recovery Manager: Release 11.2.0.1.0 – Production on Thu Feb 7 21:30:18 2013 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL (DBID=1229390655) RMAN> backup database plus archivelog; Starting […] Hello, Thanks to my colleague (Naga) for this information, We have got a question from another friend on how to find the export dump file whether its belongs to export (exp) or datapump export(expdp). The question is “I am planning to import the dump to a new database but I am confused by seeing the […] 1. What are Oracle enqueues? Oracle enqueues are locks at database level that coordinate parallel access to Oracle resources such as objects or data records. For example, enqueues are responsible for several transactions not being able to change the same data record at the same time.Enqueue requests are divided into queues whose requests are then […] Consider this scenario (as explained by My colleague for his requirement, Thanks Rambo) Source database: Tablespace T1 created with locally managed tablespace with auto segment space management. Destination Database: Tablespace T1 created with locally managed tablespace with uniform extent allocation. Read carefully the underline parts, Now If I import this tablespace T1 into the Destination […] Hello, Here is one the knowledge share that has been posted by Sarma. Many thanks to him for his enthusiastic contribution. ORA-00600: internal error code, arguments: [kcratr1_lostwrt].
As per 351678.1, the last block written was lost when the instance crashed. On startup, Oracle checks the last version of the block written to disk; […] Thanks to my friend (Siva Krishna) who updated me to post this in blog, If session performing online index rebuild will be killed by mistake Oracle end up with some inconsistency inside dictionary. If you try to re-run killed command to create index once more database will complain that index already exist. Although […] Came across one good note [1079563.1] on mixed platforms backup/restore/recovery things. This is especially beneficial than long process of export/import or transport tablespaces. you Just fire the duplicate database and then done. The note say’s Mixed platforms are supported for the following types of backups:- + Active Database DUPLICATE + Backup-based DUPLICATE using image copies […] Does flashback logs generates even if the flashback option is disabled? Answer: Yes, when you have guaranteed restore point exists in your database. No, if you does not have guaranteed restore point. Please read further. SQL> select log_mode,flashback_on from v$database; LOG_MODE FLASHBACK_ON ———— —————— ARCHIVELOG NO SQL> […] In Oracle 11gR2 11.2.0.2 there is a new clause added to the truncate table SQL statement allowing to release the space allocated even for extents corresponding to the minextents storage clause. Prior to 11.2.0.2 truncate table statement with its different flavor of clauses was used to delete all the rows from the table and possibly […] Hello All, One of our fellow DBA posted me this link about disk basics and disk partitioning in solaris servers. Thanks to him (Shiva Krishna) Nice video. Thanks to the author. Hope this helps you all to understand the basics of disk management. [youtube=http://www.youtube.com/watch?v=HExfJZ_Qd3Y] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!