Home » RDBMS Server » Backup & Recovery » Incomplete recovery until Sequence
Incomplete recovery until Sequence [message #285513] Tue, 04 December 2007 23:24 Go to next message
vivacious
Messages: 5
Registered: December 2007
Junior Member
Hi Friends,

While going thru RMAN incomplete recovery I came a/c Incomplete recovery until Sequence;if I am not wrong this is same as Incomplete recovery until SCN,the example given in the book is quoted below:

RMAN> RUN {
2> SET UNTIL SEQUENCE 120 THREAD 1;
3> ALTER DATABASE MOUNT;
4> RESTORE DATABASE;
5> RECOVER DATABASE; # recovers through log 119
6> ALTER DATABASE OPEN RESESTLOGS;
7> }

In this example does sequence 120 stand for the SCN 120?What dos thread 1 signify?

Thanks in advance!!!
Re: Incomplete recovery until Sequence [message #285518 is a reply to message #285513] Tue, 04 December 2007 23:34 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

http://download.oracle.com/docs/cd/B14117_01/server.101/b10755/initparams211.htm#REFRN10216

If you using RAC then thread value is change like 1,2,3 otherwise it is always 1.
Re: Incomplete recovery until Sequence [message #285519 is a reply to message #285513] Tue, 04 December 2007 23:37 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:

In this example does sequence 120 stand for the SCN 120

No.
Re: Incomplete recovery until Sequence [message #285522 is a reply to message #285513] Tue, 04 December 2007 23:45 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

More about until clause,
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynta065.htm#i1000331
Previous Topic: ORA 12540
Next Topic: Scenarios When Control Files Are Lost
Goto Forum:
  


Current Time: Mon May 20 12:29:24 CDT 2024