Home » RDBMS Server » Backup & Recovery » Moving 9i DB to new server(3 Merged) (Rman 9i, no catalog, Windows 2003 on a cluster. )
Moving 9i DB to new server(3 Merged) [message #559362] Mon, 02 July 2012 16:21 Go to next message
fnguy
Messages: 39
Registered: January 2006
Member
I've inherited a DB where they are going to do a restore this weekend.

The current DB admin is using a db restore (not a duplicate). RMAN with no catalog. The current issue is that the DB restores fine, but when we do a delete obsolete after our backups it's asking if we want to delete the data files....

I'm guessing this has something to do with the DBID...but happy to be wrong.

Can someone assist? Tahnks.
Moving 9i DB to new server [message #559365 is a reply to message #559362] Mon, 02 July 2012 16:30 Go to previous messageGo to next message
fnguy
Messages: 39
Registered: January 2006
Member
I've inherited a DB where they are going to do a restore this weekend.

The current DB admin is using a db restore (not a duplicate). RMAN with no catalog. The current issue is that the DB restores fine, but when we do a delete obsolete after our backups it's asking if we want to delete the data files....

I'm guessing this has something to do with the DBID...but happy to be wrong.

Can someone assist? Tahnks.


run {
allocate channel Channel1 type disk format 'F:\backup\prd\%d_%T_%s_%U.bak';
allocate channel Channel2 type disk format 'F:\backup\prd\%d_%T_%s_%U.bak';
allocate channel Channel3 type disk format 'F:\backup\prd\%d_%T_%s_%U.bak';
allocate channel Channel4 type disk format 'F:\backup\prd\%d_%T_%s_%U.bak';
backup check logical ( database );
backup check logical ( archivelog all not backed up 2 times );
backup check logical ( current controlfile );
}
allocate channel for maintenance device type disk;
delete archivelog until time 'sysdate - 2' backed up 2 times to disk;
delete obsolete device type disk;
Re: Moving 9i DB to new server [message #559366 is a reply to message #559365] Mon, 02 July 2012 17:04 Go to previous messageGo to next message
BlackSwan
Messages: 23189
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: Moving 9i DB to new server [message #559369 is a reply to message #559366] Mon, 02 July 2012 19:03 Go to previous messageGo to next message
fnguy
Messages: 39
Registered: January 2006
Member
I'm not sure what more you're looking for. It's 9i; I don't know how to determine the version to the fourth decimal though I'd suspect it's irrelevant. It's not R2, I believe, since that's what the previous DBA told me. We are running in a Windows 2003 enterprise server, Clustered.

Re: Moving 9i DB to new server [message #559370 is a reply to message #559369] Mon, 02 July 2012 19:08 Go to previous messageGo to next message
BlackSwan
Messages: 23189
Registered: January 2009
Senior Member
>I don't know how to determine the version to the fourth decimal though I'd suspect it's irrelevant.

SELECT * FROM V$VERSION;
Re: Moving 9i DB to new server [message #559371 is a reply to message #559370] Mon, 02 July 2012 19:14 Go to previous messageGo to next message
fnguy
Messages: 39
Registered: January 2006
Member
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
PL/SQL Release 9.2.0.8.0 - Production
"CORE 9.2.0.8.0 Production"
TNS for 32-bit Windows: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production
Re: Moving 9i DB to new server [message #559372 is a reply to message #559371] Mon, 02 July 2012 19:20 Go to previous messageGo to next message
BlackSwan
Messages: 23189
Registered: January 2009
Senior Member
V9 was obsoleted & unsupported long before Windows 2003 was released.
Why are you willing to upgrade the hardware, but unwilling to upgrade Oracle?
I have forgotten more about V9 operations, than I remember now.
I still don't know what problem needs to be solved.
Re: Moving 9i DB to new server [message #559373 is a reply to message #559372] Mon, 02 July 2012 19:38 Go to previous messageGo to next message
fnguy
Messages: 39
Registered: January 2006
Member
I just started at this company and they said this is what they need for a project going live ASAP. The dba has all the restore scripts working, but notified me that the "delete obsolete device type disk;" in the script posted earlier would actually delete the database files. I had a brief window to test and when I did the RMAN prompt notified me that it was going to delete all the database files. So, I'm trying to understand what's going on better and hoping someone can assist. Yes, I googled this for days before coming here. I have access to a 10G rman guide but I'm certainly no oracle DBA so I'm not confident I'm approaching this right, or possibly missing the obvious. The only recollection I have of RMAN is from many years ago.
Re: Moving 9i DB to new server [message #559374 is a reply to message #559373] Mon, 02 July 2012 19:48 Go to previous messageGo to next message
BlackSwan
Messages: 23189
Registered: January 2009
Senior Member
>but notified me that the "delete obsolete device type disk;"
>in the script posted earlier would actually delete the database files.

We agree that it is likely not what should occur.
If the offending line is commented out so it does not execute; what else needs to be done?
Re: Moving 9i DB to new server [message #559375 is a reply to message #559374] Mon, 02 July 2012 19:51 Go to previous messageGo to next message
fnguy
Messages: 39
Registered: January 2006
Member
If I comment out the line I believe the script works perfectly. I asked the dba about not running the option with "disk" and he said it would run fine, but if it were ever added then the issue would arise.
Re: Moving 9i DB to new server [message #559389 is a reply to message #559375] Tue, 03 July 2012 01:03 Go to previous messageGo to next message
John Watson
Messages: 4871
Registered: January 2010
Location: Global Village
Senior Member
Hi - I'm guessing (I don't have a 9i release 2 installatrion to test) but you could try running the DBNEWID to generate a new DBID. That might invalidate everything in the RMAN repository.
c:\users\john\home>
c:\users\john\home>where nid
c:\app\john\product\11.2.0\dbhome_1\BIN\nid.exe

c:\users\john\home>nid

DBNEWID: Release 11.2.0.3.0 - Production on Tue Jul 3 06:52:53 2012

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Keyword     Description                    (Default)
----------------------------------------------------
TARGET      Username/Password              (NONE)
DBNAME      New database name              (NONE)
LOGFILE     Output Log                     (NONE)
REVERT      Revert failed change           NO
SETNAME     Set a new database name only   NO
APPEND      Append to output log           NO
HELP        Displays these messages        NO


c:\users\john\home>
Re: Moving 9i DB to new server(3 Merged) [message #559488 is a reply to message #559362] Tue, 03 July 2012 10:27 Go to previous messageGo to next message
fnguy
Messages: 39
Registered: January 2006
Member
I'm wondering if the issue has cropped up because after the restore we issue an open database with reset logs.

Does anyone know if that could be the issue?

*Thanks for not trolling....
Re: Moving 9i DB to new server(3 Merged) [message #559663 is a reply to message #559488] Thu, 05 July 2012 07:21 Go to previous messageGo to next message
fnguy
Messages: 39
Registered: January 2006
Member
I believe we've found the issue and resolved. Here's what we've discovered:

The source server and the destination server were not the same file structure so we used "set newname" as part of the RMAN restore. When this occurs RMAN stores the name of the datafile as a ~Copy~ (found this in the 10G RMAN advanced documentation here under the "Mechanics of Datafile Restore Operations: http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmconc2.htm#i1006114 ). Thus, later when we ran our delete obsolete command RMAN was thinking the files were copies and could thus be removed.

The solution was to include a "SWITCH DATAFILE ALL" command and RMAN is now a happy camper.

Re: Moving 9i DB to new server [message #559664 is a reply to message #559389] Thu, 05 July 2012 07:22 Go to previous message
fnguy
Messages: 39
Registered: January 2006
Member
John, I posted the solution at the end of this thread. Thanks for taking the time to offer some thoughts.
Previous Topic: crosscheck backup
Next Topic: Taking a dump of huge table
Goto Forum:
  


Current Time: Sat Dec 27 12:43:18 CST 2014

Total time taken to generate the page: 0.08448 seconds