Home » RDBMS Server » Backup & Recovery » RMAN doubt  () 1 Vote
RMAN doubt [message #276343] Wed, 24 October 2007 22:52 Go to next message
navaneethdba
Messages: 71
Registered: July 2007
Location: chennai
Member
Hi,

I am running Oracle10g in WindowsNT server.

My scenario:
I am taking incremental level 0 database once in a month and taking level 1 database backup once in a week and level 2 database backup daily.

But my doubt is, Does 10g supports level 2 backups.

I am taking level 2 database backups daily it is sucessfull. Will it be usefull in case of any recovery?

TIA

Report message to a moderator

Re: RMAN doubt [message #276345 is a reply to message #276343] Wed, 24 October 2007 23:01 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Will it be useful in case of any recovery?
What does your recovery procedure say to do?
What results have you obtained from doing a test recovery using documented recovery procedures?

Taking "backups" without ever testing recovery,
is like going sailing with a life raft that has NEVER been inflated to demonstrate it will actually float.

What would happen if you were told by someone here that your backups are A-OK, but next week your server melts down & you can not RECOVER?
Who takes the blame, you or the person who gave you incorrect advice?

[Updated on: Wed, 24 October 2007 23:09] by Moderator

Report message to a moderator

Re: RMAN doubt [message #276350 is a reply to message #276343] Wed, 24 October 2007 23:07 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:

I am taking level 2 database backups daily it is sucessfull

How in 10g? Demonstrate.

Report message to a moderator

Re: RMAN doubt [message #276355 is a reply to message #276350] Wed, 24 October 2007 23:51 Go to previous messageGo to next message
navaneethdba
Messages: 71
Registered: July 2007
Location: chennai
Member

@Arju : 


RMAN> run 
2> { 
3> allocate channel c1 device type disk format='f:\backup\INCR_OCT25\db_%u_%p_%s'; 
4> backup incremental level 2 database plus archivelog not backed up delete input; 
5> } 
6> 
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: sid=96 devtype=DISK


Starting backup at 25-OCT-07
current log archived
channel c1: starting archive log backupset
channel c1: specifying archive log(s) in backup set
input archive log thread=1 sequence=4260 recid=2110 stamp=636795142
input archive log thread=1 sequence=4261 recid=2111 stamp=636795176
input archive log thread=1 sequence=4262 recid=2112 stamp=636795230
input archive log thread=1 sequence=4263 recid=2113 stamp=636796836
input archive log thread=1 sequence=4264 recid=2114 stamp=636808355
input archive log thread=1 sequence=4265 recid=2115 stamp=636809661
input archive log thread=1 sequence=4266 recid=2116 stamp=636816764
input archive log thread=1 sequence=4267 recid=2117 stamp=636828917
input archive log thread=1 sequence=4268 recid=2118 stamp=636840054
input archive log thread=1 sequence=4269 recid=2119 stamp=636847768
input archive log thread=1 sequence=4270 recid=2120 stamp=636861611
channel c1: starting piece 1 at 25-OCT-07
channel c1: finished piece 1 at 25-OCT-07
piece handle=F:\BACKUP\INCR_OCT25\DB_BOIVBF5D_1_376 tag=TAG20071025T020012 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:35
channel c1: deleting archive log(s)
archive log filename=E:\ORACLE\LOG_ARCHIVE\1_4260_613824565.DBF recid=2110 stamp=636795142
archive log filename=E:\ORACLE\LOG_ARCHIVE\1_4261_613824565.DBF recid=2111 stamp=636795176
archive log filename=E:\ORACLE\LOG_ARCHIVE\1_4262_613824565.DBF recid=2112 stamp=636795230
archive log filename=E:\ORACLE\LOG_ARCHIVE\1_4263_613824565.DBF recid=2113 stamp=636796836
archive log filename=E:\ORACLE\LOG_ARCHIVE\1_4264_613824565.DBF recid=2114 stamp=636808355
archive log filename=E:\ORACLE\LOG_ARCHIVE\1_4265_613824565.DBF recid=2115 stamp=636809661
archive log filename=E:\ORACLE\LOG_ARCHIVE\1_4266_613824565.DBF recid=2116 stamp=636816764
archive log filename=E:\ORACLE\LOG_ARCHIVE\1_4267_613824565.DBF recid=2117 stamp=636828917
archive log filename=E:\ORACLE\LOG_ARCHIVE\1_4268_613824565.DBF recid=2118 stamp=636840054
archive log filename=E:\ORACLE\LOG_ARCHIVE\1_4269_613824565.DBF recid=2119 stamp=636847768
archive log filename=E:\ORACLE\LOG_ARCHIVE\1_4270_613824565.DBF recid=2120 stamp=636861611
Finished backup at 25-OCT-07

Starting backup at 25-OCT-07
channel c1: starting incremental level 2 datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00016 name=E:\ORACLE\DATABASE\LIVEDATA02.DBF
input datafile fno=00017 name=F:\ORACLE\DATABASE\TESTDATA05.DBF
input datafile fno=00004 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\USERS01.DBF
input datafile fno=00006 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\TESTDATA01.DBF
input datafile fno=00018 name=E:\ORACLE\DATABASE\LIVEDATA03.DBF
input datafile fno=00013 name=E:\ORACLE\DATABASE\LIVEDATA01.DBF
input datafile fno=00011 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\TRANSACTIONDATA.DBF
input datafile fno=00007 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\TESTDATA02.DBF
input datafile fno=00008 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\TESTDATA03.DBF
input datafile fno=00009 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\TESTDATA04.DBF
input datafile fno=00010 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\TESTDATA06.DBF
input datafile fno=00012 name=E:\ORACLE\DATABASE\MASTERDATA.DBF
input datafile fno=00002 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\UNDOTBS01.DBF
input datafile fno=00014 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\SYSAUX02.DBF
input datafile fno=00015 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\SYSTEM02.DBF
input datafile fno=00001 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\SYSTEM01.DBF
input datafile fno=00003 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\SYSAUX01.DBF
input datafile fno=00005 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\EXAMPLE01.DBF
channel c1: starting piece 1 at 25-OCT-07
channel c1: finished piece 1 at 25-OCT-07
piece handle=F:\BACKUP\INCR_OCT25\DB_BPIVBF6J_1_377 tag=TAG20071025T020050 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:25
channel c1: starting incremental level 2 datafile backupset
channel c1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel c1: starting piece 1 at 25-OCT-07
channel c1: finished piece 1 at 25-OCT-07
piece handle=F:\BACKUP\INCR_OCT25\DB_BQIVBF7D_1_378 tag=TAG20071025T020050 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:03
Finished backup at 25-OCT-07


Recovery Manager complete.


@anacedent

Ya that's true. But we dont have a test server its an development server.So i couldnt test it.

TIA

Report message to a moderator

Re: RMAN doubt [message #276356 is a reply to message #276343] Wed, 24 October 2007 23:56 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Who falls on the sword when the DB can NOT be recovered?
The choice is yours.

Report message to a moderator

Re: RMAN doubt [message #276360 is a reply to message #276356] Thu, 25 October 2007 00:05 Go to previous messageGo to next message
navaneethdba
Messages: 71
Registered: July 2007
Location: chennai
Member
Thanks for reply...

I have a choice to test, but it is an Express Edition 10g R2
in my home PC.
Will it differ ? plz Advice..

TIA

Report message to a moderator

Re: RMAN doubt [message #276362 is a reply to message #276343] Thu, 25 October 2007 00:09 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
ANY & every successful recovery is a GOOD learning experience as you know what works.
Every unsuccessful recovery is a GOOD learning experience as you know what does not work.
Just hope what is unsuccessful recovery does not happen for real in a recovery of a Production DB

Report message to a moderator

Re: RMAN doubt [message #276366 is a reply to message #276362] Thu, 25 October 2007 00:28 Go to previous messageGo to next message
navaneethdba
Messages: 71
Registered: July 2007
Location: chennai
Member
WOW! Smile
Thats a great Advice!!.
Thankx for ur reply...

Report message to a moderator

icon1.gif  Re: RMAN doubt [message #276941 is a reply to message #276343] Sat, 27 October 2007 03:57 Go to previous messageGo to next message
charymet
Messages: 2
Registered: October 2007
Location: india
Junior Member
hai, tell me about oracle financial applications
thanking u bai

Report message to a moderator

Re: RMAN doubt [message #276968 is a reply to message #276941] Sat, 27 October 2007 09:36 Go to previous message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
charymet,

read and follow OraFAQ Forum Guide.

Don't hijack a topic.
Post in the correct forum.
Don't use IM speak.

Regards
Michel

[Updated on: Sat, 27 October 2007 09:37]

Report message to a moderator

Previous Topic: from disk to tape
Next Topic: flashback table to timestamp
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 20 09:31:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.