Home » RDBMS Server » Server Utilities » Closed Backup Error
Closed Backup Error [message #72398] Sun, 08 June 2003 11:52
Hiren Patel
Messages: 10
Registered: May 2002
Junior Member
I want to ask one question regardind closed backup.I am writing the steps what i am trying to take closed backup.but i get an error of MEDIA RECOVERY.So please tell me wherer i am wrong.
1) Invoke SVRMGRL and connect as internal/oracle as sysdba
2) Creating a Test tablespace named T1
3) Creating a table in T1 tablespace
4) inserting 15000 rows and commit
5) after by shutting the database i take full backup to c:backup
6) Invoke SVRMGRL and connect as internal/oracle as sysdba
7) inserting 25000 rows and commit
8) after by shutting the database i remove the tablespace T1
9) Invoke SVRMGRL and connect as internal/oracle as sysdba
10) startup ( At this time database will not open)
11) so i restore the tablespace from c:backup
12) alter database rename file 'c:oracleoradataorclt1.dbf' TO 'c:backupt1.ora';
13) alter database open;(At this stage database is not opening,so i am doing the recovery of datafile which i previously removed,but it makes recovery through redo log files,so what happens the record which i insert after taking backup are also coming.i want only the records which was at the time of backup.
Please help me if u know it's urgent
take care
jsk
Previous Topic: Imp/Exp
Next Topic: Email from a stored procedure
Goto Forum:
  


Current Time: Tue Dec 24 07:56:50 CST 2024