Oracle database recovery Post: 302900333

Sponsored Content

Special Forums UNIX and Linux Applications Oracle database recovery Post 302900333 by rbatte1 on Tuesday 6th of May 2014 09:29:00 AM

05-06-2014

Moderator

Was the database idle at the time, i.e. the instance was shutdown or the tablespaces were all in backup mode?

When you say broken, do you mean:-

A disk has failed and you can replace it
The server is broken beyond repair and you are trying to re-create on another server you have or at a DR site
The server OS is corrupted and you need to recover

If you can tell us more about the scenario and what you have then maybe we can assist.

There is no shame here, we've all broken machines by being daft. It's how we learn and make sure we don't do it again, especially me Smilie

Don't worry about admitting a mistake. A single disk failure should have some sort of protection on it, so if that's the cause, then there is a lesson to learn.

Regards,
Robin

This User Gave Thanks to rbatte1 For This Post:

rbatte1

View Public Profile for rbatte1

Visit rbatte1's homepage!

Find all posts by rbatte1

3 More Discussions You Might Find Interesting

1. Solaris

Can't create database after Oracle Database installation

I installed Oracle 10 software on Solaris 11 Express, everything was fine execpt I can't create database using dbca.rsp file. I populated file with following options. OPERATION_TYPE = "createDatabase" GDBNAME = "solaris_user.domain.com" SID = "solaris_user" TEMPLATENAME = "General...

2. Solaris

Connecting to Oracle database

Hi guys, long time no typing :D I have problems when I try to connect to Oracle database from SQL Developer which is located on my Windows box. Server is running Solaris 11/11 and Oracle 11 enterprise. I can log in locally with sys account to database, start it up and shut it down but when I...

3. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL...

LEARN ABOUT HPUX

vxconfigbackupd

vxconfigbackupd(1M)													       vxconfigbackupd(1M)

NAME

       vxconfigbackupd - disk group configuration backup daemon

SYNOPSIS

       vxconfigbackupd [-l]

DESCRIPTION

       The vxconfigbackupd daemon automatically backs up information about a disk group's new configuration whenever the configuration is changed.

OPTIONS

       -l	 Logs backup daemon activities to the file /etc/vx/cbr/bkdaemonLog.

FILES

       /sbin/init.d/vxvm-recover
		 Startup file for vxconfigbackupd.

       /etc/vx/cbr/bk/dgname.dgid/dgid.dginfo
		 Location of backup file for disk group information.

       /etc/vx/cbr/bk/dgname.dgid/dgid.diskinfo
		 Location of backup file for disk attributes.

       /etc/vx/cbr/bk/dgname.dgid/dgid.binconfig
		 Location of backup file for binary configuration copy.

       /etc/vx/cbr/bk/dgname.dgid/dgid.cfgrec
		 Location of backup file for configuration records in vxprint -m format.

NOTES

       The vxconfigbackup command can be used to back up a disk group's configuration manually at any desired time.

       The  disk  group  configuration	backup and restore utilities do not save any data in the public region. This includes file system or other
       application data that is configured within VxVM objects.

       When a disk group is destroyed, its configuration backup information (including the backup directory) is also removed.  The only  exception
       to this behavior is when the disk group is in the precommit state of restoration.

       The  backup  directory should be large enough to accommodate copies of all the currently imported disk groups. The minimum recommended size
       of the backup directory is P * (N + 1) megabytes, where P is the private region in megabytes (by default, 32MB), and N  is  the	number	of
       disk  groups. The additional P megabytes is required to hold a temporary copy of the disk group configuration when a disk group is imported
       or a configuration change is made.

       The default backup directory is /etc/vx/cbr/bk.	The location of the backup directory can be configured	by  using  the	vxconfigbackup	-l
       backup_directory_path command.

SEE ALSO

       vxconfigbackup(1M), vxconfigrestore(1M)

VxVM 5.0.31.1							    24 Mar 2008 					       vxconfigbackupd(1M)