Reset SCN [message #651033] |
Tue, 10 May 2016 06:12 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
muktha_22
Messages: 527 Registered: December 2009
|
Senior Member |
|
|
Hi All,
One of our client setup has a DB in RAC environment.
For past 15 days, they haven't taken any backup, now while taking the backup, it shows the below error message.
Now, we dont care of the backup, so how we can reset the SCN from zero and start the DB as a new?
Is it possible with OPEN RESETLOG option.
Here is the error message:
RMAN> connect target *
2>
3>
4> run
5> {
6> allocate channel dev1 type disk format '<path>\db_t%t_s%s_p%p';
7> allocate channel dev2 type disk format '<path>\db_t%t_s%s_p%p';
8> backup database FILESPERSET 20 ;
9> BACKUP archivelog all ;
10> delete noprompt archivelog all completed before 'sysdate-1';
11> release channel dev1 ;
12> release channel dev2 ;
13> }
14>
connected to target database: <name> (DBID=<No>)
using target database control file instead of recovery catalog
allocated channel: dev1
channel dev1: SID=**** instance=***** device type=DISK
RMAN-06908: WARNING: operation will not run in parallel on the allocated channels
RMAN-06909: WARNING: parallelism require Enterprise Edition
allocated channel: dev2
channel dev2: SID=***** instance=***** device type=DISK
Starting backup at *****
channel dev1: starting full datafile backup set
channel dev1: specifying datafile(s) in backup set
input datafile file number=00003 name=+ASMDATA1/*****/DATAFILE/sysaux.258.889443793
input datafile file number=00001 name=+ASMDATA1/*****/DATAFILE/system.259.889443865
input datafile file number=00005 name=+ASMDATA1/*****/DATAFILE/undotbs1.261.889443941
input datafile file number=00002 name=+ASMDATA1/*****/DATAFILE/undotbs2.266.889444133
input datafile file number=00011 name=+ASMDATA1/*****/DATAFILE/*****_sysconfg.275.890487605
input datafile file number=00006 name=+ASMDATA1/*****/DATAFILE/users.260.889443941
input datafile file number=00013 name=+ASMDATA1/*****/DATAFILE/*****_trans_2
channel dev1: starting piece 1 at 1*****
released channel: dev1
released channel: dev2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on dev1 channel at 05/10/2016 14:09:46
ORA-19504: failed to create file "*****\DB_T911484584_S924_P1"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 1392) The file or directory is corrupted and unreadable.
Recovery Manager complete.
Kindly give me some idea.
Regards
Muktha
|
|
|
|
Re: Reset SCN [message #651036 is a reply to message #651033] |
Tue, 10 May 2016 07:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8964 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Quote:Now, we dont care of the backup, so how we can reset the SCN from zero and start the DB as a new?
Are you saying that you want to replace this database with a new one? That should take you less than an hour. But I do not see that would help with the problem you have shown.
|
|
|
Re: Reset SCN [message #651039 is a reply to message #651033] |
Tue, 10 May 2016 07:33 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Quote:Is it possible with OPEN RESETLOG option.
Did you try?
But as John I don't see the relation between the error and your desire to reset SCN. Explain.
[Updated on: Tue, 10 May 2016 07:34] Report message to a moderator
|
|
|
Re: Reset SCN [message #651091 is a reply to message #651039] |
Wed, 11 May 2016 01:53 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
muktha_22
Messages: 527 Registered: December 2009
|
Senior Member |
|
|
Hi All,
Extremely sorry for the wrong understanding and the question I have made.
This was purely hard disk error.
After we did "CHECK DISK" that error was gone away. Then we made the backup successfully.
Thanks for the support.
In any case, if i want to reset the SCN:
Is it possible if I open the DB in RESETLOGS, make the db work properly from the SCN no of 1.
Regards
Muktha
|
|
|
|
Re: Reset SCN [message #651135 is a reply to message #651092] |
Wed, 11 May 2016 23:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
muktha_22
Messages: 527 Registered: December 2009
|
Senior Member |
|
|
Hi Michel,
In case, if I dont have backup and I am lost with a archive log file before taking it in to the current backup.
So can we reset SCN at this scenario?
Regards
Muktha
|
|
|
|
Re: Reset SCN [message #651149 is a reply to message #651136] |
Thu, 12 May 2016 03:11 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
muktha_22
Messages: 527 Registered: December 2009
|
Senior Member |
|
|
Hi Michel,
I meant, If i want to make a full backup with archive log all,
But I have lost some of archive log files.
Then, can we reset SCN and start the DB again.
Regards
Muktha
|
|
|
|
|
|
|
Re: Reset SCN [message #651175 is a reply to message #651158] |
Thu, 12 May 2016 06:26 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](//www.gravatar.com/avatar/d29f577f753cb4b873212fd5ed0da4cd?s=64&d=mm&r=g) |
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
muktha_22 wrote on Thu, 12 May 2016 04:23Hi Michel,
Which means, if I missed out any archive log file, will it be no problem?
Regards
Muktha
If you are missing an archive log, you will not be able to recover your database through that missing archivelog. You will only be able to recover to a point in time prior to the missing archivelog. And any such recovery will require opening with the 'resetlogs' option.
But, one more time, what does that have to do with wanting reset SCN to zero.
What do you think would be accomplished by resetting the scn to zero, even if you could?
|
|
|