-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
If one is keeping archive logs available on disk and also have them archived to tape and would like to… READ MORE
Using the following rman command one can setup to keep 2 days of archive log on disk and also archive… READ MORE
Using the steps below one can find the object that is unrecoverable from UNRECOVERABLE_CHANGE# in the v$datafile, one would use… READ MORE
Using the following query one can find the datafiles that had nologging turned on, direct load or unrecoverable option was… READ MORE
If one needs to restore archive logs to disk and not apply them, for example in case when cloning a… READ MORE
This script will delete files modified more than 14 days ago and have file name that begin with daily_backup ,… READ MORE
This parameter controls the format of the archive log file name. This parameter can’t be changed on the fly therefore… READ MORE
Using the following steps one can clone a database manually. In the following example PRD represents the source and DEV… READ MORE
As part of the RMAN script during backup to disk for example you may have a statement to delete the… READ MORE
|
Using block tracking one can improve performance of the backup time of incremental backup from hours to minutes depending on… READ MORE
|
One can check syntax for RMAN commands without running the RMAN. Example: Checking syntax of commands on the command line.… READ MORE
|
Received ORA-19571 error when running of archive log process, and found the the parameter control_file_record_keep_time was set to 0 so… READ MORE
One of the features in 10g is flashback which allows to restores tables that were dropped. Note: If an index… READ MORE
|
Using the following SQL you can monitor the progress of RMAN process, as channels completes creating the backpiece new sessions… READ MORE
|
If you are using the RMAN and using the RMAN catalog to write directly to tape you can use the… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 