| DROP DATAFILES and CONTENTS [message #400599] |
Wed, 29 April 2009 01:24  |
sailesh
Messages: 31
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  |
Michel Cadot
Messages: 28991
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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 |
sailesh
Messages: 31
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
|
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
