RMAN questions

 1) 1 MB table got dropped from 40TB of database , how do you recover it ?

2) How can we improve RMAN backup performance ? it was running fine till yesterday

3) Difference be/w HOT and COLD backup ?

4) how can cancel and resume RMAN backups ?

5) If we are taking a RMAN backup of 30TB and at 25TB backup failed due to network or any other issues ? do we have to start from beginning or we can resume ?

6) When we run RMAN duplicate command for 40TB and it failed at 38TB due to some error (network) , do we have to start from beginning or can we resume ?

7) I  have created a DB on Friday, on Sat Lvl -0 backup is taken , and from Monday Lvl -1 started , wednesday till 7 PM DB is running fine , 9:30 suddenly crashed? can we recover it to 9:30  or , if not why ? if yes then how ?

which is the best way to recover and (RMAN/FLASHBACK) , if yes till what time can we recover -- only till 7 PM or till 9:30 PM ? from where will it take the archives ? 

Do I have to just run "RESTORE DATABASE" followed by RECOVER database and alter database open ? Do these command work ? 

or OPEN database in resetlogs or until cancel ?

or we have to perfrom PITR ..using until SCN or until time / unitl sequence # ?

9) Alter database open with resetlogs, we use this only when we perform incomplete recovery

10) What is complete recovery and PITR ?

11) when we take RMAN full BACKUP and trying to restore a new database , the most important thing is redo logs location  must be changed in target database ( to get the database in open mode ) and new  temp tbs needs to be created  (this scenario for only restoring a new db with rman full backup )

12) how to take encrypted rman backup? how to decrypt it ?

13) what is RMAN fileperset ?

14) For RAMN backups what Shared Area is used ? =? Large pool 

15)  Tablespace PITR?

16) how rman and flashback techniques recover database or table or tablespace ( from where they get the data/datafile , especially flashback technique) , if we do not have a separate catalog from where RMAN get the files to recover a database ]

17) flashback database to SCN#? how to i get the SCN# ? if human error happened a week ago , could be table dropped /truncated / incorrect data deleted --> flashback table to before drop  [ if it exists in recyclebin  his command works .. and if it doesn't exist then how do i get the table ]?

18) how to recover system/data/control file ?

19) how to increate the performance of Incr backups --> BCT (Block Change Tracking) 

20) can we take rman backup in Noarchivelog Mode?

To create a cold backup of the database running in noarchivelog mode using RMAN, the database should be mounted but not opened.  If the database is backed up in the open state, the following error will appear:

RMAN> backup database;
<....... output trimmed .......>
<....... output trimmed .......>
RMAN-00571: ===========================================================
RMAN-00569: =============== error message stack follows ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at
03/09/2010 02:01:14
ORA-19602: cannot backup or copy active file in noarchivelog mode

The following script shuts down the database and start it in mount mode, and then creates a backup of the database:

RMAN> run
2> {
3> shutdown immediate
4> startup mount
5> backup database;
6> }