Cold Backup Restore Test Result Not As Expected
Hello -
Please review my cold backup and restore steps, I expected my test table to be restored, it was not. What am I missing?
Database is in NOARCHIVELOG mode.
1. CREATE TABLE AXIUM.UCHC_TEST_RCAT_UPG ( EMPNO number(9), EMPNAME varchar2(30));
inserted 3 rows and commited
2. Cold Backup
run
{
shutdown immediate;
startup mount;
backup database;
alter database open;
}
3. Dropped test table created in #1
4. Restore Database
RMAN> SHUTDOWN IMMEDIATE ;
RMAN> SET DBID 2491357226;
RMAN> STARTUP NOMOUNT;
RMAN> RESTORE CONTROLFILE FROM "G:\backup\DAXMT001\rman\C-2491357226-20150911-00";
RMAN> ALTER DATABASE MOUNT;
RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE;
RMAN> ALTER DATABASE OPEN RESETLOGS ;
5. Select from Table