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: ...
You want to back up and active / (root) file system without unmounting it. What can you use to create a static image of the / (root) file system to use with a backup command? A. The tar command. B. The fssnap command. C. The snapsfs command. D. The ufsdump -s command.
Answer: B
1. shutdown (server waits until all transaction commit + wait until all sessions close)2. shutdown transaction (servers commit transaction + disconnect the users sessions)3. shutdown immediate (servers uncommit all transaction + rollback ...
To backup a table the only method is Export and Import.Exporting a table in one schema and importing into another schema.Ex:Exp scott/tiger file=scott.dmp log=scott.log tables=scott.emp imp system/manager file=scott.dmp log=scott.log ...
If enough drive space is available on the file server, you can use it to store backup copies of the files on your hard drive
Skill/Topic: Networking BasicsA) TrueB) False
I did not took backup for a database.My colleague had mad some changes to some Stored procedures and I want to roll back to the original codr.Since he did not used the begin transaction i am not able to rollback the changes.>How can I get back to my original code?
V$backup : This status column of this view shows whether a tablespace in hot backup mode.The status 'ACTIVE' shows the datafile to be in backup mode.V$datafile_header : The fuzzy column also helps a dba to monitor datafile which are in backup mode. ...
View page << Previous 1 2 [3] 4 5 6 7 8 9 10 Next >>
Go Top
