Home » RDBMS Server » Backup & Recovery » Reset SCN (oracle 12c Windows 2012)
Reset SCN [message #651033] Tue, 10 May 2016 06:12 Go to next message
muktha_22
Messages: 526
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 #651034 is a reply to message #651033] Tue, 10 May 2016 06:22 Go to previous messageGo to next message
EdStevens
Messages: 902
Registered: September 2013
Senior Member
What makes you think resetting the scn would solve anything?

Quote:

O/S-Error: (OS 1392) The file or directory is corrupted and unreadable.


The OS is reporting a corruption or other issue with the directory into which it is supposed to write the backupsets. THAT is what you need to be addressing. It appears you've obfuscated the path specification when you posted, though I don't know why. But whatever you had for <path> in your actual code -- that directory needs to be investigated.
Re: Reset SCN [message #651036 is a reply to message #651033] Tue, 10 May 2016 07:16 Go to previous messageGo to next message
John Watson
Messages: 7262
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 messageGo to next message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
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 messageGo to next message
muktha_22
Messages: 526
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 #651092 is a reply to message #651091] Wed, 11 May 2016 01:55 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The question is why do you want to reset the SCN?


Re: Reset SCN [message #651135 is a reply to message #651092] Wed, 11 May 2016 23:41 Go to previous messageGo to next message
muktha_22
Messages: 526
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 #651136 is a reply to message #651135] Wed, 11 May 2016 23:44 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You don't need any archived log if you don't lose a data file.

[Updated on: Thu, 12 May 2016 04:24]

Report message to a moderator

Re: Reset SCN [message #651149 is a reply to message #651136] Thu, 12 May 2016 03:11 Go to previous messageGo to next message
muktha_22
Messages: 526
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 #651150 is a reply to message #651149] Thu, 12 May 2016 03:13 Go to previous messageGo to next message
John Watson
Messages: 7262
Registered: January 2010
Location: Global Village
Senior Member
What do you mean by "reset SCN" ? It is not a term that means anything to me.



Re: Reset SCN [message #651154 is a reply to message #651149] Thu, 12 May 2016 03:30 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
muktha_22 wrote on Thu, 12 May 2016 10:11
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


Once again what is the relation between "i want to make a full backup with archive log all, But I have lost some of archive log files." and "can we reset SCN and start the DB again"?

Re: Reset SCN [message #651158 is a reply to message #651154] Thu, 12 May 2016 04:23 Go to previous messageGo to next message
muktha_22
Messages: 526
Registered: December 2009
Senior Member
Hi Michel,

Which means, if I missed out any archive log file, will it be no problem?


Regards
Muktha
Re: Reset SCN [message #651159 is a reply to message #651158] Thu, 12 May 2016 04:24 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

http://www.orafaq.com/forum/mv/msg/200853/651136/#msg_651136

Re: Reset SCN [message #651175 is a reply to message #651158] Thu, 12 May 2016 06:26 Go to previous message
EdStevens
Messages: 902
Registered: September 2013
Senior Member
muktha_22 wrote on Thu, 12 May 2016 04:23
Hi 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?
Previous Topic: Rman Backup set specification slowness.
Next Topic: Rman Backup job report for all databases
Goto Forum:
  


Current Time: Wed Feb 21 17:59:26 CST 2018

Total time taken to generate the page: 0.01089 seconds