Home » Server Options » Data Guard » DROP DATAFILES and CONTENTS
DROP DATAFILES and CONTENTS [message #400599] Wed, 29 April 2009 01:24 Go to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
HI all,

I have a production database on oracle 10g. I have drop a tablespace on the production server. I have done a hotbackup using RMAN so that to replicate the change on my standby database.

My question is after deleting the tablespace on the production database, i am still able to apply the archivelog on my standby database. Furthermore i have just restore the hotbackup on my standby database. PLease see the extract below.

RMAN> restore database;

Starting restore at 29-APR-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1642 devtype=DISK

skipping datafile 1; already restored to file /data1/cnp/system.dbf
skipping datafile 2; already restored to file /data1/cnp/undotbs2.dbf
skipping datafile 3; already restored to file /data1/cnp/sysaux01.dbf
skipping datafile 4; already restored to file /data2/cnp/arch.dbf
skipping datafile 5; already restored to file /data1/cnp/cms.dbf
skipping datafile 6; already restored to file /data2/cnp/cnp.dbf
skipping datafile 7; already restored to file /data1/cnp/cnpind.dbf
skipping datafile 8; already restored to file /data1/cnp/cwmlite.dbf
skipping datafile 9; already restored to file /data1/cnp/drsys.dbf
skipping datafile 10; already restored to file /data2/cnp/eur1.dbf
skipping datafile 11; already restored to file /data1/cnp/indx.dbf
skipping datafile 12; already restored to file /data1/cnp/odm.dbf
skipping datafile 13; already restored to file /data2/cnp/portal.dbf
skipping datafile 14; already restored to file /data1/cnp/portalind.dbf
skipping datafile 16; already restored to file /data1/cnp/rocdata.dbf
skipping datafile 17; already restored to file /data1/cnp/rocind.dbf
skipping datafile 18; already restored to file /data1/cnp/tools.dbf
skipping datafile 19; already restored to file /data1/cnp/undotbs1.dbf
skipping datafile 20; already restored to file /data1/cnp/users01.dbf
skipping datafile 21; already restored to file /data2/cnp/wlportal.dbf
skipping datafile 22; already restored to file /data2/cnp/wlportalind.dbf
skipping datafile 23; already restored to file /data1/cnp/xdb.dbf
skipping datafile 24; already restored to file /data2/cnp/bankdata.dbf
skipping datafile 25; already restored to file /data2/cnp/bankind.dbf
skipping datafile 26; already restored to file /data1/cnp/mast.dbf
skipping datafile 27; already restored to file /data1/cnp/mccico.dbf
restore not done; all files readonly, offline, or already restored

what the information in BOLD means??

Still after restore, i am able to apply the archivelogs on the standby database.

Please help.


Sailesh
Re: DROP DATAFILES and CONTENTS [message #400606 is a reply to message #400599] Wed, 29 April 2009 01:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It means that nothing has to be done because everything is fine (from RMAN point of view).
As nothing has be done, your standby is in the same state than previously and so is able to apply logs.

Regards
Michel
Re: DROP DATAFILES and CONTENTS [message #400611 is a reply to message #400606] Wed, 29 April 2009 02:08 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi Michel,

Thanks for the reply. But the tablespace i dropped on my production database is still on my standby database. can i delete it using operating system command.

Thanks,

Sailesh
Re: DROP DATAFILES and CONTENTS [message #400612 is a reply to message #400611] Wed, 29 April 2009 02:12 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


No..

Please let us know STANDBY_FILE_MANAGEMENT Parameter value from primary and standby database.

Babu
Re: DROP DATAFILES and CONTENTS [message #400633 is a reply to message #400612] Wed, 29 April 2009 03:01 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi Babu,

On both servers (Primary & Standby ) the STANDBY_FILE_MANAGEMENT Parameter value is manual.

Thanks,

Sailesh
Re: DROP DATAFILES and CONTENTS [message #400640 is a reply to message #400633] Wed, 29 April 2009 03:26 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Ok.

Then look.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/manage_ps.htm#i1010512

Babu
Previous Topic: Fail over to Standby
Next Topic: In STB there is always one newer archive file more than in PRI
Goto Forum:
  


Current Time: Thu Mar 28 07:36:46 CDT 2024