Home » RDBMS Server » Backup & Recovery » backup
backup [message #243864] Sun, 10 June 2007 03:20 Go to next message
kishore_dba
Messages: 21
Registered: March 2007
Location: HYDERABAD
Junior Member
hi all,
when i make a tablespace offline immediate then it is nessasary to take a backup.
2.how can we take the backup of controlfile in rman.
3.can we resize the redolog files.
4.can we make temporary tablespace offline.
5.when iam trying to open a database i got an error that a datafile block is correpted.that datafile not belongs to system tablespace.then how can i recover the database.

regards,
Kishore.
Re: backup [message #243868 is a reply to message #243864] Sun, 10 June 2007 07:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What about taking time and reading administrator's guide?

Regards
Michel
Re: backup [message #243899 is a reply to message #243864] Sun, 10 June 2007 22:42 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Laughing Nice answer...Thanks to michel.
Re: backup [message #244086 is a reply to message #243899] Mon, 11 June 2007 10:05 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
when i make a tablespace offline immediate then it is nessasary to take a backup.


OFFLINE or backupmode
Quote:
2.how can we take the backup of controlfile in rman.

RMAN> BACKUP CURRENT CONTROLFILE;
Quote:
3.can we resize the redolog files

yes add new drop previous
Quote:
4.can we make temporary tablespace offline.

No .
Quote:
5.when iam trying to open a database i got an error that a datafile block is correpted.that datafile not belongs to system tablespace.then how can i recover the database.


from your backup.

[Updated on: Mon, 11 June 2007 10:31]

Report message to a moderator

Previous Topic: Primary and Standby on different bit Architecture
Next Topic: Live instance problem 9.2
Goto Forum:
  


Current Time: Tue May 14 11:13:40 CDT 2024