Hi.. I perfromed below steps in no archivelog database on version 11.2.0.3.
-- alter system checkpoint;
-- shutdown immediate;
-- startup pfile=/apps/opt/oracle/admin/pfile/initsacdit.ora;
-- alter system checkpoint;
-- executed below rman clodbackup script with TAG option
run {
shutdown immediate;
startup mount pfile=/apps/opt/oracle/admin/pfile/initsacdit.ora;
allocate channel prmy1 type disk format '/u15/oradata/backup/output/rman_bkp/full_cold_bkp_%d_%T_%U';
allocate channel prmy2 type disk format '/u15/oradata/backup/output/rman_bkp/full_cold_bkp_%d_%T_%U';
allocate channel prmy3 type disk format '/u15/oradata/backup/output/rman_bkp/full_cold_bkp_%d_%T_%U';
allocate channel prmy4 type disk format '/u15/oradata/backup/output/rman_bkp/full_cold_bkp_%d_%T_%U';
allocate channel prmy5 type disk format '/u15/oradata/backup/output/rman_bkp/full_cold_bkp_%d_%T_%U';
allocate channel prmy6 type disk format '/u15/oradata/backup/output/rman_bkp/full_cold_bkp_%d_%T_%U';
BACKUP CURRENT CONTROLFILE format '/u15/oradata/backup/output/rman_bkp/fullctrl_file_%d_%T_%U';
BACKUP AS BACKUPSET DATABASE TAG full_sacdit_May_23_2014_1907PM;
release channel prmy1;
release channel prmy2;
release channel prmy3;
release channel prmy4;
release channel prmy5;
release channel prmy6;
alter database open;
}
Finished backup at 23-MAY-14
released channel: prmy1
released channel: prmy2
released channel: prmy3
released channel: prmy4
released channel: prmy5
released channel: prmy6
database opened
Recovery Manager complete.
-- Now I dropped few tables from database and try to restore with below steps.
-- shutdown immediate;
-- startup mount pfile=/apps/opt/oracle/admin/apb/pfile/initsacdit.ora;
-- connect to rman -> rman target /
RMAN> run {
restore database from TAG="FULL_SACDIT_MAY_23_2014_1907PM";
}
channel ORA_DISK_3: restore complete, elapsed time: 00:04:55
Finished restore at 23-MAY-14
-- Try to open database;
RMAN> alter database open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 05/23/2014 20:44:36
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/oradata/system01.dbf'
-- Try to open with resetlogs option
RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 05/23/2014 20:45:17
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
-- recovering db
RMAN> recover database;
RMAN> recover database;
Starting recover at 23-MAY-14
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
starting media recovery
archived log for thread 1 with sequence 6633 is already on disk as file /u03/oradata/redolog/redo02.log
archived log file name=/u03/oradata/redolog/redo02.log thread=1 sequence=6633
media recovery complete, elapsed time: 00:00:02
Finished recover at 23-MAY-14
RMAN> alter database open resetlogs;
database opened
-- When I open database I am not able to see the tables that dropped after I took cold backup....?
-- is any thing wrong in above steps? why i am not able to get consistent cold backup and when restore database backup with TAG option not able to see the dropped tables?
Thanks.