Database Backup and Recovery (MOSC)

MOSC Banner

Cold Backup Restore Test Result Not As Expected

edited Sep 15, 2015 2:35PM in Database Backup and Recovery (MOSC) 8 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center