How do you find the total database size in the database, is there any command to see the database size or in os level?2.can we unload the data by using sql*loader?3.can we take incremental backup with out taking complete backup?
if we don;t have any backup of Controlfile...then we have to use create controlfile command.. ...
How many days, we are going to retain the data after taking the backup. For example the data which backed up today that will get expire in 90 days. That means, it is 90 days retention policy for backup ...
You can take a coldbackup from solaris and use it on windows NT?A) YesB) Yes, if RMAN backup performed from NT serverC) Yes, after running RMAN convertD) No
In oracle 9i we have some limitation with reqard to Backing up entire dataabase in one go. First we will have to take the database in mount stage (not open) in order to take the back up, and that too, one tablespace at a time. like:-sql>alter ...
What are different types of backup? (Hot, Cold, logical, Physical) Explain in detail.
logical backups are export dumps ...
WE can use backup the EME with air-repostory backup command from the command line mode. ...
A Partial Backup is any operating system backup short of a full backup, taken while the database is open or shut down.
A partial backup is an operating system backup of part of a database. The backup of an individual tablespace's datafiles or the backup of a control file are examples of partial backups. Partial backups are useful only when the database is in ARCHIVELOG ...
Logical backup involves reading a set of database records and writing them into a file. Export utility is used for taking backup and Import utility is used to recover from backup.
The simple example for logical backup is export and import. The logical backup involves in taking the snapshot of the database at that particular instance in terms of series of SQL statements which is not a byte-by-byte copy of the database. This is obvious ...
Taking backup of archive log files when database is open. For this the ARCHIVELOG mode should be enabled. The following files need to be backed up. All data
The database should be in Archive log mode to take hot backups.Step1: Shutdown the database gracefullyStep2: Take full backup of the databaseStep3: Edit the following intialization parameters likelog_archive_destlog_archive_formatlog_archive_startStep4: ...
View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
Go Top
