Entries tagged as Oracle
Switch from an init.ora file to a spfile
How do you switch from an init.ora file to a spfile?
Issue the create spfile from pfile command.
Read More...
Restore from backup and do not have any control files
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
I would create a text based backup control file, stipulating where on disk all the data files where and then issue the recover command with the using backup control file clause.
Read More...
Difference between a hot backup and a cold backup
Explain the difference between a hot backup and a cold backup and the benefits associated with each.
A hot backup is basically taking a backup of the database while it is still up and running and it must be in archive log mode. A cold backup is taking a backup of the database while it is Read More...
Disable the parameter from while running the report
Is it possible to disable the parameter from while running the report?
Yes
Read More...