OraFAQ Forum: Backup & Recovery » Backup&Recovery misunderstanding

Home » RDBMS Server » Backup & Recovery » Backup&Recovery misunderstanding

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Backup&Recovery misunderstanding [message #122018]

Thu, 02 June 2005 07:00

kaa2005
Messages: 4
Registered: June 2005

Junior Member

Hi.
I want to backup my database.
To perform this I use RMAN as:

rman.exe TARGET sys/sys@global

RMAN > allocate channel Channel1 type disk format 'f:\b_%u_%p_%c';
backup
( database include current controlfile );

backup ( archivelog all delete input );
}

Frankly speaking I don't quite understand these commands.

Than I make some modifications, for example, I create a new table called MYSCHEMA.TABLE1.

Then I perform recovery:
RMAN> restore database;

After that I can still see MYSCHEMA.TABLE1 in my Enterprise Manager Console.

Why ?

I performed full database recovery (MYSCHEMA.TABLE1 was not created at that moment) so
as far as I understand MYSCHEMA.TABLE1 must NOT SURVIVE the recovery.

Thanks.

Report message to a moderator

Re: Backup&Recovery misunderstanding [message #122022 is a reply to message #122018]

Thu, 02 June 2005 07:17

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

For a better understanding of backup & recovery in Oracle pls go thru these in sequence:

Backup & Recovery Concepts:
http://www.stanford.edu/dept/itss/docs/oracle/9i/server.920/a96519/toc.htm

Backup & Recovery using RMAN:
http://www.stanford.edu/dept/itss/docs/oracle/9i/server.920/a96566/toc.htm

User managed Backup & Recovery:
http://www.stanford.edu/dept/itss/docs/oracle/9i/server.920/a96572/toc.htm

Report message to a moderator

Re: Backup&Recovery misunderstanding [message #122049 is a reply to message #122022]

Thu, 02 June 2005 10:11

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>RMAN> restore database;

>>After that I can still see MYSCHEMA.TABLE1 in my Enterprise Manager Console.

>>Why ?

That is the expected behaviour.
Restore database will restore will restore to point the database is backed up and also uses the information in archived logs ( if available in local disk ) to go past the backupsets.
So you must actually doing a TSPITR or tablespace point-in-time recovery.

Timepoint 1: take backup
Timepoint 2: nothing.
Timepoint 3: do changes ( create table T1).
Timepoint 4: restore database
check Database: you can see the table T1 . This is what you did.
Timepoint 4: resore to timepoint 2 ( after backup,before changes. This is TSPITR).
Spend some time in docs. It is all documented.

Report message to a moderator

Previous Topic:	Oracle 10g: Backup startegy
Next Topic:	ORA-03113: end-of-file on communication channel ..

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 03 08:32:56 CDT 2025