DROP DATAFILES and CONTENTS [message #400599] |
Wed, 29 April 2009 01:24 |
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 #400611 is a reply to message #400606] |
Wed, 29 April 2009 02:08 |
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
|
|
|
|
|
|