| Bishal |
Posted: May 02, 2008 04:46:15 AM |
Total Post: 207
Joined: Apr, 2008
|
how do we find out the SCN for restoring database..
any query for it? |
|
|
 Murtuja |
| Posted: May 02, 2008 04:56:16 AM |  |
|
Total Post: 857
Joined: Jan, 2006
|
First run this command
RMAN> list backup of archivelog all summary;
Note down highest key from output of above command.
Then
RMAN> list backupset highest_key
Next_SCN will give you SCN.
|
|
|
|
|
| GOPU |
| Posted: May 02, 2008 05:01:07 AM | |
|
Total Post: 333
Joined: Apr, 2008
|
suppose we are not using the RMAN backup ? how to find it ?
|
|
|
|
|
| Bishal |
| Posted: May 02, 2008 05:01:17 AM | |
|
Total Post: 207
Joined: Apr, 2008
|
thanx murtuja... so while recovering this is latest SCN right?
so we should use that right?
|
|
|
|
|
| Murtuja |
| Posted: May 02, 2008 05:03:18 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Hi Gopu,
We can find out SCN using below query.
SQL> SELECT archivelog_change#-1 FROM v$database;
|
|
|
|
|
| GOPU |
| Posted: May 02, 2008 05:04:51 AM | |
|
Total Post: 333
Joined: Apr, 2008
|
|
|
|
|
| Murtuja |
| Posted: May 02, 2008 05:18:02 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Hi,
SQL> SELECT current_scn FROM v$database;
will give current SCN.And I think it's more reliable then ARCHIVE_CHANGE#.
|
|
|
|
|
| Bishal |
| Posted: May 02, 2008 05:22:15 AM | |
|
Total Post: 207
Joined: Apr, 2008
|
there is no current_scn column in v$database;
|
|
|
|
|
| Murtuja |
| Posted: May 02, 2008 05:54:20 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Yes,"CURRENT_SCN" is not available in Oracle 9i.
|
|
|
|
|
| GOPU |
| Posted: May 02, 2008 06:02:04 AM | |
|
Total Post: 333
Joined: Apr, 2008
|
It is available from 10g only ?
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
