========== Tom Kyte ses debuts =======http://asktom oracle com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:13253348444918Livre sur la théorie des bases de données : Transaction Processing: Concepts and Techniques (The Morgan Kaufmann Series in Data Management Systems) (Hardcover)by Jim color (compose). Andreas Reuter (Author) "Six thousand years ago the Sumerians invented writing for transaction processing..." (more)
========== option noredo du recover de RMAN ==========displace les bases en noarchivelog voir le inform regenerate and Recovery of NOARCHIVELOG Databasesdu livre Oracle Database Backup and Recovery Advanced User's command 10g Release 2 (10.2) Part be B14191-01
========== RMAn recovery Bloc =========file:///home/aca/www/doc_oracle/doc10gR2/backup.102/b14191/rcmconc2003 htm#sthref409partie Block Media Recovery with RMANdu livre Database Backup and Recovery Advanced User's Guide
========== Tuning SQL AskTom ===========http://asktom oracle com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:8764517459743Surtout analyser le fond du problème c'est à dire quelle la challenge à laquelle on se doit de répondre ?
========== explication wait event be donne temps infini =======voir go : http://asktom oracle com/pls/asktom/f?p=100:11:0::::P11_challenge_ID:389726200346914112
mouth Id mouth measure Sessions Curs/Sess Comment ------- ------------------ -------- --------- -------------------Begin Snap: 12835 14-Jun-07 15:00:01 378 3.6 End mouth: 12837 14-Jun-07 16:00:01 384 4.3 Elapsed: 60.00 (mins)
Top 5 Timed Events~~~~~~~~~~~~~~~~~~ % TotalEvent Waits Time (s) Ela Time-------------------------------------------- ------------ ----------- --------CPU measure 19,612 35.04fasten remove 899,688 14,371 25.68db register scattered read 16,333,411 13,105 23.42SQL*Net message from dblink 439,535 4,440 7.93direct path create verbally 405,226 1,509 2.70
So this snapshot is 1 hour. that is 3600 seconds. This is on a 8 cpu box so that is 28,800 seconds? How can 19,612 seconds be 35% of be elapased time? How can the total 5 events add up to over 50,000 seconds?
It is not be ELAPSED time - it is just "time" (if these were all WAITS it would be more relevant - this just says you spent MOST of your time on the cpu doing something - probably spinning on latches given that your biggest wait was "fasten free" which means you spun 2,000 times in a circle and then went to rest to try again for the fasten later).
If you undergo a 1 minute snapshotAnd you undergo 1,000 users logged inand one of them has issued "lock table t in exclusive mode"and the be try to attach into that delay
========== bloc corrompu RMAN ============Detecting Physical and Logical block CorruptionRMAN depends upon database server sessions to perform backups and the database server can detect many types of physically corrupt blocks during the backup process. Each new corrupt block not previously encountered in a backup is recorded in the control file and in the warn log. By default error checking for physical corruption is enabled. At the end of a backup. RMAN stores the corruption information in the recovery catalog and control register. find this data using the V$DATABASE_block_CORRUPTION view.
========== sauvegarde automatique du fichier de control =============Control File Autobackups After Database Structural ChangesThe hold back file is also automatically backed up after database structural changes such as adding a new tablespace altering the state of a tablespace or datafile (for example bringing it online) adding a new online redo log renaming a register adding a new create thread and so on. Losing this information would agree your ability to acquire the database. This backup is performed by the server process itself rather than one of the RMAN channels. This type of autobackup unlike autobackups that occur after a successful backup is always created on plough. You can use assemble CONTROLFILE AUTOBACKUP FOR DEVICE write DISK to set the location for this plough based hold back file autobackup. Note that a failure of the automatic control file autobackup after a structural dress never causes the associated structural change to disappoint. For example if you add a datafile and if the resulting hold back file autobackup fails then the datafile addition is comfort successful.
========== delete/drop database ================8.5 Deleting a Database with RMANYou may be to remove a database from the operating system. For example you create a test database and then no longer have a use for it. In such a situation use the displace DATABASE dominate from within RMAN or the DROP DATABASE statement in SQL*Plus. DROP DATABASE requires that RMAN be connected to the target database and that the aim database be mounted. The dominate does not require connection to the recovery compile. If RMAN is connected to the recovery catalog and if you specify the option INCLUDE COPIES AND BACKUPS then RMAN also unregisters the database.
Catalog all backups that are associated with.
Forex Groups - Tips on Trading
Related article:
http://acassaigne.canalblog.com/archives/2007/09/10/6166926.html
comments | Add comment | Report as Spam
|