www.noraclever.com
Open in
urlscan Pro
2606:4700:3032::6815:1bd3
Public Scan
Submitted URL: https://noraclever.com/
Effective URL: https://www.noraclever.com/
Submission: On July 29 via api from US — Scanned from DE
Effective URL: https://www.noraclever.com/
Submission: On July 29 via api from US — Scanned from DE
Form analysis 1 forms found in the DOM
GET https://www.noraclever.com/
<form role="search" method="get" action="https://www.noraclever.com/" class="wp-block-search__button-outside wp-block-search__text-button wp-block-search"><label class="wp-block-search__label screen-reader-text"
for="wp-block-search__input-3">Search</label>
<div class="wp-block-search__inside-wrapper "><input class="wp-block-search__input" id="wp-block-search__input-3" placeholder="" value="" type="search" name="s" required=""><button aria-label="Search"
class="wp-block-search__button wp-element-button" type="submit">Search</button></div>
</form>Text Content
Skip to content GET IN TOUCH: NORA@NORACLEVER.COM ORACLE RMAN BACKUPS AND REPORTING AND EXAMS * CREATE A DIRECTORY OBJECT AND GRANTING ACCESS – EXTERNAL TABLES First, create a directory object that points to the location of the file on disk: SQL> create directory example_dir as ‘/oradata/sales’; Grant READ and WRITE on the directory object to the user (your account or application account) that is accessing the directory object. SQL> grant read, write on directory example_dir to app_user; Create Table Then,… Read more... 07/20/2024 * EXTERNAL TABLE TYPES – EXTERNAL TABLES We just discussed the SQL*Loader type of external tables, and that is what is used by default. However, there are other types of external tables that each has its own access drivers and helps you work with the different data types you might be using. The types of external tables are as follows: • ORACLE_LOADER… Read more... 06/20/2024 * SQL*LOADER VS. EXTERNAL TABLES – EXTERNAL TABLES One general use of an external table is to employ SQL to load data from an OS file into a regular database table. This facilitates the loading of large amounts of data from files into the database. Almost anything you can do with SQL*Loader, you can achieve with external tables. An important difference is that… Read more... 05/20/2024 * RESTORING AND RECOVERING TO A DIFFERENT SERVER – RMAN BACKUPS AND REPORTING When you think about architecting your backup strategy, as part of the process, you must also consider how you are going to restore and recover. Your backups are only as good as the last time you tested a restore and recovery. A backup strategy can be rendered worthless without a good restore-and-recovery strategy. The last… Read more... 04/20/2024 * FLASHBACK DATABASE – RMAN BACKUPS AND REPORTING The Flashback Database brings the database back to a point in time in the past. Flashback Database uses information stored in flashback logs; it does not rely on restoring database files (as do cold backup, hot backup, and RMAN). Flashback Database is not a substitute for a backup of your database. If you experience a… Read more... 03/20/2024 * FLASHING BACK A TABLE TO A PREVIOUS POINT IN TIME – RMAN BACKUPS AND REPORTING If a table was erroneously deleted from, you have the option of flashing back the table to a previous point in time. The Flashback Table feature uses information in the undo tablespace to restore the table. The point in time in the past depends on your undo tablespace retention period, which specifies the minimum time… Read more... 02/20/2024 * FLASHBACK – RMAN BACKUPS AND REPORTING Although the RECOVER TABLE command is a nice enhancement, I recommend that if you have an accidentally dropped table, you first explore using the recycle bin or Flashback Table to Before Drop feature to restore the table. Or, if the table was erroneously deleted from, then use the Flashback Table feature to restore the table… Read more... 01/20/2024 * RESTORING TO A RESTORE POINT – RMAN BACKUPS AND REPORTING There are two types of restore points: normal and guaranteed. The main difference between a guaranteed restore point and a normal restore point is that a guaranteed restore point is not eventually aged out of the control file; a guaranteed restore point will persist until you drop it. Guaranteed restore points do require an FRA.… Read more... 12/20/2023 * PERFORMING LOG SEQUENCE–BASED RECOVERY – RMAN BACKUPS AND REPORTING Usually this type of incomplete database recovery is initiated because you have a missing or damaged archivelog file. If that is the case, you can recover only up to your last good archivelog file, because you cannot skip a missing archivelog. How you determine which archivelog file to restore up to (but not including) will… Read more... 11/20/2023 * DETERMINING THE TYPE OF INCOMPLETE RECOVERY – RMAN BACKUPS AND REPORTING Time-based restore and recovery are commonly used when you know the approximate date and time to which you want to recover your database. For instance, you may know approximately the time you want to stop the recovery process, but not a particular SCN. Log sequence-based and cancel-based recovery work well in situations in which you… Read more... 10/20/2023 Next Page RECENT POSTS * Create a Directory Object and Granting Access – External Tables07/20/2024 * External Table Types – External Tables06/20/2024 * SQL*Loader vs. External Tables – External Tables05/20/2024 * Restoring and Recovering to a Different Server – RMAN Backups and Reporting04/20/2024 * FLASHBACK DATABASE – RMAN Backups and Reporting03/20/2024 TAGS There’s no content to show here yet. COMMENTS No comments to show. Search Search GET IN TOUCH! Get the latest Oracle exsm Stady guide NORA@NORACLEVER.COM OFFICE@NORACLEVER.COM 54 158-6984 POSTS * CREATE A DIRECTORY OBJECT AND GRANTING ACCESS – EXTERNAL TABLES * EXTERNAL TABLE TYPES – EXTERNAL TABLES * SQL*LOADER VS. EXTERNAL TABLES – EXTERNAL TABLES * RESTORING AND RECOVERING TO A DIFFERENT SERVER – RMAN BACKUPS AND REPORTING * FLASHBACK DATABASE – RMAN BACKUPS AND REPORTING SOCIALS * @facebook * @instagram * @youtube * @tiktok * Twitch © 2024 Oracle RMAN Backups and Reporting and Exams • Powered by WPKoi Scroll back to top