Is it possible to take Catalog Database Backup using RMAN? If Yes, How?
Latest Answer: Yes, you can perform backup of catalog database using RMAN with below steps:1. Start the RMAN with NOCATALOG option.2. Run the recovery catalog database in ARCHIVELOG mode.3. set the retention policy to a REDUNDANCY value greater than 1.4. Backup the ...
In catalog database, if some of the blocks are corrupted due to system crash, How will you recover?
Latest Answer: using RMAN BLOCK RECOVER command ...
You have taken a manual backup of a datafile using o/s. How RMAN will know about it?
Latest Answer: You have to catalog that manual backup in RMAN's repository by commandRMAN> catalog datafilecopy '/DB01/BACKUP/users01.dbf';restrictions:> Accessible on disk> A complete image copy of a single file ...
Where RMAN keeps information of backups if you are using RMAN without Catalog?
Latest Answer: CATALOG vs NOCATALOGthe difference is only, who maintains the backup records like,when is the last successful backup, incremental, differential,etc.,In CATALOG mode, another database (TARGET database) stores all the information.In NOCATALOG ...
How do you see information about backups in RMAN?
Latest Answer: Use this SQL to checkSQL> SELECT sid,totalwork,sofar FROM v$session_longops
WHERE sid=153;
Here give SID when back start it will show SID
...
How RMAN improves backup time?
Latest Answer: RMAN backup time consumption is very less than compared to regular online backup, as RMAN copies only modified blocks ...
What is the advantage of RMAN utility?
Latest Answer: Advantage over tradition backup system:1). copies only the filled blocks i.e. even if 1000 blocks is allocated to datafile but 500 are filled with data then RMAN will only create a backup for that 500 filled blocks.2). ...
Can a schema be restored in oracle 9i RMAN when the schema having numerous table spaces?
Latest Answer: RMAN gives the command to find all the tablespaces and hence the datafiles belonging to different schemas as:REPORT SCHEMA;This command lists all the schemas, tablespace names and the corresponding data files. After listing, we can restore the datafiles ...
List the encryption options available with RMAN?
Latest Answer: Configure encryption for database onConfigure encryption algorithm 'AES256' ...
What are the steps required to perform in $ORACLE_HOME for enabling the RMAN backups with netbackup or TSM tape library software?
Latest Answer: HI, I can expalin what are all the steps to take a rman backup with TSM tape library as follows1.Install TDPO (default path /usr/tivoli/tsm/client/oracle/)2.Once u installed the TDPO,automatically one link is created from TDPO directory ...
View page [1] 2 3 4 5 Next >>
Go Top
